sort a group

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having problems sorting columns. I want to arrange my columns by
birthday here is an example of my speadsheet.

Employee Name Birthday Employee Name Birthday
Joe 01-18 Doe 02-20

It will not sort the whole worksheet correctly
 
Is that the actual layout of your data? Across rows?

Would be much easier if the names were in one column and the dates were in an
adjacent column, say A and B

Then just select A and B and sort on B

You can sort across a row.......Data>Sort>Options>Sort left to right


Gord Dibben MS Excel MVP
 
Hi,

Your layout of data is incorrect.

You could infact have this way:
Employee Name Birthday
Joe 01-18
Doe 02-20

Challa Prabhu
 
Back
Top