Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Columns to a set Format.
I have a problem which I hope is simple to rectify. Reporting software delivers statistic of sign ups from different countries, e.g over a whole month we might get the following sign ups from these countries. (I have sorted these alphabetically and just taken a sample) Australia Austria Azerbaijan Bahamas Bahrain Bangladesh Barbados Belarus Belgium Belize Benin Bermuda Bhutan Bolivia Bosnia and Herzegowina Botswana Bouvet Island Brazil British Indian Ocean Territory Brunei Darussalam Bulgaria Burkina Faso Burundi Cambodia Cameroon Canada However in just one day maybe we only receive sing ups from the following countries. Australia Austria Bahamas Bangladesh Barbados Belarus Belgium Bermuda Bolivia Bosnia and Herzegowina Botswana Bouvet Island Brazil Bulgaria Burundi Cambodia Cameroon Canada ..... the range in both occurences is from Australia to Canada, and both are sorted alphabetically. However, in the second instance there are no sign ups from 'British Indian Ocean Territory'. Is it possible to sort the second list and format in the same way as the first. So that it inserts an extra row + 0 as the sign up count for 'British Indian Ocean Territory' so that each countrie's counts are consistent accross the same row rather than doing it manually? Many thanks for your advice and insights. -- samprince ------------------------------------------------------------------------ samprince's Profile: http://www.excelforum.com/member.php...o&userid=34168 View this thread: http://www.excelforum.com/showthread...hreadid=550991 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Columns to a set Format.
note: I have looked at Custom LIsts sorts, but I cant use this to also insert rows to make the sorted columns align with each other. -- samprince ------------------------------------------------------------------------ samprince's Profile: http://www.excelforum.com/member.php...o&userid=34168 View this thread: http://www.excelforum.com/showthread...hreadid=550991 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting two columns at the same time | Excel Worksheet Functions | |||
Sorting multiple columns as 1 list alphabetically? | Excel Discussion (Misc queries) | |||
Cond Format -- on set of columns, then one column | Excel Discussion (Misc queries) | |||
format columns to collapse and expand in excel | Excel Discussion (Misc queries) | |||
Converting time figures into 24-hour format & sorting them... | Excel Worksheet Functions |