#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
I don't know where you are going with this or what kinds of data you will have when you fully populate the worksheet. It makes it hard to decide what way to go is best. But the example I loaded at http://www.serenitynetworks.net/Shar.../TimeMatch.xls will do what you explained.
I hope this helps. Regards, Andrew |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Specific Lat Long Conversion Help | chesspupil | Excel | 2 | 04-16-2006 11:06 PM |
Entry point not found? | Zanmax | Outlook | 0 | 02-14-2006 06:26 AM |
Application not found error when trying to open .pdf files. | Dave | Outlook | 2 | 12-15-2005 01:01 PM |