How to I make a formula in excel to move rows around weekly

  • Thread starter Thread starter sehly
  • Start date Start date
S

sehly

Hi I am trying to work out a formula to move rows around each week. I am
organising a tipping comp and I would like the person who is leading for the
week to move to the top of the page followed by 2nd place then 3rd place and
so on down the page. Can this be done? It would mean that it would change all
the time. So I would like the full row to move but I don't know if it can be
done. Any help would be appreciated. I have 24 people to try and organise.
Thanks
 
Devise a formula for the ranking, select your range of data (including all
the relevant rows & columns), and then sort by your ranking column.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Locationg the first number in a row 2
Saving Formulas when addin rows 8
Adding cells by 2 criteria that move. 1
Excel EXCEL - using a date dependant formula to hide rows 3
Do I use a formula or a macro to copy cells? 3
Populating formulas in a spreadSheet with VBA 2
Using an "If" statement to move data from one column to another 10
Excel Help to copy information from one row at a time to another sheet 1

Back
Top