see your other post
--
Biff
Microsoft Excel MVP
"newbie" wrote in message
...
PHYZX 5.26 5.29 5.31 5.33 5.33 5.33 5.33
NAMAX 11.27 11.34 11.41 11.51 11.57 11.54 11.40
JSVAX 13.45 13.59 13.58 13.68 13.66 13.66 13.42
Assuming PHYZX is at Sheet1!C2, I want to find the last entry for PHYZX
from
within Sheet2 for use in a formula specific to PHYZX. Value PHYZX can be
sorted to any row depending on other criteria, so the formula must always
find the last value for PHYZX. I would like to do this for each row.
i would prefer not to use VB code.
--
newbie