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
Hello Martin_Weiss,
Thanks for the reply, its been very helpful. I think the SORT function on another worksheet could do the job. Just need to work this out, as I'm fairly new to the world of Excel.
Cheers Richard.
Thanks for the reply, its been very helpful. I think the SORT function on another worksheet could do the job. Just need to work this out, as I'm fairly new to the world of Excel.
Cheers Richard.
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.