Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Do the values in a range of cells include all members of a set?
Suppose I'm assigning basebal positions with the set of strings, P, C, 1, 2,
3, SS, LF, CF, RF. After I've entered the 9 assignments, I want an indication that I have covered all 9 positions. I can have 9 nested if/match functions, but it seems like there should be a better way. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Macro to hide blank cells in a range | Excel Discussion (Misc queries) | |||
Find dates in a range; then sum values in that range by a criteria | Excel Discussion (Misc queries) | |||
Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
Count occurances in range of cells | Excel Worksheet Functions |