0

enter image description here How can I input data in column F with 4 consecutive data for each data like column E using the data in column D2:D?

Is it possible?

How should I modify the formula in F2?
=ARRAYFORMULA(IF(MOD(ROW(F2:F)-1,4)>0,{D2:D;D2:D;D2:D;D2:D},""))
Let me know if you have any other questions.

If I input data in column B , set consecutive data for each data in F2:F like E2:E.

Improve this question
2
  • So just to confirm, what you would want to achieve is if there are 4 or more duplicate data on Col E that matches on Col D, it would output the results on Col F, is that correct?
    – Century Tuna
    Commented Aug 21, 2023 at 15:03
  • thanks for your help. If you click the "enter image description here" in my text, you can check the sheet image.
    – choim
    Commented Aug 22, 2023 at 2:02
Related questions
1
Testing Excel with formula concatenate
0
How can I select an input row in google sheets
0
Automatically populate cell in Google Sheets when another cell in same row is manually filled but error
Load 6 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.