As I am at a loss to know even what function I need to run what I am trying to achieve; I can’t even read up on it and have a go at trying to construct it.
Any advice would be very welcome.
julhs
As I am at a loss to know even what function I need to run what I am trying to achieve; I can’t even read up on it and have a go at trying to construct it.
Any advice would be very welcome.
julhs
Last edited by julhs; 01-29-2012 at 08:10 PM.
I thought we did this once:
http://www.excelforum.com/excel-gene...43#post2686743
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hi julhs,
You're working too hard. See the attached where I've made 3 different Pivot Tables from your data. I think you need to add a category to each transaction and learn to do pivot tables.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Hello julhs.
good morning.
here's a sample of vlookup from your dummy file.
but I would prefer the use of pivot table as stated by MarvinP.
Dummy Book1vlookup.xlsx
Cheers,
vlady
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
TMS, yes we did, and your help was invaluable.
It is presenting the figures in the form that I wanted; by payment method. It is just that I have been asked if they can be displayed as an itemised list of payments to the various recipients as well.
MarvinP & vlady, thanks for your examples. Will have a proper look at them tomorrow, brains fried enough for one day.
Regards
julhs
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks