SirJB7 Excel Rōnin Dec 19, 2013 #2 Hi, webmax! Here you have: =A1+1 Put it anywhere but in A1. Regards!
W webmax Member Dec 19, 2013 #3 Hi kindly find the attached file and i need the solution to if i put the pivot table the date should appears Attachments pivot.xlsx pivot.xlsx 8.9 KB · Views: 5
Hi kindly find the attached file and i need the solution to if i put the pivot table the date should appears
bobhc Excel Ninja Dec 19, 2013 #4 good day webmax, as per the upload?? Attachments webmax.xlsx webmax.xlsx 18.6 KB · Views: 4
SirJB7 Excel Rōnin Dec 19, 2013 #5 Hi, webmax! Give a look at the uploaded file. It uses a helper column, just in case you want to group by date. Regards! Attachments formula rqd - pivot (for webmax at chandoo.org).xlsx formula rqd - pivot (for webmax at chandoo.org).xlsx 13.3 KB · Views: 10
Hi, webmax! Give a look at the uploaded file. It uses a helper column, just in case you want to group by date. Regards!
bobhc Excel Ninja Dec 19, 2013 #6 Good day SirJB7 I hope life is good for you Can you not just click on the date field in the pivot table a click group and then deselect anything already selected and choose day?
Good day SirJB7 I hope life is good for you Can you not just click on the date field in the pivot table a click group and then deselect anything already selected and choose day?
SirJB7 Excel Rōnin Dec 19, 2013 #7 Hi, b(ut)ob(ut)hc! Good afternoon, my friend. I wish to be feeling more than actually LG's motto, but I can't complain. Yes, but it was easier to add a helper column ... and today the heat does incite me to work the less possible. Regards!
Hi, b(ut)ob(ut)hc! Good afternoon, my friend. I wish to be feeling more than actually LG's motto, but I can't complain. Yes, but it was easier to add a helper column ... and today the heat does incite me to work the less possible. Regards!
R Ram Mher Member Dec 21, 2013 #8 please find the attached and see your solution in Sheet 4 and Sheet 5 Attachments pivot.xlsx pivot.xlsx 15.3 KB · Views: 3
