I have numbers from A1 to A9 and have names from B1 to B9. On cell A10, I have formula =Max(A1:A9) and this is my lookup number.My lookup array is $A$1:$B$9. What I mean dynamic is if any value in cell A1 to A9 changes,the lookup value also change. I have tried several times but it works in few tries then it will stop.
Anyone could help me out?
Thanks,
Anyone could help me out?
Thanks,