how would I do this?
I have a web query that produces the following:
cell F7 = OVER 8 +115
cell F9 = UNDER 8 -125
cell F11= OVER 9.5 +112
cell F13= UNDER 9.5 -122
cell F15= OVER 8.5 +100
cell F17= UNDER 8.5 -110
cell F19= OVER 10 +106
cell F21= UNDER 10 -116
I would like cells J7:J21 to equal
8
8
9.5
9.5
8.5
8.5
10
10
How would I do this? Thanks
I would like to setup cells J7:J21 so they are equal to
|