LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default sorting and matching in excel

Hallo

I have a problem to sort a data

My questions is like this:

3546 4623 53
4623 9584 33
1294 3546 12
9584 1294 11

that is, I have 3 rows in my dataset, the first row is in the correct
order, and the second row is in some random order, and the third row
is the value. My aim is to sort the second and third rows in the same
order as the first row.
What i expect to get is:

3546 3546 12
4623 4623 53
1294 1294 11
9584 9584 33

how can I achieve this? Many thanks in advance!

 
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
Matching and sorting 2 columns Eilean New Users to Excel 3 May 1st 09 12:19 AM
Matching or Sorting multiple columns of data scr Excel Discussion (Misc queries) 2 November 2nd 08 09:35 PM
Sorting with matching header TouchTone Excel Worksheet Functions 1 June 21st 07 01:39 PM
matching & sorting data larry brunster[_2_] Excel Worksheet Functions 1 June 12th 07 02:27 PM
Sorting columns and Matching Jeremy Excel Discussion (Misc queries) 2 July 21st 06 07:56 AM


All times are GMT +1. The time now is 08:11 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"