aaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaa
Last edited by putitwhere; 05-01-2013 at 03:06 PM.
Use a helpcolumn in your sheet.
=if(month(a2)<7,"before",if(month(a2)>7,"after","not good entry")
This column can be used in your pivottable.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
i cant seem to get that formula to work, any recommendations?
Please post an small example of your excel sheet, without confidentional information.
Screen Shot 2013-04-30 at 7.56.59 PM.jpg
my assignment:
Last edited by putitwhere; 04-30-2013 at 08:16 PM.
Please post the excel file, so i can work in it.
I think this worked.
Last edited by putitwhere; 05-01-2013 at 03:07 PM.
See the attached file, with an pivot table.
Thank you!
What is the name of that formula so I can research it further?
It's a combination of if and month formula (see #2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks