answersLogoWhite

0


Best Answer

You can use the ROMAN function. It converts number into Roman Numerals for values from 0 to 3999. So you could do something like:

=ROMAN(1)

To count, you could enclose the COUNT function to count cells in a ROMAN function:

=ROMAN(COUNT(A2:A20))

If you want to create a column of Roman numerals without have to individually put each number in the function, you could use the ROW function. So if you are in row 1 in any column, you could put in the following formula and copy down:

=ROMAN(ROW())

If you want to start at 1, but are not in row 1, then deduct the amount needed to get to row 1. So if you were in row 23, then you would deduct 22 and copy down, like this:

=ROMAN(ROW()-22)

You can use the ROMAN function. It converts number into Roman Numerals for values from 0 to 3999. So you could do something like:

=ROMAN(1)

To count, you could enclose the COUNT function to count cells in a ROMAN function:

=ROMAN(COUNT(A2:A20))

If you want to create a column of Roman numerals without have to individually put each number in the function, you could use the ROW function. So if you are in row 1 in any column, you could put in the following formula and copy down:

=ROMAN(ROW())

If you want to start at 1, but are not in row 1, then deduct the amount needed to get to row 1. So if you were in row 23, then you would deduct 22 and copy down, like this:

=ROMAN(ROW()-22)

You can use the ROMAN function. It converts number into Roman Numerals for values from 0 to 3999. So you could do something like:

=ROMAN(1)

To count, you could enclose the COUNT function to count cells in a ROMAN function:

=ROMAN(COUNT(A2:A20))

If you want to create a column of Roman numerals without have to individually put each number in the function, you could use the ROW function. So if you are in row 1 in any column, you could put in the following formula and copy down:

=ROMAN(ROW())

If you want to start at 1, but are not in row 1, then deduct the amount needed to get to row 1. So if you were in row 23, then you would deduct 22 and copy down, like this:

=ROMAN(ROW()-22)

You can use the ROMAN function. It converts number into Roman Numerals for values from 0 to 3999. So you could do something like:

=ROMAN(1)

To count, you could enclose the COUNT function to count cells in a ROMAN function:

=ROMAN(COUNT(A2:A20))

If you want to create a column of Roman numerals without have to individually put each number in the function, you could use the ROW function. So if you are in row 1 in any column, you could put in the following formula and copy down:

=ROMAN(ROW())

If you want to start at 1, but are not in row 1, then deduct the amount needed to get to row 1. So if you were in row 23, then you would deduct 22 and copy down, like this:

=ROMAN(ROW()-22)

You can use the ROMAN function. It converts number into Roman Numerals for values from 0 to 3999. So you could do something like:

=ROMAN(1)

To count, you could enclose the COUNT function to count cells in a ROMAN function:

=ROMAN(COUNT(A2:A20))

If you want to create a column of Roman numerals without have to individually put each number in the function, you could use the ROW function. So if you are in row 1 in any column, you could put in the following formula and copy down:

=ROMAN(ROW())

If you want to start at 1, but are not in row 1, then deduct the amount needed to get to row 1. So if you were in row 23, then you would deduct 22 and copy down, like this:

=ROMAN(ROW()-22)

You can use the ROMAN function. It converts number into Roman Numerals for values from 0 to 3999. So you could do something like:

=ROMAN(1)

To count, you could enclose the COUNT function to count cells in a ROMAN function:

=ROMAN(COUNT(A2:A20))

If you want to create a column of Roman numerals without have to individually put each number in the function, you could use the ROW function. So if you are in row 1 in any column, you could put in the following formula and copy down:

=ROMAN(ROW())

If you want to start at 1, but are not in row 1, then deduct the amount needed to get to row 1. So if you were in row 23, then you would deduct 22 and copy down, like this:

=ROMAN(ROW()-22)

You can use the ROMAN function. It converts number into Roman Numerals for values from 0 to 3999. So you could do something like:

=ROMAN(1)

To count, you could enclose the COUNT function to count cells in a ROMAN function:

=ROMAN(COUNT(A2:A20))

If you want to create a column of Roman numerals without have to individually put each number in the function, you could use the ROW function. So if you are in row 1 in any column, you could put in the following formula and copy down:

=ROMAN(ROW())

If you want to start at 1, but are not in row 1, then deduct the amount needed to get to row 1. So if you were in row 23, then you would deduct 22 and copy down, like this:

=ROMAN(ROW()-22)

You can use the ROMAN function. It converts number into Roman Numerals for values from 0 to 3999. So you could do something like:

=ROMAN(1)

To count, you could enclose the COUNT function to count cells in a ROMAN function:

=ROMAN(COUNT(A2:A20))

If you want to create a column of Roman numerals without have to individually put each number in the function, you could use the ROW function. So if you are in row 1 in any column, you could put in the following formula and copy down:

=ROMAN(ROW())

