Forum Discussion
Formula to repeat dynamic patterns
Thank you in advance. Is there a formula I can use to generate the patter in column D based on the duplicate data in columns A-C? For example, I need to enter "Y" 12 times after "N" if there are 12 ...
Can you please attach a sample file showing your sample input data and then show your desired output manually. We will try to make that output using formula. Also please mention your Excel edition/version info so that we can suggest appropriate formula.