Related:
- How to paste data in alternate rows in excel
- How to paste every other row in excel - Best answers
- Excel paste every other row - Best answers
- How to calculate position in excel ✓ - Office Software Forum
- How to reset safe folder password without losing data ✓ - Android Forum
- Why cant i paste on instagram ✓ - Instagram Forum
- How to open excel file in notepad - Guide
- Gif in excel - Guide
1 response
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Oct 19, 2009 at 08:06 AM
Oct 19, 2009 at 08:06 AM
Hello
Try in E1 the following formula
=IF(D1="",INDEX($A$1:$A$12,ROW()/2),D1) and drag down
Copy the results and paste special values to D1
Try in E1 the following formula
=IF(D1="",INDEX($A$1:$A$12,ROW()/2),D1) and drag down
Copy the results and paste special values to D1
Jun 13, 2012 at 05:45 AM