View Single Post
 
Old 06-10-2006, 08:34 PM
Grapejuice Grapejuice is offline
Novice
 
Join Date: Jun 2006
Location: Toronto Ontario Canada
Posts: 5
Grapejuice
Default How can I use a colom of data if a specific value is found.

I hope this is something that Excel is capable of doing.

I have a set of data (time in minutes) below (fig 1) that I need to use if the total time between two entered times matches a coloms total. If it matches I want Excel to use the data in that colom to affect the data in another (fig 2) colom adding the times to each cell.
Looking at both figs. below I want Row B, Colom A in fig 2 to add Row A, Col A to Row A, Col A in fig 1 since both are the total of 19.

fig 1
Coloms A B C D
Row A 5 5 6 6
Row B 5 6 6 8
Row C 4 5 6 7
Row D 5 4 4 5
Total 19 20 23 26


fig 2
Coloms A B C D
Row A 1:00 2:00 3:11 4:01
Row B
Row C
Row E
Row F 1:19 2:20 3:33 4:27
Row F-A= 19 20 23 26


I can send an Excel file if it would help figuring this out.
PLEASE PLEASE TELL ME THERE IS A SOLUTION
Reply With Quote