Sort data

[philiasfogg]

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]

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]

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]

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"))

[philiasfogg]

thanks that works

just need to separate each lamp with a line now