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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 13, 2016 at 11:31 AM
Related:
- Duplicate row
- How to duplicate a google doc - Guide
- Saints row 2 cheats - Guide
- How to delete row in word - Guide
- How to avoid duplicate records in sql select query - Guide
- How to convert column to row in notepad++ ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Jun 13, 2016 at 11:31 AM
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
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
