S
Sarah (OGI)
In cell AR12 I have entered the following formula, which works fine. It is
designed to show the last figure entered in any 4th cell in the range G12 to
AN12 (inclusive). For example, if the last figure entered, appears in cell
V12, then AR12 should show the V12 value.
=IF(COUNT(G12,J12,M12,P12,S12,V12,Y12,AB12,AE12,AH12,AK12,AN12)=0,"",INDIRECT(CONCATENATE("R",ROW(),"C",((COUNT(G12,J12,M12,P12,S12,V12,Y12,AB12,AE12,AH12,AK12,AN12))*3)+4),FALSE))
However, I would now also like to show the second to last figure entered, in
order to do a comparison. So where V12 contains the last available figure, I
would like to show in AS12, the value of S12 (the 4th cell prior to the last
entered figure).
Any ideas?
designed to show the last figure entered in any 4th cell in the range G12 to
AN12 (inclusive). For example, if the last figure entered, appears in cell
V12, then AR12 should show the V12 value.
=IF(COUNT(G12,J12,M12,P12,S12,V12,Y12,AB12,AE12,AH12,AK12,AN12)=0,"",INDIRECT(CONCATENATE("R",ROW(),"C",((COUNT(G12,J12,M12,P12,S12,V12,Y12,AB12,AE12,AH12,AK12,AN12))*3)+4),FALSE))
However, I would now also like to show the second to last figure entered, in
order to do a comparison. So where V12 contains the last available figure, I
would like to show in AS12, the value of S12 (the 4th cell prior to the last
entered figure).
Any ideas?