S Shabbo Member Jun 28, 2016 #1 Dear Sir, I have data in attached excel format and I wanted month wise total for credit side in sheet 4. Attachments Details.xls Details.xls 36.5 KB · Views: 5
Dear Sir, I have data in attached excel format and I wanted month wise total for credit side in sheet 4.
chirayu Well-Known Member Jun 28, 2016 #2 Converted file to xlsx so formula will work Attachments Details.xlsx Details.xlsx 18.2 KB · Views: 4
Syedali Active Member Jun 28, 2016 #3 Shabbo said: Dear Sir, I have data in attached excel format and I wanted month wise total for credit side in sheet 4. Click to expand... Hi, Remove the space and put pivot table.. Attachments details-1.xls details-1.xls 58.5 KB · Views: 4
Shabbo said: Dear Sir, I have data in attached excel format and I wanted month wise total for credit side in sheet 4. Click to expand... Hi, Remove the space and put pivot table..
S Shabbo Member Jun 28, 2016 #4 Syedali said: Hi, Remove the space and put pivot table.. Click to expand... Please advice how did you separate the year and date so I can put pivot.
Syedali said: Hi, Remove the space and put pivot table.. Click to expand... Please advice how did you separate the year and date so I can put pivot.
Syedali Active Member Jun 28, 2016 #5 Shabbo said: Please advice how did you separate the year and date so I can put pivot. Click to expand... Hi, Put pivot right click in date column and group into Month and year wise.
Shabbo said: Please advice how did you separate the year and date so I can put pivot. Click to expand... Hi, Put pivot right click in date column and group into Month and year wise.
