I have a quick example that I was wondering if there is a more efficient formula for
expectedoutcolumn - "match" for each unique name in column A, if any of those unique records have a match in column2 to the inputed number
[inputed number:](can change) [10]
A B ....... C ....... expectedoutputColumn
AA 10 ..... match.... match
AA 11 ....... 0....... match
AA 12 ....... 0 ....... match
BB 09 ...... 0.......
CC 10 .... match .... match
CC 11 ....... 0 ....... match
CC 13 ....... 0 ....... match
DD 15 ....... 0 .......
rules: colum C 'match' will always be the first record; column A will be sorted
current formula that works: IF(C2="match","match",IF(D1="match",IF(A2=A1,"match",""),""))
edit:
Bookmarks