00:00you are using advanced excel and want to our dynamic list of roman numberals generated instantly
00:06without dragging then use this formula for this you need to click on the empty cells where you
00:12want to roman numbers to be appeared up put the equal sign type roman open the bracket type s e
00:21q u e n c e sequence and open the bracket and put the number where you want the vertical
00:29array of roman numbers to be appeared for example 100 and close the bracket and again close the
00:36bracket to complete the formula and just hit enter and here you can see that excel has generated auto
00:43roman numbers in excel 1 to 100 you can simply change the number for example 10 it will be cut
00:53to the 10 and if you want to make it to 500 you can easily change it for 500
01:02like this one so this way you can combine the dynamic array magic of the sequence function with the roman
01:09function in advanced excel with just one simple formula you can generate 10 50 or even 1000 plus
01:16roman numbers automatically if you found this tip helpful don't forget to like subscribe and hit the
01:23notification bell for more quick excel hacks thanks for watching
Comments