Hi All
I 'm beginner
Can you help me to solve using Pivot tabel in attachment :
thanks in advance
Hi All
I 'm beginner
Can you help me to solve using Pivot tabel in attachment :
thanks in advance
You ask the pivot table to show in the count of after how many cells are filled use the data in column E
With the A this is 3 for count of After (see the red tekst)
See the attached file.
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.
Hi Oeldere
Thanks for your quick response , but I mean that What the pivot can do like the side right table (coloum I, J, K ) ??
not like matrix table that you have done.
thanks
regards
In that case you have to re-organise the data in a vertically structor.
After that a Pivot Table.
See the attached file (under Oeldere2).
Hi Oeldere
Thanks for your quick response , very understand so it will be add some criteria for solve the problem
thanks you very much
regards
Glad I could help.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
If you have additional questions just ask.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks