Sorting and searching

  • Thread starter Thread starter PitchBlackSheep
  • Start date Start date
P

PitchBlackSheep

I have no clue if this is possible but I'm giving it a shot :)

Everyday, I receive an Excel spreadsheet from one our Escrow companies.
The sheet sort of looks like this:

Escrow# Lname Fname Comments
1234 Smith Janet blah blah 1235
1243 Jones Susan blah blah 1233
1235 Williams Bill blah blah 1234
1233 Roberts Kathy blah blah 1243

I need to have Excel make it look like this:
Escrow# Lname Fname Comments
1233 Roberts Kathy blah blah 1243
1243 Jones Susan blah blah 1233
1234 Smith Janet blah blah 1235
1235 Williams Bill blah blah 1234

I need Excel to recognize the number associaion and move them next to
one anoher. The only way I have figured to do this is by using DGET
and 3D References across worksheets. Thus far, I'm having trouble. If
anyone else has a better solution, please let me know!
Thank you in advance :)
 
I think I would approach the problem using the CONCATINATION and/or MIN
features, comparing the two columns and a helper column to sort on........

hth
Vaya con Dios,
Chuck, CABGx3
 
Thanks for the reply, but I'm a bit confused. I've been looking at
this for so long that I've become slow ;) Can you explain?
Cheers!

~ Rose
 
Well, on second thought, it looks like you could forget the concatenation
part of the suggestion, and just use a fifth column, with something like

=MIN(LEFT(A2,4),RIGHT(D2,4))

(This assumes A is your "Escrow#" column and D is your "Comments" column
with the "blah blah NNNN".)

and then sort on that column as the first key and the Escrow# column as the
second key, both ascending.


Vaya con Dios,
Chuck, CABGx3
 
Back
Top