T
Tami
sorry for the urgency but i thought i posted this message yesterday afternoon
and assumed that i could make some headway this am...but it doesn't appear to
have posted.
Question:
is there a way to convert a forumula that looks like this =a1+a2+a3 to
Max(a1,a2,a3)? also can i convert =sum(a1:a3) to max(a1:a3).
in the first case it has 3 entries, in another instance it might have 4, 5,
etc.
do i use the subtitute function?
and assumed that i could make some headway this am...but it doesn't appear to
have posted.
Question:
is there a way to convert a forumula that looks like this =a1+a2+a3 to
Max(a1,a2,a3)? also can i convert =sum(a1:a3) to max(a1:a3).
in the first case it has 3 entries, in another instance it might have 4, 5,
etc.
do i use the subtitute function?