Hi,

I'm not sure if I understood your question correctly but try this. In cell
A3, enter the following formula =if(and(C3=C4,D3=D4),C3,""). Now copy this
to the right and down.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"mike CBA" wrote in message
...
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