Davefromlondon
New Member
- Joined
- Feb 25, 2021
- Messages
- 9
- Office Version
- 2016
- Platform
- Windows
HI, I have between 1 and 50 columns in a sheet1
I have another column in another sheet2 - call this COL Z.
COL Z has a list of "terms" , each term in a row, maybe 30 terms in the list, maybe less, it can grow as I add terms manually in the future
COL 1 has a variable number of "names" on each row. Might be 1,2 or 20 or more names
I seek to compare COl 1 Names with COL z terms then sort Col 1 with name/term matches at the top of the column, then a space row, then list below those where there is no match
always 1 term or name per row but a name or term could be more than 1 word, maybe 2 or 3 words
Repeat for Col 2
Repeat till last column (less than col 50)
in other words.... compare a column 1 with a fixed column Z, sort Col1 with "matches with Z" at the upper end of the column, a blank row, then the non-matches
I have another column in another sheet2 - call this COL Z.
COL Z has a list of "terms" , each term in a row, maybe 30 terms in the list, maybe less, it can grow as I add terms manually in the future
COL 1 has a variable number of "names" on each row. Might be 1,2 or 20 or more names
I seek to compare COl 1 Names with COL z terms then sort Col 1 with name/term matches at the top of the column, then a space row, then list below those where there is no match
always 1 term or name per row but a name or term could be more than 1 word, maybe 2 or 3 words
Repeat for Col 2
Repeat till last column (less than col 50)
in other words.... compare a column 1 with a fixed column Z, sort Col1 with "matches with Z" at the upper end of the column, a blank row, then the non-matches