sort a group

[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

 

[Gord Dibben]

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

 

[Guest]

Hi,

Your layout of data is incorrect.

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

Challa Prabhu