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.
Hi again Martin,
Thanks heaps again for taking the time to help out with my problem. The formula in text was slightly different to the formula outlined in red. But the argument tips you supplied allowed me to make the right changes to get a working formula.
Now i understand how the formula works, i can extend the worksheet as far as i need.
If i ever get to Bavaria, i will look you up and buy you a beer!!
Thanks again Richard.
Thanks heaps again for taking the time to help out with my problem. The formula in text was slightly different to the formula outlined in red. But the argument tips you supplied allowed me to make the right changes to get a working formula.
Now i understand how the formula works, i can extend the worksheet as far as i need.
If i ever get to Bavaria, i will look you up and buy you a beer!!
Thanks again Richard.