Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup latest entry
Hi all!
I was wondering if I can get some Excel help for a problem I have encountered: Below is a list of the field names corresponding to the columns in Excel (separated by comma's): LastName, FirstName, RepID, Sales, UpdateNumber I input information from various sources into this spreadsheet. I have another spreadsheet set up which uses the data from above to do some calculations. To make my request simple, I'll provide an example. Let's say I have the following 10 entries in the database: LastName, FirstName, RepID, Sales, UpdateNumber Miller, John, CA23, 52000, 1 Talbot, Tom, NJ12, 7020, 1 Kowal, Jen, AZ13, 10900, 1 Miller, John, CA23, 64000, 2 Lamb, Jeff, NJ29, 493440, 1 Miller, John CA23, 89000, 3 Allen, Kevin, PA22, 90800, 1 Lamb, Jeff, NJ29, 3232444, 2 Kowal, Jen, AZ13, 15000, 2 Talbot, Tom, NJ12, 50000, 2 Any time there's an update for a particular salesperson, the UpdateNumbers adds 1 to the last UpdateNumber. So, if you look above, John Miller's UpdateNumber has reached 3 - for 3 updates. The list is always increasing as are the updates for each salesperson. I don't want to find the sum of he person's sales, but the latest sale number based on the latest update. In this case, John's sales figure would be 89,000 because the it is associated with the latest update number (which happens to be the max for him.) This would be the entry I'm interested in. Again, on my other spreadsheet which i use to perform calculations, I would like to pull up the entry from above list for John to reflect the latest sale (89,000). How would i achieve this? Is there a way to figure out the max of the UpdateNumber based on code and then doing a Vlookup against that? What do i have to do to find the latest sales figure from the above table? It is not necessarily a larger figure or else I could do a MAX function alongwith a vlookup or something. Any or all help with be greatly appreciated! Thanks much! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup latest entry
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup latest entry
On Jul 16, 6:55 pm, "Don Guillett" wrote:
See ans in your other post -- Don Guillett Microsoft MVP Excel SalesAid Software wrote in message ups.com... Hi all! I was wondering if I can get some Excel help for a problem I have encountered: Below is a list of the field names corresponding to the columns in Excel (separated by comma's): LastName, FirstName, RepID, Sales, UpdateNumber I input information from various sources into this spreadsheet. I have another spreadsheet set up which uses the data from above to do some calculations. To make my request simple, I'll provide an example. Let's say I have the following 10 entries in the database: LastName, FirstName, RepID, Sales, UpdateNumber Miller, John, CA23, 52000, 1 Talbot, Tom, NJ12, 7020, 1 Kowal, Jen, AZ13, 10900, 1 Miller, John, CA23, 64000, 2 Lamb, Jeff, NJ29, 493440, 1 Miller, John CA23, 89000, 3 Allen, Kevin, PA22, 90800, 1 Lamb, Jeff, NJ29, 3232444, 2 Kowal, Jen, AZ13, 15000, 2 Talbot, Tom, NJ12, 50000, 2 Any time there's an update for a particular salesperson, the UpdateNumbers adds 1 to the last UpdateNumber. So, if you look above, John Miller's UpdateNumber has reached 3 - for 3 updates. The list is always increasing as are the updates for each salesperson. I don't want to find the sum of he person's sales, but the latest sale number based on the latest update. In this case, John's sales figure would be 89,000 because the it is associated with the latest update number (which happens to be the max for him.) This would be the entry I'm interested in. Again, on my other spreadsheet which i use to perform calculations, I would like to pull up the entry from above list for John to reflect the latest sale (89,000). How would i achieve this? Is there a way to figure out the max of the UpdateNumber based on code and then doing a Vlookup against that? What do i have to do to find the latest sales figure from the above table? It is not necessarily a larger figure or else I could do a MAX function alongwith a vlookup or something. Any or all help with be greatly appreciated! Thanks much!- Hide quoted text - - Show quoted text - |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup latest entry
Kindly answer again as the answer is not available any more in the
group. On Jul 20, 11:06 am, shaqil wrote: On Jul 16, 6:55 pm, "Don Guillett" wrote: See ans in your other post -- Don Guillett Microsoft MVP Excel SalesAid Software wrote in message oups.com... Hi all! I was wondering if I can get some Excel help for a problem I have encountered: Below is a list of the field names corresponding to the columns in Excel (separated by comma's): LastName, FirstName, RepID, Sales, UpdateNumber I input information from various sources into this spreadsheet. I have another spreadsheet set up which uses the data from above to do some calculations. To make my request simple, I'll provide an example. Let's say I have the following 10 entries in the database: LastName, FirstName, RepID, Sales, UpdateNumber Miller, John, CA23, 52000, 1 Talbot, Tom, NJ12, 7020, 1 Kowal, Jen, AZ13, 10900, 1 Miller, John, CA23, 64000, 2 Lamb, Jeff, NJ29, 493440, 1 Miller, John CA23, 89000, 3 Allen, Kevin, PA22, 90800, 1 Lamb, Jeff, NJ29, 3232444, 2 Kowal, Jen, AZ13, 15000, 2 Talbot, Tom, NJ12, 50000, 2 Any time there's an update for a particular salesperson, the UpdateNumbers adds 1 to the last UpdateNumber. So, if you look above, John Miller's UpdateNumber has reached 3 - for 3 updates. The list is always increasing as are the updates for each salesperson. I don't want to find the sum of he person's sales, but the latest sale number based on the latest update. In this case, John's sales figure would be 89,000 because the it is associated with the latest update number (which happens to be the max for him.) This would be the entry I'm interested in. Again, on my other spreadsheet which i use to perform calculations, I would like to pull up the entry from above list for John to reflect the latest sale (89,000). How would i achieve this? Is there a way to figure out the max of the UpdateNumber based on code and then doing a Vlookup against that? What do i have to do to find the latest sales figure from the above table? It is not necessarily a larger figure or else I could do a MAX function alongwith a vlookup or something. Any or all help with be greatly appreciated! Thanks much!- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing the latest entry in a column | Excel Worksheet Functions | |||
Referencing the latest entry in a column | Excel Worksheet Functions | |||
look up latest entry in a series? | Excel Worksheet Functions | |||
Formula for Latest Entry For Each Month | Excel Discussion (Misc queries) | |||
latest entry | Excel Worksheet Functions |