TO Automatically Change the Sum range without Editing the Function

[Did13n]

Hello Master,

i got this solutions in this forum before and i would like to continue to ask ... but its already have tag SOLVED

the function is to sort value based on the highest, it works, but i have to change/edit the sum range column manually if i change the period

as attached, could it automatically changing whenever i change the period ?

please advise... thank you so much....

[FlameRetired]

One way to do this is with Dynamic Named Ranges. They shrink and grow automatically as data is entered / deleted. In Name Manager I put this formula which I named Feb_Sold.

=Sheet2!$D$3:INDEX(Sheet2!$D:$D,MATCH(1E+306,Sheet2!$D:$D,1))

Then replaced the D3:D14 references with that name. Edit for the remaining ranges and give them unique names in Name Manager.

Does this do what you want?

[Did13n]

Hi FlameRetired

thanks for your advise, now i will need to learn about Name Manager first to get your message .. let me go thru first

once i got it will tag this as SOLVED

[FlameRetired]

Super!

[Did13n]

ya, but i was thinking also to use OFFSET if possible.. Once i get home will try your advise

cheers :beer: