Forum Discussion
Need to move informatation from 1 spreadsheet to another spreadsheet and rearrange
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.
Hello Martin,
I have adjusted the formula above to suit and it works great, but now i want to add another condition!
This is the formula i am using. =SORT('Mixed species SEP 9-11'!A5:D100,3,-1)
In the array above, column C has the letters "S and "J" in random order down the column.
I want to catch only the rows with "S" in column C.
Can this be done? i think i have given enough information above, but i can add screenshots if required.
Cheers Richard.
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 Martin,
Thanks for your reply, The filter function is just what i was looking for! I wasn't aware of it before.
The formula you gave me works great!👌
Cheers Richard.