D
Doehead
Hi all,
I am trying to copy a complete row of data to another sheet when it meets
the criteria:
Source data is in sheet: Master, cols A to AU,
data from row 2 down, with key col X & criteria value: Closed
On new sheet: Closed
Placed in A2:
=IF(Master!X2="","",IF(OR(Master!X2=â€Closedâ€),ROW(),""))
Left A1 blank for header row
In B2:
=IF(ROWS($1:1)>COUNT($A:$A),"",INDEX(x!A:A,SMALL($A:$A,ROWS($1:1))))
When I type these formulas in the function box they also show in the
respective cell.
Why? Any help appreciated!
I am trying to copy a complete row of data to another sheet when it meets
the criteria:
Source data is in sheet: Master, cols A to AU,
data from row 2 down, with key col X & criteria value: Closed
On new sheet: Closed
Placed in A2:
=IF(Master!X2="","",IF(OR(Master!X2=â€Closedâ€),ROW(),""))
Left A1 blank for header row
In B2:
=IF(ROWS($1:1)>COUNT($A:$A),"",INDEX(x!A:A,SMALL($A:$A,ROWS($1:1))))
When I type these formulas in the function box they also show in the
respective cell.
Why? Any help appreciated!