| Home |
| Search |
| Today's Posts |
|
#10
|
|||
|
|||
I guess this is just one of those unexplainable nuances that Excel throws at
us every now and then! Biff "Domenic" wrote in message ... In article , "Biff" wrote: Got it! =INDEX(List,MATCH(0,INDEX(COUNTIF(A$1:A1,List),,1) ,0)) Nice! So it looks like the reason COUNTIF(...) alone doesn't work is that it actually returns a single value, whereas INDEX(COUNTIF(...),,1) returns a single element array. So maybe the reason why... =MATCH(0,A1,0) ...works is that the reference to A1 is actually considered a single element array. Does it make sense? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - return a picture or range rows as the result of a formula | Excel Worksheet Functions | |||
| check if reference exists, then return its value or return 0 | Excel Worksheet Functions | |||
| How do create a formula to evalute a # to return 1 of 4 conditions | Excel Worksheet Functions | |||
| Using a Vlookup to return values in a data list? | Excel Worksheet Functions | |||
| if the value of a cell in a range is not blank, then return the v. | Excel Worksheet Functions | |||
Threaded Mode
