Lock cells together and rank rows

[About A Steve]

Basically I have recently started my own personal music chart and I'm having problems with a Year To Date page.

Basically all I want to know how to do is how to lock some cells together and rank many rows of those cells with 1 column where the total is?

I have attached the spreadsheet as a zip files as I was having problems uploading it as a xls file.

If anybody could help I would really appreciate it.

Thanks

[shg]

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

[About A Steve]

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

Okay, it's changed. Sorry about that.

[shg]

Steve, that's even worse.

Please read the forum rules (no kidding) and try again.

[About A Steve]

Sorry I did read then and just skimmed them sorry. I have tried again, is it okay this time?

[shg]

Better, thanks.

I don't know what you mean about 'locking cells together'

To attach a workbook, scroll down to the Manage Attachment button in the reply window, or push the button with the paperclip.

[About A Steve]

Better, thanks.

I don't know what you mean about 'locking cells together'

To attach a workbook, scroll down to the Manage Attachment button in the reply window, or push the button with the paperclip.

I've attached it as a zip file now.

I can rank a column of cells but that just changes that column around but what I want to know how to do is attach different cells together so that when the YTD totals move around everything else related with that cell moves around with it, like the last weeks position column, the song and artist column and the chart run columns.

[shg]

It's not attached yet ...

[About A Steve]

It's not attached yet ...

It shows up on the first post for me.

[About A Steve]

Bump. If anyone can help is is trying to help please say so I don't have to worry so much. I would prefer it done ASAP so when you can please tell me how as it would be very helpful.

[shg]

I looked at your workbook and couldn't see what you were trying to do.

[About A Steve]

I looked at your workbook and couldn't see what you were trying to do.

Okay I don't know why I attached a spreadsheet with no info on.


I'll attach another one.

What I want to do is rank the rows using the amount of points from highest to lowest but with that I want to keep the artists, LW, songs and chart run columns with the related total amounts of points.

I hope you can understand it a bit more now.

[shg]

Delete blank cells A2:DG2.

[About A Steve]

Thanks. It's solved now.