Formula Fraustration
 

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.

Formula Fraustration
 

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
--
paul

remove nospam for email addy!



"Andy Hessey" wrote:

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.

Formula Fraustration
 

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


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=565520