In my data sheet I have some Champions club name with champion years [in sheet1(raw data)].My requirements is :-
Champions club name display in column A, year value in header row & "no. of champions" in respected team row with below the year columns [as shown in
sheet2(output)].
NOTE: "no. of champions" will be display in such manner that 1st-time champion=1,2nd-time champion=2,3rd-time champion=3,4th time champion=4.....so on.
Use Pivot option for the same result.Attached here
Thanks for your quick response.
But sir I want result like 1,2,3,.......... not all in "1" format. for example, any team wins 20 times so output will be like 1,2,3,4,5,.......and last year "20"
In such case you will have to create a helper column into your raw data sheet.
Try
C2Formula:
Please Login or Register to view this content.
Drag down then create pivot table
check the attached file.
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)
Select champion club field in the pivot and set the running total. Hope this is your requirement. Attached here
In B2 then copied across.
Please Login or Register to view this content.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks