S
Scott
I have a series of data that I'm trying to create a reference for. For
example:
A B C D
1 2 3
2 4 1 5
3 2 1 4
4 3 2
5 1
Data in Column A is the name or search criteria. Columns B through ... is
the range of data I want to search. For this example, for the name or search
criteria of "3", I would like to return the number of names or search
criteria "3" appears in throughout the data range. So, for this example, 3
appears in names 1 and 4.
I tried the initial VLOOKUP search, but realized very quickly that this was
a little more complicated than that. I can have unlimited values, however
none will be duplicates.
Any ideas would be very helpful and much appreciated.
example:
A B C D
1 2 3
2 4 1 5
3 2 1 4
4 3 2
5 1
Data in Column A is the name or search criteria. Columns B through ... is
the range of data I want to search. For this example, for the name or search
criteria of "3", I would like to return the number of names or search
criteria "3" appears in throughout the data range. So, for this example, 3
appears in names 1 and 4.
I tried the initial VLOOKUP search, but realized very quickly that this was
a little more complicated than that. I can have unlimited values, however
none will be duplicates.
Any ideas would be very helpful and much appreciated.