I have spreadsheet with random data like this
weekno date
42 18 October 2015
42 15 October 2015
41 05 October 2015
41 05 October 2015
40 04 October 2015
40 02 October 2015
40 01 October 2015
40 01 October 2015
41 08 October 2015
43 22 October 2015
My expected result would be like this, chose distinct no, then sort & put together based on week no, leave a gap after each week no and place word TOTAL in that gap. I prefer to use a formula than macro. How to do it Please?
weekno date
40 01 October 2015
40 02 October 2015
40 04 October 2015
Total(a gap after each week no)
41 05 October 2015
41 08 October 2015
Total
42 15 October 2015
42 18 October 2015
Total
43 22 October 2015
Bookmarks