Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi, I never got a response to this question that worked, so I thought I would
ask it again hoping that this time it makes more sense: Here is a sample of my data: Column1 Column2 Column3 Column4 row 1 1/1/2008 2/1/2008 3/1/2008 4/1/2008 row 2 BBB AAA AAA CCC row 3 CCC AAA BBB AAA row 4 BBB BBB BBB CCC I am using the codes BBB, AAA, CCC to indicate in another spreadsheet the total hours worked on a project (project AAA, BBB, or CCC), each time a code in entered in a cell it indicated 15 minutes of work. I am able to add up the time per code easily enough, but what i want to do is show the first date that the project was worked on. For example, project code AAA was first worked on on 2/1/2008, so I want a formula that looks up "AAA" and returns "2/1/2008". I do not want sort the spreadsheet as it is consistantly being used to enter time worked. Any suggestions? Thank you, Ambie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Reverse Index and Match Functions | Excel Worksheet Functions | |||
lookup/match/index help | Excel Discussion (Misc queries) | |||
Lookup / Index / Match Function | Excel Discussion (Misc queries) | |||
Lookup or Index/Match | Excel Discussion (Misc queries) | |||
Reverse MATCH Function | Excel Discussion (Misc queries) |