Dragging Down Skipping Rows

0 votes
I have spent the last many hours working on this. I have read previous posts, but I still can't resolve my problem. I want to paste the following data into cell G4 after copying a formula there. M4 = Cell G4. G10 = M5, and G16 = M6. M7 in cell G22. each 6th row is skipped, and so on until row 280.
Feb 26, 2023 in Others by narikkadan
• 63,420 points
233 views

1 answer to this question.

0 votes

Try this:

IF(IFERROR(MATCH(ROW(),$C$4:$C$12,0),0)>0,INDIRECT("M"&4+IFERROR(IF(ROW()=4,0,MATCH(ROW(),$C$4:$C$12,0)-1),0)),"")

enter image description here

You can also use the help column in C4:C12, which you will need to expand to get to 280, to see whether there is a method to shorten the formulae.

answered Mar 17, 2023 by Kithuzzz
• 38,010 points

Related Questions In Others

0 votes
1 answer

VBA code for dragging down contents of a cell

Change this ActiveCell.Offset(k + 7, 0).AutoFill Range(ActiveCell.Offset(0, 0), ActiveCell.Offset(2, ...READ MORE

answered Jan 9, 2023 in Others by narikkadan
• 63,420 points
896 views
0 votes
1 answer

Row's Children Must Not Contain Any Null Values Flutter Error.

Hi@akhtar, You get this error because in your ...READ MORE

answered Sep 15, 2020 in Others by MD
• 95,440 points
4,902 views
0 votes
1 answer

How to delete duplicate rows in SQL Server?

To answer your query, note that CTEs ...READ MORE

answered Feb 10, 2022 in Others by Soham
• 9,700 points
863 views
0 votes
1 answer

Spell number in excel 2013 using 2 rows

Hello, there are a few steps to ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
348 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
1,057 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
1,350 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
• 13,670 points
662 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18, 2022 in Others by gaurav
• 23,260 points
2,183 views
0 votes
1 answer

What VBA code would I use to concatenate cell A2 & B2 in cell C2 and then have it Autofill down the column?

Solution Find the last row. Write a formula to ...READ MORE

answered Feb 14, 2023 in Others by Kithuzzz
• 38,010 points
591 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP