Duplicate row [Closed]

Report
-
Posts
2758
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 17, 2021
-
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


1 reply

Posts
2758
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 17, 2021
462
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!