Formula Fraustration

A

Andy Hessey

Hi all.

I am getting really wound up by a report I am running in Excel.

I have a list of customers and items they have purchased i.e

Mr Bloggs Face Cream
Mr Bloggs Massage Pad
Mr Bloggs Free Gift
Miss Jones Face Cream

I need a way of finding the first (or last) entry for each customer
regardless of how many other entries there are in the list. Once I have the
entry, I need to then do more calculations on that line.

I have tried the basic idea of equals the line above or line below, but when
you have 5 or more lines that doesn't work.

I know it's something simple but I can't work it out. Please help.
 
P

paul

your table is A2:B5,you type your name in a1= mr bloggs
=vlookup(a1,a2:b5,1,false) will find say mr bloggs(first instance)
=vlookup(a1,a2:b5,2,false) will find face cream
 
R

robert111

SEE ATTACHED ZIP FILE. it allows you to type in a name and whether yo
want earliest or latest gift. you should be able to figure out how i
works from the formulas
 
Top