G
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Pete_UK
And your question is ???
Pete
Pete
P
Peo Sjoblom
http://en.wikipedia.org/wiki/Roman_numerals
Nothing built in and unless somebody has built anything in Excel that will
do this I'd suggest you roll your own
--
Regards,
Peo Sjoblom
Nothing built in and unless somebody has built anything in Excel that will
do this I'd suggest you roll your own
--
Regards,
Peo Sjoblom
L
Lori
=MATCH(A1,ROMAN(ROW($1:$3999)),0)
ctrl+shift+entered with Tools > Addins: Analysis toolpak checked.
ctrl+shift+entered with Tools > Addins: Analysis toolpak checked.
A
Ashley
you rock if ihadnt read this i woulndnt no how to do
this!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
this!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
J
JanV
Hi all,
Why this is not working when reffering other than A1 cell (row 3) ?
=MATCH(A3,ROMAN(ROW($3:$3999)),0) - does not work??
Thanks for hints,
Jan
Why this is not working when reffering other than A1 cell (row 3) ?
=MATCH(A3,ROMAN(ROW($3:$3999)),0) - does not work??
Thanks for hints,
Jan
J
JanV
I'm sorry. it works well. just I left a space at the end of roman number in
cell,
Bye,
J.
cell,
Bye,
J.
R
Ron Rosenfeld
Hi all,
Why this is not working when reffering other than A1 cell (row 3) ?
=MATCH(A3,ROMAN(ROW($3:$3999)),0) - does not work??
Thanks for hints,
Jan
What does "does not work" mean?
Excel crashes?
Error message? If so, what is the message.
Wrong result? If so, what is your input and output.
What you posted shows $3:$3999 for the array which is incorrect and not the
same as the original and, even if everything else were correct, would give an
incorrect answer.
This is something that can change if you insert rows. If that is the issue,
then:
=MATCH(A1,ROMAN(ROW(INDIRECT("1:3999"))),0)
entered as an array formula by holding down <ctrl><shift> while hitting <enter>
will allow row insertion without changing the references.
Maybe you didn't enter the formula as an array formula.
Maybe the contents of A1 is not a roman numeral in the proper format.
--ron