Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Nou pe simpatie:
Isabela_9my pe Simpatie.ro
 | Femeie
24 ani
Constanta
cauta Barbat
32 - 48 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| #1 |
TRaPModerator
Postari: 960
|
|
key words: repeat multiple times repeat values spill SEQUENCE INDIRECT COUNTA
I have a column of data starting in B3 with variable last cell for which I need a spill range with cells multiplied a given number of times.
E.g. column:
Apple
Banana
Pear
Apricot
And I need each of them 3 times:
Apple
Apple
Apple
Banana
Banana
Banana
Pear
Pear
Pear
Apricot
Apricot
Apricot
Simply change the number to the number of your desire, and of course the range to the one you need.
=LET(
NR; 3;
data; INDIRECT("B3:B" & COUNTA(B:B)+1);
n; COUNTA(data);
INDEX(data; INT((SEQUENCE(n * NR;;1;1)-1)/NR)+1)
) |
Source: ChatGPT
|
|
| |
|
| #2 |
TRaPModerator
Postari: 960
|
|
|
| |
|
| #3 |
TRaPModerator
Postari: 960
|
|
Alternative to LET for simply repeating one string a given or counted number of times.
Based on the number of items in a range:
| =INDEX("eur/year"; (SEQUENCE(COUNTA(M4:M184);;1;1)-1)/COUNTA(M4:M184)+1) |
Based on a fixed/given number:
=INDEX( "eur/year"; (SEQUENCE(181;;1;1)-1)/181+1)
|
|
| |
|
