need to extract data by certain year

[dark5205]

Hi guys,

I have 2 columns. One is the years and one is the the associated data

I need the associated data(BP values) to be sorted in years like shown in excel sheet attached

thanks in advance

[:) Sixthsense :)]

Not clear about your expected outcome can you please show the expected result also?

[dark5205]

I want the BP values to catergorised in years as shown in column F

[Kevin UK]

Hi dark5205

Try the following Array formula in E2, commit the formula CTRL + SHIFT + ENTER, copy across to S2 and down.

Please Login or Register  to view this content.