Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-10-2006, 08:34 PM
Grapejuice Grapejuice is offline
Novice
How can I use a colom of data if a specific value is found.
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I use a colom of data if a specific value is found. 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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:00 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft