Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dget Function
Hi,
I have two tables, one of them contents database of received material & other one is the summery of that sheet. The unique field name in both the sheet is "im_code " &"im_invrt". Now i wish to pull the latest "im_invrt" from the database sheet for the given criteria of "im_code" in the summery sheet. I have tried this by using DGET / DMAX function. but the value returns #NUM!. Both the sheets are looks like : Sheet Dbase contents doc_no im_code im_qty im_invrt date_stmp GR700144 ATM0093 100 626.02 05/04/2006 07:45:01 AM GR700147 ATM0093 60 726.02 05/04/2006 07:54:49 AM GR700148 PTM0748 20 642.72 05/04/2006 07:57:11 AM GR700152 ATM0093 40 626.02 05/04/2006 09:22:23 AM GR700185 ATM0762 40 626.02 05/04/2006 06:09:43 PM GR700193 PTM0748 39 650.72 05/04/2006 06:45:37 PM GR700185 ATM0762 57 642.72 07/04/2006 04:19:33 PM And Sheet Summery contents : im_code im_invrt ATM0093 =DGET(DBASE!$A$1:$E$8,"IM_INVRT",SUMMERY!$A$1:$A$4 ) PTM0748 #NUM! ATM0762 #NUM! Is their any solution to pull the latest data (i.e "im_invrt") in the desired rows. -- Thanks, Vikram P. Dhemare |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dget Function
Not pretty sure what you want exactly. You may sort your worksheet first and
let the latest data (i.e "im_invrt") at the last row. You can use macro to select the last row or the a range of row which fall on the same date ("im_invrt" is the same). "Vikram Dhemare" wrote: Hi, I have two tables, one of them contents database of received material & other one is the summery of that sheet. The unique field name in both the sheet is "im_code " &"im_invrt". Now i wish to pull the latest "im_invrt" from the database sheet for the given criteria of "im_code" in the summery sheet. I have tried this by using DGET / DMAX function. but the value returns #NUM!. Both the sheets are looks like : Sheet Dbase contents doc_no im_code im_qty im_invrt date_stmp GR700144 ATM0093 100 626.02 05/04/2006 07:45:01 AM GR700147 ATM0093 60 726.02 05/04/2006 07:54:49 AM GR700148 PTM0748 20 642.72 05/04/2006 07:57:11 AM GR700152 ATM0093 40 626.02 05/04/2006 09:22:23 AM GR700185 ATM0762 40 626.02 05/04/2006 06:09:43 PM GR700193 PTM0748 39 650.72 05/04/2006 06:45:37 PM GR700185 ATM0762 57 642.72 07/04/2006 04:19:33 PM And Sheet Summery contents : im_code im_invrt ATM0093 =DGET(DBASE!$A$1:$E$8,"IM_INVRT",SUMMERY!$A$1:$A$4 ) PTM0748 #NUM! ATM0762 #NUM! Is their any solution to pull the latest data (i.e "im_invrt") in the desired rows. -- Thanks, Vikram P. Dhemare |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dget Function
What I want is the latest rate from the DBASE sheet for that particular part
would be displayed in the summery sheet (subsequent col. for each part no.). Is there any excel function something like "GETPIVOTDATA" function. I don't know much about macros. -- Thanks, Vikram P. Dhemare "Anna" wrote: Not pretty sure what you want exactly. You may sort your worksheet first and let the latest data (i.e "im_invrt") at the last row. You can use macro to select the last row or the a range of row which fall on the same date ("im_invrt" is the same). "Vikram Dhemare" wrote: Hi, I have two tables, one of them contents database of received material & other one is the summery of that sheet. The unique field name in both the sheet is "im_code " &"im_invrt". Now i wish to pull the latest "im_invrt" from the database sheet for the given criteria of "im_code" in the summery sheet. I have tried this by using DGET / DMAX function. but the value returns #NUM!. Both the sheets are looks like : Sheet Dbase contents doc_no im_code im_qty im_invrt date_stmp GR700144 ATM0093 100 626.02 05/04/2006 07:45:01 AM GR700147 ATM0093 60 726.02 05/04/2006 07:54:49 AM GR700148 PTM0748 20 642.72 05/04/2006 07:57:11 AM GR700152 ATM0093 40 626.02 05/04/2006 09:22:23 AM GR700185 ATM0762 40 626.02 05/04/2006 06:09:43 PM GR700193 PTM0748 39 650.72 05/04/2006 06:45:37 PM GR700185 ATM0762 57 642.72 07/04/2006 04:19:33 PM And Sheet Summery contents : im_code im_invrt ATM0093 =DGET(DBASE!$A$1:$E$8,"IM_INVRT",SUMMERY!$A$1:$A$4 ) PTM0748 #NUM! ATM0762 #NUM! Is their any solution to pull the latest data (i.e "im_invrt") in the desired rows. -- Thanks, Vikram P. Dhemare |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF function to blank without getting #value in sum function | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |