Sorting rows based on the content of two columns

  • Thread starter Thread starter madbloke
  • Start date Start date
M

madbloke

Frank,

1-99 is the top entry as it is document 1 from 1999. Unfortunately, th
year has to be entered as 99. This is outside of my control :(

The more I think about this, the less sure I am that it is possible.

Frank said:
Hi
I don't understand your sorting order. Why is 1-99 the top most entry?
Click to expand...
 
Hi
try the following formula in a helper column (e.g. column C):
=IF(B1>40,1900+B1,2000+B1)*10+A1

copy this formula down and sort with this helper column.
 
It's not possible without the year. 99 is greater than 0, 1, 2, 3, or 4.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting rows based on the content of two columns 2
Shed some light on this WS_Calculate macro. 3
Eliminate blank row at top of Text Box entries 3
Sort on 3 columns when number of rows vary daily 1
help: sorting rows by lesser value of two columns 1
Problem sorting a range of columns using VBA 1
Pictures not being sorted in VBA 2
Using Excel Functions (Array) to put a list in alphabetical order 3

Back
Top