Hi,
sorry - I have another problem! In my assessment sheet the data looks like
this...


F G H I J
K L M
score1 score2 name name score3
score4 progress
8 8 Aldi Billy 9 9 1
1 1 Boots Claire s 1 1 0
1 1 Debehham Ernie 3 3 2
1 1 Elves Freda s 4 4 3
2 2 Foster Gail 4 4 2
2 2 Google Harry sa 1 1 -1
1 1 Hills Jenny 2 2 1
1 1 Jones Kevin sa+ 1 1 0
2 2 Kwik Lisa 2 2 0
2 2 Lidl Mason 1 1 -1
1 1 Morrison Nathan 2 2 1
Next Olive
Ogilvy Perry

I wanted to write a macro that would sort the data by column L and remove
empty rows (sheet is formatted to 100 rows), but when I sort by L I get
this...

F G H I J
K L M
score1 score2 name name score3
score4 progress Next Olive 2
Ogilvy Perry 2
2
2
2




8 8 Aldi Billy 9 9 1
1 1 Elves Freda s 4 4 3
2 2 Foster Gail 4 4 2
1 1 Debehham Ernie 3 3 2
1 1 Hills Jenny 2 2 1
2 2 Kwik Lisa 2 2 0
1 1 Morrison Nathan 2 2 1
1 1 Boots Claire s 1 1 0
2 2 Google Harry sa 1 1 -1
1 1 Jones Kevin sa+ 1 1 0
2 2 Lidl Mason 1 1 -1


Am using Excel 2003, all data comes from other sheets, all use IF, columns G
and L use a LOOKUP and M is an IF(COUNT . I got help from here yesterday to
do the IF(COUNT to remove error values, but this hasn't solved the sorting
problem. I have tried everything I can think of to sort so that the data is
at the top and the empty rows are at the bottom (or deleted) but am totally
stumped.
Hope you can help
Thanks
Mrs T

This forum really makes it unclear what the results/problem is since it
reformats everything.

Can you post up your workbook and provide a link? Or come over to

http://www.excelforum.com/

And post your question there. You can click on GO ADVANCED and use the
paperclip icon to attach a workbook to your question, makes solving things
like this much easier.

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Mrs T." wrote:

Hi,
sorry - I have another problem! In my assessment sheet the data looks like
this...


F G H I J
K L M
score1 score2 name name score3
score4 progress
8 8 Aldi Billy 9 9 1
1 1 Boots Claire s 1 1 0
1 1 Debehham Ernie 3 3 2
1 1 Elves Freda s 4 4 3
2 2 Foster Gail 4 4 2
2 2 Google Harry sa 1 1 -1
1 1 Hills Jenny 2 2 1
1 1 Jones Kevin sa+ 1 1 0
2 2 Kwik Lisa 2 2 0
2 2 Lidl Mason 1 1 -1
1 1 Morrison Nathan 2 2 1
Next Olive
Ogilvy Perry

I wanted to write a macro that would sort the data by column L and remove
empty rows (sheet is formatted to 100 rows), but when I sort by L I get
this...

F G H I J
K L M
score1 score2 name name score3
score4 progress Next Olive 2
Ogilvy Perry 2
2
2
2




8 8 Aldi Billy 9 9 1
1 1 Elves Freda s 4 4 3
2 2 Foster Gail 4 4 2
1 1 Debehham Ernie 3 3 2
1 1 Hills Jenny 2 2 1
2 2 Kwik Lisa 2 2 0
1 1 Morrison Nathan 2 2 1
1 1 Boots Claire s 1 1 0
2 2 Google Harry sa 1 1 -1
1 1 Jones Kevin sa+ 1 1 0
2 2 Lidl Mason 1 1 -1


Am using Excel 2003, all data comes from other sheets, all use IF, columns G
and L use a LOOKUP and M is an IF(COUNT . I got help from here yesterday to
do the IF(COUNT to remove error values, but this hasn't solved the sorting
problem. I have tried everything I can think of to sort so that the data is
at the top and the empty rows are at the bottom (or deleted) but am totally
stumped.
Hope you can help
Thanks
Mrs T

Hi,
I have registered at Excelforum, but can't upload sheet. Is there anything
else I can do? I daren't upload whole workbook as their is real children's
data in there.
Thanks
Mrs T

"JBeaucaire" wrote:

This forum really makes it unclear what the results/problem is since it
reformats everything.

Can you post up your workbook and provide a link? Or come over to

http://www.excelforum.com/

And post your question there. You can click on GO ADVANCED and use the
paperclip icon to attach a workbook to your question, makes solving things
like this much easier.

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Mrs T." wrote:

Hi,
sorry - I have another problem! In my assessment sheet the data looks like
this...


F G H I J
K L M
score1 score2 name name score3
score4 progress
8 8 Aldi Billy 9 9 1
1 1 Boots Claire s 1 1 0
1 1 Debehham Ernie 3 3 2
1 1 Elves Freda s 4 4 3
2 2 Foster Gail 4 4 2
2 2 Google Harry sa 1 1 -1
1 1 Hills Jenny 2 2 1
1 1 Jones Kevin sa+ 1 1 0
2 2 Kwik Lisa 2 2 0
2 2 Lidl Mason 1 1 -1
1 1 Morrison Nathan 2 2 1
Next Olive
Ogilvy Perry

I wanted to write a macro that would sort the data by column L and remove
empty rows (sheet is formatted to 100 rows), but when I sort by L I get
this...

F G H I J
K L M
score1 score2 name name score3
score4 progress Next Olive 2
Ogilvy Perry 2
2
2
2




8 8 Aldi Billy 9 9 1
1 1 Elves Freda s 4 4 3
2 2 Foster Gail 4 4 2
1 1 Debehham Ernie 3 3 2
1 1 Hills Jenny 2 2 1
2 2 Kwik Lisa 2 2 0
1 1 Morrison Nathan 2 2 1
1 1 Boots Claire s 1 1 0
2 2 Google Harry sa 1 1 -1
1 1 Jones Kevin sa+ 1 1 0
2 2 Lidl Mason 1 1 -1


Am using Excel 2003, all data comes from other sheets, all use IF, columns G
and L use a LOOKUP and M is an IF(COUNT . I got help from here yesterday to
do the IF(COUNT to remove error values, but this hasn't solved the sorting
problem. I have tried everything I can think of to sort so that the data is
at the top and the empty rows are at the bottom (or deleted) but am totally
stumped.
Hope you can help
Thanks
Mrs T

I presumed you would create a smaller version and change the names to
something innocuous. First time posters are allowed to attach a sheet, so be
sure to GO ADVANCED and use the paperclip to upload your sample.

You could also send it to me...

Jerry AT devstudios DOT com
--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Mrs T." wrote:

Hi,
I have registered at Excelforum, but can't upload sheet. Is there anything
else I can do? I daren't upload whole workbook as their is real children's
data in there.
Thanks
Mrs T

Thank you - I have emailed a copy to you
Mrs T

"JBeaucaire" wrote:

I presumed you would create a smaller version and change the names to
something innocuous. First time posters are allowed to attach a sheet, so be
sure to GO ADVANCED and use the paperclip to upload your sample.

You could also send it to me...

Jerry AT devstudios DOT com
--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Mrs T." wrote:

Hi,
I have registered at Excelforum, but can't upload sheet. Is there anything
else I can do? I daren't upload whole workbook as their is real children's
data in there.
Thanks
Mrs T