00:00okay imagine this how would you assign a running number to each row if you have a table that looks
00:05something like this just casually slapping a few numbers in there and giving it a quick drag with
00:10a fill handler isn't exactly gonna cut it and i hope you're not planning to do it manually either
00:15i understand that for small tables manual indexing is feasible but for larger tables employing this
00:20very simple and straightforward formula becomes necessary check this out select the cells in column
00:25b press ctrl g special blanks and click ok and that's going to select all the blanks and then
00:31you're going to enter this formula equal n open parenthesis b6 close parenthesis plus one and then
00:37you press ctrl enter on your keyboard let's take a look at the formula for five seconds here the n
00:43function is designed to return a cell value to convert into a numeric number however if the
00:48argument provided in function n cannot be interpreted as numerical value it returns a zero for instance
00:54if i say equal n b6 which is a string it's going to return a value of zero but if
01:03i say n b7 like this
01:06it's going to return a value of one and that's how you get a running sequence number
Comments