In Part 1 we ended up with Column D, a sorted list. One criticism was the many times we were counting the numbers in a column. We should improve it and only count once. Via Insert/Name/Define define Count_BB to =COUNT(Sheet1!$B:$B), and then select Columns C:D, and “Replace All” COUNT(B:B) with Count_BB. [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2010/09/06/building-a-self-sorting-list-part-2/
Posted
Sep 06 2010, 10:04 AM
by
Daily Dose of Excel