Searching and matching

joe77 · Mar 20th, 2002, 07:19 AM

I track my teams performance in a number of ways. One report seperates the time they spend into about 8 different categories. Not every team member will have time in every category. Therefore, the report will not always look exactly the same. Once a person has any time in a category, it is permanently included in the report. My quandry is when one of the people spend time in a new category. A simple function pointing to the same reference is no godd in these cases. Therefore, I am trying to find a way for Excel to search for a name, then look for the first instance of the work "Total" after the name, and then move the same number of columns over to find a percentage I need to paste into my tracker. Is there a way to use the functions that are built into Excel to get this done? Thank you in advance for any help.

Chris Davison · Mar 23rd, 2002, 09:25 AM

Joe,

can you post some examples of your data

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 20th, 2002, 07:19 AM	#1
joe77 New Member Join Date: Mar 2002 Posts: 9	I track my teams performance in a number of ways. One report seperates the time they spend into about 8 different categories. Not every team member will have time in every category. Therefore, the report will not always look exactly the same. Once a person has any time in a category, it is permanently included in the report. My quandry is when one of the people spend time in a new category. A simple function pointing to the same reference is no godd in these cases. Therefore, I am trying to find a way for Excel to search for a name, then look for the first instance of the work "Total" after the name, and then move the same number of columns over to find a percentage I need to paste into my tracker. Is there a way to use the functions that are built into Excel to get this done? Thank you in advance for any help.

Mar 23rd, 2002, 09:25 AM	#2
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	Joe, can you post some examples of your data