Dear all,

I'd like to produce a dynamic named range called "Margin" (highlighted in green in the enclosed file) that will change as more columns are added to a table.

The named range would be used in a "Top 10" table calculation, using the AGGREGATE function. The formula finds highest to lowest margin values and ranks them.

I have tried to use the formula OFFSET(C11,0,0,1,COUNTA(11:11)) in the name manager, but I get odd results.

Is there another way to define the named range along row 11 as I add more jobs to the table?

I enclosed an example file.COUNTA and OFFSET.xlsx

Thanks