hello
Please see attahed
I want to create a league table that automatically updates when data is entered,
Table needs to display highest points 1st, but also needs to count the number of submissions
Paul
hello
Please see attahed
I want to create a league table that automatically updates when data is entered,
Table needs to display highest points 1st, but also needs to count the number of submissions
Paul
Hi pmw,
Does the attached get close to what you want?
Read about Dynamic Named Ranges at:
http://www.ozgrid.com/Excel/DynamicRanges.htm
I haven't put any VBA behind the worksheet but need to know if you understand what the Pivot Table did first.
League Scores Top 7 Pivot.xlsx
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
OR,
Try the following:
In L3:
In K3:Please Login or Register to view this content.
In J3:Please Login or Register to view this content.
See the attached file.Please Login or Register to view this content.
I've added a helper column (E) to segregate the total points.
In E3:
See the attached file.Please Login or Register to view this content.
i'm not sure what i've done wrong.. i've pasted the formula down and seems to have gone wrong
i thought it would automatically work out the rest
Hi,
Modify the formula in J3 as following:
array entered - press CTRL+SHIFT+ENTER to confirm.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks