Dear expert,
I have a if function command, if fulfil will show up 1 in coulmn AD.
I would like to extract if Column AD shows 1, then return figures on the
same row from Column AE
1 can be from AD15:AD65
I would like to get the figures from AE15:AE65 if correponding cell in AD is
"1".

I don't know much "1" in column AD everyday.
It can be more than 10 or only one "1" in day.
I cannot delete the rows.
Is there a function command in AD 67:AD77 that can help me to list out the
outcome please?

AD AE

1 27.87844996
54.29813094
40.83519777
37.15067296
1 33.52116938
48.58919105
38.1993278
1 34.64355613
41.2104436
38.86725991
32.26322546
22.91763959
1 18.60600562
43.92524382
50.81082114
55.21066779
57.49200676
57.49200676
1 50.13725124