Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 08-11-2006, 11:44 PM
SerenityNetworks SerenityNetworks is offline How can I use a colom of data if a specific value is found. Windows 10 How can I use a colom of data if a specific value is found. Office 2016
Advanced Beginner
 
Join Date: May 2005
Location: Allen, Texas, USA
Posts: 37
SerenityNetworks
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


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
How can I use a colom of data if a specific value is found. 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 08:02 AM.


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