Duplicate row

Closed
Hector - Jun 2, 2016 at 11:03 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 13, 2016 at 11:31 AM
Hello,

How would the formula look like for the following:

Sheet 1 has 100 rows
Sheet 1 has 6 columns
Row 1 has headings

Formula would go on sheet 2
Duplicate row from sheet 1 "if" column 3 data equals "blah"

Do this for all rows in sheet 1

Any help is appreciated thx
Hector


Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Jun 13, 2016 at 11:31 AM
Hi Hector,

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.

Best regards,
Trowa
0