i attahed herewith screen shot
Capture.JPG
in which pivot table showing 3 for 31/03/18 and 6 for 23/04/2018
but cheque no is same so i want 2 for 31/03/2018 and 2 for 23/04/2018
please guide how to do this
i attahed herewith screen shot
Capture.JPG
in which pivot table showing 3 for 31/03/18 and 6 for 23/04/2018
but cheque no is same so i want 2 for 31/03/2018 and 2 for 23/04/2018
please guide how to do this
Last edited by sharadmaxwell; 04-10-2018 at 05:31 AM. Reason: edit screshot
Perhaps Drag Cheque once again into Row label.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
There is no distinct count option in excel 2007. I always use a workaround with a formula in a help colomn
It will put a 1 value next to every first occurence of a cheque number and a "blank" value for every next time same checkno comes upPlease Login or Register to view this content.
Also in the pivot make sure you use sum and not count total of unique checkno.
Thanku Sir
and need one more help with your attahced file
see the screen shot
Capture.JPG
i need 2 on 03 march and 1 on 6 march
Ok, so you need a more complex match, I also realized after posting that each NAme (colomn A) could have the same CHQ Numbers at some point
SO I now made a 3 point match for unique count.
1. Cheq no
2. Name
3. Cheque / payment date
See attachment for new formula
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks