Related Posts
Hi Team,
Hope you guys are doing well. I am planning to join Kyndryl on band 7b for cybersecurity domain. Want to know how is the environment there in terms of job security, wlb and hike? There are mixed reviews all over the places reg Kyndryl so posting here to get insight form you.Kyndryl Inc.
Also anything else you would like to add is good for me to decide as I have to choose between Accenture and Kyndryl (I was with Accenture and know what I will be getting and work there).
Where did that phone come from? 😆

Additional Posts in Excel Genius
Would anyone be willing to teach me vlookup?
Anyone know what these badges are?

New to Fishbowl?
unlock all discussions on Fishbowl.






You probably need a basic Excel course lol
This is so true. Imagine not knowing basic excel in 2024.
=cell above + 1
Enter 1, 2 and 3 in the rows where you want them then highlight those three cells. See the little dot in the corner of the cell with the 3 in it? Click and drag it down as far as you want cells consecutively numbered.
flash fill?
1 enter
2 enter
3 enter
4 enter
Etc…
No dude you have to use indexmatch + xlookup + countifs
I did it once 10 years ago from 1-100000 for rows and A-ZZ for columns. I save that workbook to a separate cold storage because it’s too sacred to save on my computer where’s hackers could steal it.
Now whenever I find myself in a similar place to OP, i load up my cold storage drive, copy and paste the columns and rows I need, and voila 👩🏼🍳💋
Work smarter, not harder friends.
Coach
Bravo 👏 🙌
Sequence
Coach
A lot of sarcasm in this thread, wow! =SEQUENCE(‘number of rows’) is what you want. Can also do number of columns, and you can change the starting point and step.
=row(same cell entered for formula)-row(header). Anchor header completely and row no will change if you move rows around
1,2,click and drag across or down. Works for most patterns, dates etc.