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

"Bagia" wrote in message
...
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?

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..

--
If this post helps click Yes
---------------
Jacob Skaria


"Bagia" wrote:

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?