I have a spreadsheet with a very long column containing many differen
things that have been purchased in the past.

I need to discover how many different things have been purchased an
list them and find out how much has been spent on each of thos
things.

So I need a method (a macro I suppose) of going down that column an
finding the first entry that hasn't already been dealt with - sa
'screwdriver 6inch' and then continue down the column, find ever
instance and take the cost (and date) and write it to some other par
of the spreadsheet.

When we finish I'll have columns for every different article. I ca
look at what they are, know how many there are and see the tota
expenditures.

I imagine this is the gist of what spreadsheets are for yet I can'
figure out how to do it automatically, not for reading all the hel
screens I can't.

Perhaps it is too easy and there's couple of clicks will do it?

Please help if you know.

regards,
ab.
:

--
abrogar
-----------------------------------------------------------------------
abrogard's Profile: http://www.excelforum.com/member.php...fo&userid=2423
View this thread: http://www.excelforum.com/showthread.php?threadid=37847