selecting specific numbers using if

[fmri]

Hi all,

I have this column ( as a small example ) :
40
40
40
0
0
0
50
50
50
0
0
0
60
60
60
0
0
0

I want to select for example the 40's and only the 0's that follow it. So in this example the answer will be like this :

40
40
40
0
0
0


Can u please guide me ?



Thanks

AS

[Pete_UK]

Assume your data starts in A2 (insert a blank row 1 if it currently starts in A1), then you can put this in the next adjacent empty column (e.g. cell B2):

=IF(A2=0,B1,A2)

then copy down. Then you can apply a filter to column B to select 40, and those entries as well as the zeros which follow will be shown.

Hope this helps.

Pete