Hi Everyone,
I have been visiting this forum but this is my first time posting. I need help with a formula. I have a spreadsheet with many columns and rows but I am only concerned with two columns here. One is the Employee ID ((Column C) and the other is Device Type (Column P). Employee ID column can have duplicate employee Ids since an employee can have multiple device types. The device type has seven different options (Aircard, PDA Voice/Data, Telemetry, Cell Phone, Satellite, PDA Data, Pager). I am trying to do create two new columns with formulas:
1. New column that will indicate "Yes" for employee ids that have "PDA Voice/Data" and "Cell phone"
2. New column that will indicate "Yes" for employee IDS who have more than two device types
Thanks in advance!!
Bookmarks