1 of 1 people found this helpful
Please go through the workbook attached, it will help me know that if i have correct understanding over your requirement.
If it helps, i will explain you the steps that i used to create this report.
2 of 2 people found this helpful
Put Rank LW as first column and clear sorting (to be 1 to 48)
for the second sheet just put a filter on rank field
Appreciate your support! Unfortunately I cannot view your workbook as I have not upgraded to version.10 as yet (still on 9.3)
I followed Paraskev’s directions and all good now!
Cheers for the insight and your effort!
I was actually after ranking all months from 1 to 48
All AOK and Sorted Now!
Thanx again mate!
Spot on Thanx mate!
Appears that I was on the right track, just did not have my column order correct