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
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.