Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Gang -
Not the end of the world (and I made a work around with a T/F helper column) but I was wondering if there is a way to use MATCH() to find an opposite condition. For example, I have a column of attributes. 98% of them are "Large", 2% of them are almost anything else, and not consistent. I was looking for a syntax sort of like: =MATCH(NOT("Large"),A:A,0) That's the idea, anyway, but that doesn't work ;-) Just curious. Thanks. ....best, Hash |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Match Function Problem - Won't Find Certain Numbers | Excel Discussion (Misc queries) | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Check data on colum A and find match on colum b | Excel Discussion (Misc queries) | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Find a match that;s not exact | Excel Worksheet Functions |