Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question using DGET function
Good evening group! I am trying to use the DGET function to return one value
from a group of cells. My table structure looks like this: Temp pH Cl2 Min 4.90 5.90 0.4 137 4.90 5.90 0.6 141 4.90 5.90 0.8 145 Through 25.00 9.00 1.8 86 25.00 9.00 2.0 89 25.00 9.00 2.2 90 25.00 9.00 2.4 92 There are 585 rows in all and each is unique based on the first three rows. I originally sturcutred my DGET where my criteria were formulas that looked up "rounded" results, and this works for SOME results, but there isn't a real pattern to when it stops... When I use a similar stucture and TYPE in the values that the formulas return in the previous paragraph the DGET works everytime! the structure of my criteria is: Temp pH Cl2 20.00 8.50 1.20 Where "20" is returned from a LOOKUP function because I am trying to round the Temp to increments of 5 degrees C. pH of increments of .5 (but the user can enter any ph into a field) Does any of that make any sense? If you can help or suggest another method in excel to get at what I am trying to do I would be very appreciative. Thanks, Jasonm |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question using DGET function - Nevermind I have moved my data to Access it is easier to use.
Thanks for reading my thread anyway... If you want to answer I will still
read and appreciate your response, but it seems like I am better off moving all my data to Access where I can better manipulate it... Thanks again, Jasonm "Jasonm" wrote in message ... Good evening group! I am trying to use the DGET function to return one value from a group of cells. My table structure looks like this: Temp pH Cl2 Min 4.90 5.90 0.4 137 4.90 5.90 0.6 141 4.90 5.90 0.8 145 Through 25.00 9.00 1.8 86 25.00 9.00 2.0 89 25.00 9.00 2.2 90 25.00 9.00 2.4 92 There are 585 rows in all and each is unique based on the first three rows. I originally sturcutred my DGET where my criteria were formulas that looked up "rounded" results, and this works for SOME results, but there isn't a real pattern to when it stops... When I use a similar stucture and TYPE in the values that the formulas return in the previous paragraph the DGET works everytime! the structure of my criteria is: Temp pH Cl2 20.00 8.50 1.20 Where "20" is returned from a LOOKUP function because I am trying to round the Temp to increments of 5 degrees C. pH of increments of .5 (but the user can enter any ph into a field) Does any of that make any sense? If you can help or suggest another method in excel to get at what I am trying to do I would be very appreciative. Thanks, Jasonm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dget Function | Excel Discussion (Misc queries) | |||
DGET FUNCTION | Excel Discussion (Misc queries) | |||
dget or dsum? that is the question | Excel Discussion (Misc queries) | |||
dget or dsum? that is the question | Excel Discussion (Misc queries) | |||
dget function | Excel Worksheet Functions |