I have data in columns A:C in Sheet 1 where column C states either "valid" or "invalid." I want to copy all the data where column C = "Invalid" to Sheet2
I tried the following Array formula in Sheet2;
{=IF(Sheet1!$C1:$C$500 ="Invalid",Sheet1!A1:C500,"")}
but that leaves blank spaces in all the rows that were valid. I'm missing something here. Any help? Thanks in advance
ChemistB
Bookmarks