1.copy the data IN SHEET 1 as it is in sheet 3 for comparing expected resllt of col. E and result of macro in col E
2.in sheet 1 delete cells in column E. DO NOT DELETE COLUMN e
this is the source data
3.in sheet 1 a helper column in F that is F2 is 1,F3 is 2 etc till F22
4.copy sheet 1 as desgined to sheet 2 repeat sheet2 so that source data is preserved
the file "breadwiner 130908" is attached as per 1,2,3,4 above
the macro "testone" is in the module
if you run the macro the result will be sheet (expected result column E)
there appears to be some error in your manual ranking of the middle portion that is rows 8 to 14. check once again whether the macro result is correct.
the macro is also appended below for reference
Bookmarks