If you want to start at 1, but are not in row 1, then deduct the amount needed to get to row 1. So if you were in row 23, then you would deduct 22 and copy down, like this:

=ROMAN(ROW()-22)

You can use the ROMAN function. It converts number into Roman Numerals for values from 0 to 3999. So you could do something like:

=ROMAN(1)

To count, you could enclose the COUNT function to count cells in a ROMAN function:

=ROMAN(COUNT(A2:A20))

If you want to create a column of Roman numerals without have to individually put each number in the function, you could use the ROW function. So if you are in row 1 in any column, you could put in the following formula and copy down:

=ROMAN(ROW())

If you want to start at 1, but are not in row 1, then deduct the amount needed to get to row 1. So if you were in row 23, then you would deduct 22 and copy down, like this:

=ROMAN(ROW()-22)

You can use the ROMAN function. It converts number into Roman Numerals for values from 0 to 3999. So you could do something like:

=ROMAN(1)

To count, you could enclose the COUNT function to count cells in a ROMAN function:

=ROMAN(COUNT(A2:A20))

If you want to create a column of Roman numerals without have to individually put each number in the function, you could use the ROW function. So if you are in row 1 in any column, you could put in the following formula and copy down:

=ROMAN(ROW())

If you want to start at 1, but are not in row 1, then deduct the amount needed to get to row 1. So if you were in row 23, then you would deduct 22 and copy down, like this:

=ROMAN(ROW()-22)

You can use the ROMAN function. It converts number into Roman Numerals for values from 0 to 3999. So you could do something like:

=ROMAN(1)

To count, you could enclose the COUNT function to count cells in a ROMAN function:

=ROMAN(COUNT(A2:A20))

If you want to create a column of Roman numerals without have to individually put each number in the function, you could use the ROW function. So if you are in row 1 in any column, you could put in the following formula and copy down:

=ROMAN(ROW())

If you want to start at 1, but are not in row 1, then deduct the amount needed to get to row 1. So if you were in row 23, then you would deduct 22 and copy down, like this:

=ROMAN(ROW()-22)

User Avatar

Wiki User

11y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

11y ago

You can use the ROMAN function. It converts number into Roman Numerals for values from 0 to 3999. So you could do something like:

=ROMAN(1)

To count, you could enclose the COUNT function to count cells in a ROMAN function:

=ROMAN(COUNT(A2:A20))

If you want to create a column of Roman numerals without have to individually put each number in the function, you could use the ROW function. So if you are in row 1 in any column, you could put in the following formula and copy down:

=ROMAN(ROW())

If you want to start at 1, but are not in row 1, then deduct the amount needed to get to row 1. So if you were in row 23, then you would deduct 22 and copy down, like this:

=ROMAN(ROW()-22)

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you count in Roman numerals in Excel column?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Why were Roman Numerals created?

I believe it was because Romans could not count numbers so they created roman numerals which were almost like numbers in order to tell time and count.


What is 8000000 in roman numerals?

Roman numerals were created and used to count things that were bought and sold, so is only used for smaller numbers.


What were the Roman uses for Roman numerals?

They used them to tell time, to measure farm fields, and to count stuff.


What do the Roman numeral symbolized?

Roman Numerals were the numbering system used by the ancient Romans. It is what they used to count with.


In Excel a button that inserts Excel functions to sum average or count all the values in a column or row or display the minimum or maximum value in a column or row is called the?

The Autosum button can do all of those things.


What impact did the Roman Numeral system have or has on the culture?

Roman numerals enabled the Romans to count just like any other type of numerals enable any other peoples to count.


What did Romans use Roman Numerals for?

Romans used Roman numerals as their form of numbers. Romans needed Roman Numerals because they needed numbers to count, tell time, and do other things in life that involved numbers. Roman numerals were used because they could all be scribed using a flat chisel i.e X I V M.


Why was roman numerals invented?

Because Romans needed a way to count money, items, etc.


What is the roman numerals for 76 000?

_L_X_X_VMRomans did not need to count that high.The above is a modern version with underscores added to increase their value by a thousand.L to _L 50,000X to _x 10000V to _V 5000Improved Answer:-76,000 in Roman numerals is (LXXVI) which means 1,000*76 = 76,000


Who invented the Roman numbers?

The history of Roman numerals is not well documented and written accounts are contradictory. It is likely that counting began on the fingers and that is why we count in tens


Skip count by 3s from 3 to 30 using Roman numerals?

Every third number from 3 to 30 in Roman numerals...III, VI, IX, XII, XV, XVIIII, XXI, XXIV, XXVII, XXX.


Why did the Romans invent Roman numerals?

The Romans used Roman numerals because that was their way of calculating. Roman numerals are really very simple and straightforward. For example, the I = 1, no problem there. Three I's - 3. C = 100, the Latin abbreviation for centum , M - 1000, the Latin abbreviation for mille. For us it takes a bit of figuring out, but for the Romans it was simple; if a person could count, he could read numbers.