automatic display of last 2 entries in tHe column to specified cel
What if there are 6 equal last enry rows?
--
If this helps, please click the Yes button
Cheers,
Shane Devenshire
"mike CBA" wrote:
what is the formula for automatically displaying the last 2 entries in
columns C and D to columns A and B. But, if the last 2 entries are the same,
only the 2nd last will be displayed. to illustrate:
1st scenario:
A B C D
5 10.50 20 10.50
10 11.00 15 11.00
5 10.50
10 11.00
2nd scenario:
A B C D
5 10.50 20 10.50
15 10.500
5 10.50
5 10.50
|