I have a sheet that has a 6x12 table that is copied each day using a macro. The table has 6 columns that use the rank function and then an overall average. I want to know if there is a way to use the rank function with a relative range so when the table is copied below on the next day the rank function will work for the new table. Any suggestions are appreciated!