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 Tinny426
you could use this formula:
=SORT('Centimetre Perfect'!A5:D16,4,1)
Put it in the top left cell of your output range and adjust it to the source range (in my example A5:D16). The formula will spill automatically to all the other cells.
It sorts the table by column number 4 (= second argument)
It sorts the table in descending order (-1 in third argument; ascending would be 1)
Please note that the SORT function is only available in Microsoft 365.
Thanks Martin