| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checking if different items are in a list
I have a range with 1 column and 100 rows. Sometimes the range has some blank cells and sometimes it has items in it that may be the same or different. Is there a function that I can use to tell if the range has more than 1 different type value in it, excluding the blank cells? For example, if I have 5 rows with "apple" in that range and the rest are blank, I don't need to do anything. If I have 5 rows with "apple" and 3 rows with "grapes" in that range, then I want to know that does exist and display a message. -- LAF ------------------------------------------------------------------------ LAF's Profile: http://www.excelforum.com/member.php...fo&userid=9656 View this thread: http://www.excelforum.com/showthread...hreadid=500164 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make typing "jump" to matching item(s) in drop-down list? | Excel Discussion (Misc queries) | |||
| Checking for duplicate items in list | Excel Worksheet Functions | |||
| Numbering items from a list in order | Excel Discussion (Misc queries) | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
| Making list of items to truck monthly usage | Excel Discussion (Misc queries) | |||
Threaded Mode
