Sorry, wrong forum

[sglick]

Hi, I am looking to check who has only a desktop, laptop or netbook. I have 3 columns and several rows. I want to find out who marked "Don't Own" in two columns and have the title labeled in the column that they do have.

For example: I want Col. G R2 to say "Laptop" and Co. G R3 to say "Desktop" and "Laptop" (I can have this in separate columns, they don't all have to be Col. G., I just want to know who owns what).

All help is appreciated. Thank you.

Col. D desktop computer
R2 - Don’t own
R3 - 5 or more years
R4 - 5 or more years

Col. E laptop computer
R2 - 1 - 2 years
R3 - 3 - 4 years
R4 - Don’t own

Col. F netbook computer
R2 - Don’t own
R3 - Don’t own
R4 - 1 - 2 years

[NBVC]

Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.

[teylyn]

sglick,

any particular reason you posted this in the Outlook forum? Please take care to put your questions into the relevant forum.

Moved to Excel General.

Also, please help us help you and post a data sample in an Excel workbook. Nobody feels like re-typing your data.

cheers