Regarding yesterday's post To get the MAX Value

[anuvnair]

Sir,


Yesterday you have given me the formula as

=MAX(if(($A$1:$A$6>29)*($A$1:$A$6<40),$A$1:$A$6,""))

Today because of typing this much - i have 100 excel sheets with 250 values in each to find the max value- i just selected the cell instead of typing $A$1:$A$6.So the formula now becomes =MAX(if((A1:A6>29)*(A1:A6<40),A1:A6,"")). It also works. So why we putting '$'. is there any difference between the two formulas...


Thanks,


Anu

 

[shrivallabha]

This is called relative and absolute references.

http://www.cpearson.com/excel/relative.aspx


The difference will kick in if you have to copy down / across the same formula.

 

[bobhc]

Good day anuvnair


This question is directly linked to you previous post and you should have posted it there.

If you start a new post each time forum members will not be able to follow the question as your post will become very messy very quickly. NEW SUBJECT NEW POST new question about a previously published question same post.

 

[anuvnair]

Now I understood.Thank you Mr.Shrivallabha.


Also thanks for your information bobh. Will never repeat....


Regards

Anu