Ranking to include new list

  • Thread starter Thread starter Bagia
  • Start date Start date
B

Bagia

Hello,

How would I include a new row of data to be included in my Rank function
automatically w/o having to manually edit the function to include the new
inserted row? Is there a way?
 
Hi,

Highlight the range and press Ctrl+L to convert it from a range to a list.
Now when you add data to this range, the range will automatically expand

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
Dear Bagia

Insert the new row within the range.
OR
Leave the last row blank and include in the RANK range. Everytime insert a
row keeping the cursor in this blank row..
 
Back
Top