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 -