comparing values of cells

[thunderspeed]

I have an excel sheet with 3 columns : Date , Value A , Value B .
I need to compare values A and B . If A>B I need the date to be printed . So at the end I can have a list in the same sheet or another sheet with all dates where the value of A > value of B .

Please help

[samba_ravi]

attach a sample file with expected result

[thunderspeed]

This is a sample file of input and required output

[samba_ravi]

f3=INDEX($A:$A,SMALL(INDEX(($B$1:$B$24<=$C$1:$C$24)*10^10+ROW($B$1:$B$24),0),ROWS(F$3:F3)))

Please Login or Register  to view this content.

Try this and copy towards down

[newdoverman]

This will give the results that you are looking for. The results are in the order of the original data. Enter where you want the results to start and fill down.

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

If by chance that formula gives you problems this should work:

Please Login or Register  to view this content.