LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 31
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formatting of text in a shared workbook. TW Excel Worksheet Functions 1 March 30th 06 06:26 PM
grayscale conditional formatting of text Guenther Excel Discussion (Misc queries) 1 October 5th 05 01:16 PM
conditional formatting on specific text in cells kwkhoo Excel Discussion (Misc queries) 3 June 21st 05 04:27 PM
Sort or Filter option? Mcobra41 Excel Worksheet Functions 3 February 23rd 05 07:22 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM


All times are GMT +1. The time now is 01:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"