papillon
Board Regular
- Joined
- Oct 14, 2002
- Messages
- 88
Hallo,
I have a spreadsheet with 43,558 rows in which column A contains either 1 or 0. I want to strip out the rows which contain a 1 in column A leaving the rows with 0 in A.
Is there a formula to do this please?
Many thanks in advance,
papi
I have a spreadsheet with 43,558 rows in which column A contains either 1 or 0. I want to strip out the rows which contain a 1 in column A leaving the rows with 0 in A.
Is there a formula to do this please?
Many thanks in advance,
papi