-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
repeat values
-
D
Repeat different values based on adjacent column numbered inputs
I'm trying to have values repeat a specified number of times, but the number can be different and is determined based on a drop down. I've attached a screenshot here: I would like a formula in G1 that says "For all values that equal "Yes" in Column C, repeat the corresponding values in Column...- Drew_
- Thread
- array repeat values sequence
- Replies: 3
- Forum: Excel Questions
-
D
Mod function to repeat values
Hi, Thanks for your assistance and time. This formula works nice for my needs, of repeating a value. =if(mod(column()-1,3)=0,$a$4,0) it displays my value every 3rd column, in row 4. I have 365 columns with date in row 3, for each day of the year. E3 has Jan 1, 2018. i want to put a date in...- ddnron
- Thread
- column date mod repeat values row
- Replies: 3
- Forum: Excel Questions
-
S
Repeat Values specified # of Times
<colgroup><col style="text-align: center;"><col style="text-align: center;"></colgroup><tbody> no of Times Name 2 Ali 5 Adnan 4 Butt Result 2 Ali 2 Ali 5 Adnan 5 Adnan 5 Adnan 5 Adnan 5 Adnan 4 Butt 4 Butt 4 Butt 4 Butt </tbody>- skhaliq
- Thread
- repeat values transpose
- Replies: 2
- Forum: Excel Questions
-
K
Extract Repeat Values
Hey guys, I am helping a friend with a statistical model and he wanted to know the repeat values. Till now having conditional formatting was enough (highlight the repeat values with simple countif <tbody> =COUNTIF($H7:$M7,B7)>0 </tbody> was serving the purpose but now he wants to do further...- kamcreationz
- Thread
- array formulas custom functions repeat values vba & excel
- Replies: 0
- Forum: Excel Questions
