Jeff Volkhammer
asked on
Method to identify excluded values
PET-ACCOUNTS.xlsx Greetings, Experts!
I have a question that I suspect will be fairly simple for you.
I'm looking for a way to identify accounts where a value is NOT included. The attached excel file includes a list of fictitious accounts and pets residing with each. How can I use excel to understand which accounts do not have a value of 'HORSES'? Obviously with a file this size I could eyeball it, but the 'real' file I'm attempting to work with has many thousands of rows. Any help is appreciated!
I have a question that I suspect will be fairly simple for you.
I'm looking for a way to identify accounts where a value is NOT included. The attached excel file includes a list of fictitious accounts and pets residing with each. How can I use excel to understand which accounts do not have a value of 'HORSES'? Obviously with a file this size I could eyeball it, but the 'real' file I'm attempting to work with has many thousands of rows. Any help is appreciated!
You didn't attach your workbook. You may have forgotten to click 'Upload File' after choosing the file.
ASKER
Sorry, trying again.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you, Ejgil...this worked perfectly!