LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
scr scr is offline
external usenet poster
 
Posts: 10
Default Matching or Sorting multiple columns of data

I receive a spreadsheet that has 183 rows of data and 13 columns.

I would like to sort so that they are grouped together so if anything that
matches row 1 exactly falls in line after row 1. Then the next group would
match exactly and so on.

What can I do? I tried the Exact function but couldn't get that to work but
I've never used it before. Is that something that should work in this
scenario or is there another way to do this?
 
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
Sorting data in multiple columns Sadie5757 Excel Worksheet Functions 2 June 16th 08 05:26 PM
Sorting columns and Matching Jeremy Excel Discussion (Misc queries) 2 July 21st 06 07:56 AM
Sorting Data From One Column into Multiple Columns Justin Hoffmann Excel Worksheet Functions 2 July 12th 06 04:15 PM
sorting data across multiple columns Spiderman Excel Discussion (Misc queries) 2 October 6th 05 11:55 PM
Matching data in multiple columns BuddyB Excel Discussion (Misc queries) 1 February 27th 05 08:05 PM


All times are GMT +1. The time now is 11:52 AM.

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"