Sort data

**philiasfogg** · 07-26-2011, 10:54 AM

Hi, looking for help. I am trying to sort the data on a spreadsheet in the following way.

Column A has lamp models, column B is the projectors they fit.

I have seperated each lamp model with a blank line

I want to sort the list by the number of rows for each lamp model

**SAsplin** · 07-26-2011, 11:19 AM

Are you trying to work out which projects a certain lamp fits? If so, you could just pivot the data.

An example of your spreadsheet might help clarify things.

SAsplin

**philiasfogg** · 07-26-2011, 11:27 AM

Sorry if I didnt make myself clear.

I am uploading info to a website, but I can only do it a lamp at a time.
So I want to get the lamp which fits the most projectors first, then the next and so on.

That is why I want to sort the list in that way

I have attached a small sample of the data, as the list is over 10,000 lines

**martindwilson** · 07-26-2011, 11:38 AM

try in g2 dragged to end
=IF(A2="","",TEXT(COUNTIF(A:A,A2),"00000")&"-"&A2)
sort by col g z to a
or even
=IF(A2="","",TEXT(COUNTIF(A:A,A2),"00000")&"-"&TEXT(A2,"000000000"))