Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Scenario of Text value
Hi
I was wondering if you could help me out in here. For example, I have this scenario of a database of 5000 employees who do many business travels. Some of these people have their tickets booked by Helpers and some do their own bookings. Notes that some names on the database repeated on the list and their Helpers could be different and some of them simply dont have Helpers do the bookings for them. Name - Job Title - Assistant Amy Green - Analyst Mike Brown - Consultant - Helper One Lisa White - Manager Bill Purple - Partner - Helper Two Lucy Yellow - Analyst - Helper Three Ian Dunlop - Consultant Charlie White - Consultant - Helper Four David Smith - Manager John Bell - Executive - Helper Seven Graham Bell - Executive David Green - Analyst - Helper Five Lucy Smith - Partner Jan Dunlop - Analyst - Helper Eight Mike Dunlop - Manager John Brown - Executive - Helper Five Bill Purple - Partner - Helper Two Carol Smith - Executive Margaret McDonald - Manager Cindy Wright - Manager - Helper Five Ian Wright - Partner Richard McDonald - Partner - Helper Four Matthew White - Analyst Jason Yellow - Manager - Helper Seven Graham Bell - Executive Matt Smith - Executive - Helper Five Lucy Yellow - Analyst John Bell - Executive - Helper Eight Mike Brown - Consultant Mike Dunlop - Manager Bill Purple - Partner - Helper Two I am trying to find out How many Analyst, Consultant, Executive, Manager, Partner have their bookings done by Helpers and How many of them do their own bookings, and so on €¦ Any solutions are greatly appreciated. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting of text in a shared workbook. | Excel Worksheet Functions | |||
grayscale conditional formatting of text | Excel Discussion (Misc queries) | |||
conditional formatting on specific text in cells | Excel Discussion (Misc queries) | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |