Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Multiple Criteria to filter for multiple users
Earlier in the week someone was kind enough to provide me with the following
code that allowed me to search for different numbers in a column and provide me with a answer of True or False. While that was extreme helpful, I was wondering if it is possible to search and depending on the values, return a person's name as shown below. =OR(D2=27028,D2=27076,D2=27286) Tim's =OR(D2=27310,D2=27312) Bobby's =OR(D2=27670,D2=28088,D2=28094) Alex =OR(D2=28291,D2=28386,D2=28488,D2=28630) Sally's Thank you for your assistance. Your help is Greatly Appreciated!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter duplicates by multiple criteria | New Users to Excel | |||
Filter Multiple Columns on Multiple Criteria and count the last co | Excel Worksheet Functions | |||
Best Way for Multiple Criteria to Show From a Filter | Excel Discussion (Misc queries) | |||
Filter a range of data with multiple criteria | Excel Discussion (Misc queries) | |||
Create macro to filter on multiple criteria | Excel Worksheet Functions |