| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
still searching for color text
Went to the processing colour website as instructed. The formula I need is
=SUMPRODUCT(--(ColorIndex(A2:A28,TRUE)=3)) However, it didn't work. I got *Name in the cell instead of the necessary number. I'm trying to search through a list of names (of which some are in blue) and get it to return the number of names that are in blue. Can you help. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Searching Columns | Excel Discussion (Misc queries) | |||
| Excel quits responding searching for files not in my documents | Excel Discussion (Misc queries) | |||
| Find (Ctrl +F) not searching all open sheets | Excel Worksheet Functions | |||
| Formula for Searching & matching two values in excel | Excel Discussion (Misc queries) | |||
| Searching for Substrings Within Strings | Excel Discussion (Misc queries) | |||
Threaded Mode
