comparing means by means of Least Significant Differences (LSD) method

Hi;

Actually I am not sure if this question is related with some macro expert in excel forum. In this table Values of IDs compare with ID_2. First the differences between ID_2 and other IDs were calculated. Then these "differences" are compared with the 2 corresponding values (LSDs). If the difference is less than LSD(0.05) an greater than LSD(.01) then a star inserted on related V as superscript. If the "difference is less than lsd(.01) then 2 stars will insert. Can we do them in excel for large tables by means of a macro?

Now take a look at the attached excel file:
1. If the value of a cell in DIFF columns is greater than its correspondent lsd(0.05) then no action.
2. If the value of a cell in DIFF columns is less than the LSD(0.05) and greater than LSD(0.01) then insert a star on its correspondent v as a super script
3. If the value of a cell in DIFF columns is less than the LSD(0.01 then insert two stars on its correspondent v as a super script
The DIFF columns show the values of difference of individuals with id_2 ie:
In v1: abs((id_1)-(id_2))=1.96 etc.

Cheers.......

Put this in Cell H2 and then copy down - is this roughly what you wanted? I think your description 1,2,3 is slightly muddled so I've assumed a couple of things.......
=IF(D2<=$D$14,C2,IF(D2>=$D$15,C2&"**",C2&"*"))

I also removed your own * from column C.

Hi;

Thank you Very much GooberTron For your very useful code. I did apply it for my table.

Regards
Ramim