Good Afternoon
On the attached spreadsheet i have some data under report tab, i need to break that data and transfer across to the master tab, so it will show me every department qty order and despatched rtc by date, any help would be much apreciated
As an example, I did "Cases Ordered"
I manually moved the dates over. Then in D3 copied down
=IF(C3<>"",SUMIFS(Report!$J$2:$J$6580, Report!$A$2:$A$6580, $C3, Report!$F$2:$F$6580, INDEX($B$3:$B3, MATCH("zzzz",$B$3:$B3))),"")
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
this is great, but i will need this to sort the dates itself and populate all the fields, is this possibleOriginally Posted by ChemistB
Thanks
I don't use pivot tables, so I'm not familiar with all they can do, but this looks like one should be able to accomplish this using a pivot table of some kind. I might suggest that you review an introduction like this (http://chandoo.org/wp/2009/08/19/exc...bles-tutorial/ ) and see if a pivot table is right for you.
I can't wrap my head around a formula that will pull unique dates by department number. The other columns will all have very similar formulas to the one I gave you.
I agree with Mr. Shorty that pivot tables might be worth looking into .
Last edited by ChemistB; 08-18-2015 at 03:05 PM.
ok thank you all for your help, how can i transfer this to a diferent section of this forum?
Thank you all
Moving a thread from one forum to another probably requires a moderator. If you feel that it needs to be moved, contact a moderator (or simply use the "report post" link at the bottom of the first post) and ask if they can move this (probably to the excel general or charts and pivots forum).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks