Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sort by matching column

Status
Not open for further replies.
link99sbc

link99sbc

Technical User
Apr 8, 2009
141
US
I have a spreedsheet with data in 7500 Rows and columns A-M
I want to sort it by matching col C and D. In other words if C and D match move the row to the top. If they don't match, move the row to the bottom.
 
Sort by date Sort by votes


Hi,

Why even use VBA?

In an adjacent column...
[tt]
=If(A2=B2,0,1)
[/tt]
assuming that the values in column A & B are the values to match.

Then SORT!

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

M
  • Locked
  • Question
Reference Pivot Tables by name 1
Replies
2
Views
322
mintjulep
M
IcarusHallsorts
  • Locked
  • Question
I have a column of data in Column A
Replies
3
Views
202
Andrzejek
Andrzejek
feipezi
  • Locked
  • Question
How to detect dups and/or sum by group?
Replies
1
Views
132
Andrzejek
Andrzejek
feipezi
  • Locked
  • Question
Hoe to fix run time error 2147217900 (80040e14) syntax error in Order By clause 1
Replies
6
Views
976
Andrzejek
Andrzejek
arvarr
  • Locked
  • Question
Excel Help - Worksheets by UserID 3
2
Replies
39
Views
540
arvarr
arvarr

Part and Inventory Search

Sponsor

Back
Top