Forum Discussion
Transferring content from sheet1 to sheet2
Hi all, I believe this is a simple one. Sheet1 2 columns: column A contains text cells, column B contains info on the category of the text in A. I need to transfer/copy into Sheet2 all the ...
The FILTER function can do it. I've been able to make it work with your data on one category at a time; I've not yet been able to incorporate an OR that would enable it to do both categories---but I'll keep trying.
Here's the formula: =FILTER(Foglio1!A2:B35,Foglio1!B2:B35="WHITE")