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 07:10 PM.
I thought we did this once:
http://www.excelforum.com/excel-gene...43#post2686743
Regards, TMS
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 * 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
Contributors to this forum do not get paid. They give their valuable time to help you solve your problem. That's why feel free to CLICK their STARicon to say thank you -even the given idea/solution didn't really solve your queries. The time given to you deserves a small gratitude anyway.
Dare to give a pencil to a child. http://www.blackpencilproject.org/
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)
Posting Permissions
Reply With Quote
Bookmarks