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.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
Larina23
 | Femeie
19 ani
Timis
cauta Barbat
28 - 80 ani |
|
|
TRaP
Moderator
Inregistrat: acum 7 ani
Postari: 846
|
|
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
|
|
| pus acum 6 zile |
|