Ranking to include new list

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?
 
A

Ashish Mathur

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
 
J

Jacob Skaria

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

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

Solution to tricky problem of showing exactly Top N rows in Pivottable 0
Rank Formula 1
Insert Multiple Fields without Dialog closing between each... 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Current Region in a formula 1
Ranking without skipping ranks and percentile 3
Macro to select and delete levels of a document 2
Using rank to rate the winners in a competition 2

Top