Apply an AutoFilter to your list. Filter column A for "DD". Look a the column B drop down list for entries other than "Real Estate". Do the same for "DS" and "Private Equity".On 2002-06-25 14:02, Bing wrote:
I would like to know if anyone can help me with the following problem: Column A contains values such as DD, DS and LP and Column B contains values such as Real Estate, Private Equity and General Industry. I want to make sure that each DD corresponds to Real Estate and each DS corresponds to Private Equity. Is there anyway to figure it out without going through every row in the spreadsheet? Thank you very much!