compare values multiple columns

[allaud]

I would like to compare values in name columns A, C, E, G,where at least 1 match is found add the name, associated value in the visits column(s) to a table in new sheet. Please see the attached xls. Any suggestions would be greatly appreciated.

[NBVC]

It is not clear what you want here.

What do you mean by "where at least 1 match is found add the name..."? A match to what?

What are some expected results based on your sample data?

[allaud]

It is not clear what you want here.

What do you mean by "where at least 1 match is found add the name..."? A match to what?

What are some expected results based on your sample data?

Thank You NBVC.

would like to compare names in col A, C, E & G and display results found in the col to the right of name cell in a new worksheet in table named result. Where there were no records in visits col add "0" in the results cell. I have included expected results in "expected results" tab in updated ver of the example spreadsheet. Hope this clarifies. Appreciate your help.

[NBVC]

After listing the Unique names in column A (starting at A3), try:

Please Login or Register  to view this content.

copied down and across

This looks at every group of 2 columns in the data sheet and compares to values in column A and extracts corresponding numbers...

[allaud]

After listing the Unique names in column A (starting at A3), try:

Please Login or Register  to view this content.

copied down and across

This looks at every group of 2 columns in the data sheet and compares to values in column A and extracts corresponding numbers...

Thank you worked.

[NBVC]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save