Isn't there a simpler way?
Thought the suggested way wasn't all that tough <g
Perhaps you'd like to try the other suggestions posted by Chuck & Ragdyer.
Just adopt the one that is "simplest" to you or one that you feel most
comfortable with .. The choice is yours.
Just some explanations on:
.. the $A:$A and $1:$1 reference
$A:$A is an entire *col* reference (col A), the dollar signs "$" are meant
to lock the references so that it doesn't change when you copy the formula
across. Col A is where the vertical references are located.
Likewise ..
$1:$1 is an entire *row* reference (row1), the dollar signs "$" are to lock
the references so that it doesn't change when you copy the formula down.
Row1 is where the horizontal references are located.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Pittsburgh Jack" wrote in
message ...
Isn't there a simpler way? I don't understand the $A:$A and $1:$1
reference
in the formula.
Pittsburgh Jack
|