- Registration date
- Sunday September 12, 2010
- Last seen
- June 17, 2021
If you want to do this with formula's, then try this:
Sheet 2, cell A2: =IF(Sheet1!$C2="Blah",Sheet1!A2,"")
Drag this formula to the right so it covers the 6 used columns. Then drag those 6 cells down as far as desired.