this saved me hours! thank you so much. my data was 121 x 21 - products and years so it's different from yours but so similar in terms of the scale. thanks once again!!
What if I would like to get the first employee 10 times, the second one 5 times, the third one 13 times, etc. (Already given in a table next to the employees) So not every employee exactly 22 times, but each employee a given number of times. Not with dates, but just repeating the employees, each of them a set number of times? Thank you for the informative video! So if the 22 is a variable number, ranging from 1 to 50 for each employee, how would I incorporate that in my formula?
You can try the row function. Row(A1:A30) will generate an array of 1 to 30. But this can only used inside another function. This will not be very effective as a standalone formula in older version.
Do you mean to say you don't want to repeat all values but only a handful of values? Perhaps you can then put that under a Let function =Let(Frng, Filter(Range, ), Rowno, rows(Frng),... Then use the Rowno variable instead of the rows of the actual data). The actual solution is little lengthy. If you specify the actual problem, I'll try sharing it.
How to count a Specific repeated word array in excel Example PPPPPPWWPPPPPP = 2 means P is repeated 2 times with an array of 6. I need formula for the same.
You can use Power Query. But it would be too sensitive to even a simple heading change. You will be setting your model up for an eventual model failure in future.
Superb sir...I was struggling with my office work but with this video I resolved my issue
I needed it to make a good data base of attendance 218 students for whole year of 365days. You helped me out. Thank you. It was very helpful
I cannot thank you enough 🙏. You just saved me hours of not so productive work... God bless you
Thank you, I was stuck at this for a long time and this one helped me.
this saved me hours! thank you so much. my data was 121 x 21 - products and years so it's different from yours but so similar in terms of the scale. thanks once again!!
I have similar type of task and you solved my problem, thank you so much👍
I was searching for this farmula. Thank you so much bro 😊
Thank You very much, your video helped me so much..
Thanks, this helped a lot in my monthly report
Really great video, thanks for the save❤
Yet another brilliant solution
Exactly what I was looking for.
Super sir
Well explain, thanks.
This was exactly the same I was looking for.
Verry good, just what I was looking for, verry cleaver solution
Superbb...master
Thanks!
sir, Can you guide me regarding power pivot at Excel please
very informative video sir!
Awesome
What if I would like to get the first employee 10 times, the second one 5 times, the third one 13 times, etc. (Already given in a table next to the employees) So not every employee exactly 22 times, but each employee a given number of times. Not with dates, but just repeating the employees, each of them a set number of times? Thank you for the informative video!
So if the 22 is a variable number, ranging from 1 to 50 for each employee, how would I incorporate that in my formula?
Try to inculcate vlookup in that case.
Awesome 👍
Really great
Hey, is there any method for older version of excel for "sequence"?
You can try the row function. Row(A1:A30) will generate an array of 1 to 30. But this can only used inside another function. This will not be very effective as a standalone formula in older version.
Hi, is there any way we can keep the format intact while repeating
Great
Sir if we have to do the same with applying filter how can we do it. I tried same but it doesn't work for me because of filter.
Do you mean to say you don't want to repeat all values but only a handful of values?
Perhaps you can then put that under a Let function
=Let(Frng, Filter(Range, ),
Rowno, rows(Frng),...
Then use the Rowno variable instead of the rows of the actual data).
The actual solution is little lengthy. If you specify the actual problem, I'll try sharing it.
I owe you a beer (or my first born son, whichever)
Not able to get index formula in employee id(B7#).... shows error
@@ProfectusLearning office 365 shared account
B7# works with tables.......thanks
Pls share the practice file
How to count a Specific repeated word array in excel Example
PPPPPPWWPPPPPP = 2 means P is repeated 2 times with an array of 6.
I need formula for the same.
It's to complex there are easy tricks available
You can use Power Query. But it would be too sensitive to even a simple heading change. You will be setting your model up for an eventual model failure in future.