Avatar of Jeff Volkhammer
Jeff Volkhammer
Flag for United States of America

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!
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Jeff Volkhammer

8/22/2022 - Mon