Forum Discussion
Solved
Need to move informatation from 1 spreadsheet to another spreadsheet and rearrange
HI all, I have tried to work out a formula for what i need, but no success. I need to display the first 4 columns of data of the CENTIMETRE PERFECT worksheet (first screenshot) in the first 4 co...
Hi Richard,
sure you can, you just need to include the FILTER function.
=SORT(FILTER('Mixed species SEP 9-11'!A5:D100,'Mixed species SEP 9-11'!C5:C100="S"),3,-1)
Let me know if this works for you.
Cheers,
Martin
HI all,
I have tried to work out a formula for what i need, but no success.
I need to display the first 4 columns of data of the CENTIMETRE PERFECT worksheet (first screenshot) in the first 4 columns of the COMPETITION RESULTS worksheet (second screenshot) in descending order using the values in Column 4.
Can someone give me a formula for what I need? Or is there another solution?
Much appreciated, Richard.