LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
jezzica85
 
Posts: n/a
Default Sorting in multiple columns

Hi all,
Is there a way to sort data in excel so if there's something like this:

a a a
a b b
a b c
b b c
c c c

it can turn into this with all the similar data grouped to show how many of
each type are in each column without it being mashed together?:

a a a
a
a

b b b
b
b

c c c
c
c

Thanks, I wasn't sure how else to put it without an illustration!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Advice sought: Multiple column sorting davidm Excel Worksheet Functions 3 July 29th 05 02:06 PM
Multiple columns in a pivot table lyric2002 Excel Discussion (Misc queries) 2 May 26th 05 05:53 PM
spliting a column of data into multiple columns CiceroCF Excel Discussion (Misc queries) 7 March 25th 05 12:40 AM
drop down list multiple columns c Excel Discussion (Misc queries) 9 January 27th 05 03:13 PM
Pivot Table combining multiple columns Pete Petersen Excel Discussion (Misc queries) 1 January 13th 05 07:56 PM


All times are GMT +1. The time now is 09:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"