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.