Ask a new question

Excel Pattern Auto-fill Question

Hello! I am trying to fill out a large data sheet in excel. I have repeating values in one column (days 1-34) repeated 2000 times (so the excel sheet extends to 68000). I have another column that is an identifier for the days column. i.e. the first 1-34 days is labeled as 1, the second 1-34 days is labeled as 2, and so on. I want to create an auto-fill pattern that follows this pattern so I don't have to type 1 to 2000 following the days. Any suggestions?
Answer
Answer

At the top of an unused column (e.g. A1 on a blank worksheet) put =MOD(ROW(1:1)-1, 34)+1

Beside it (e.g. B1) put =INT((ROW(1:1)-1)/34)+1

Tap F5, type A1:B68000 and click OK.

Tap Ctrl+D.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Answer
Answer

Hi

Let's say column A has the repeated values  (days 1-34)  and Column B is for the Identifiers

Then

Type the number 1 in the first row in column B then on the second row

Try the following formula  =IF(A2=1,B1+1,B1) and drag it down

In the picture below pattern is from 1 to 5 just for the purpose of making the changes visible in the picture

I hope this helps you

Regards

Please,
Consider marking this reply as the answer to your question if it does so.
It will help others in the community with similar problems or questions.
Thank you in advance


Regards
Jeovany CV

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated October 5, 2021 Views 79 Applies to: