Unique positioning of data on excel

[simplemanny]

I wish to produce a macro to solve the problem is attacted, i have problems with it, please view. Thanks for the assistance.
13913

[p45cal]

cross posts:
http://www.excelforum.com/excel-programming-vba-macros/1093355-unique-positioning-of-data-on-excel.html
http://www.vbforums.com/showthread.php?800225-Unique-positioning-of-data-on-excel

simplemanny, some light reading for you here (http://www.excelguru.ca/content.php?184) - it'll ultimately be to your advantage to act on it.

[SamT]

in re Unique number 1; why/how is B26:B39, B40:B53, B54:B66 different from B26:B66?
In re Unique number 4: you list 11 ranges, why not B20:B76?

Please upload a book with the two sheets in it. the data as it is and the "Graph" as you want it.