Enable Javascript in your browser and then refresh this page, for a much enhanced experience.
simple sum solution in Clear category for Excel Column Number by kdim
def column_number(name: str) -> int:
return sum((ord(s) - 64) * 26 ** i for i, s in enumerate(name[::-1]))
print("Example:")
print(column_number("AA"))
# These "asserts" are used for self-checking
assert column_number("A") == 1
assert column_number("Z") == 26
assert column_number("AB") == 28
assert column_number("ZY") == 701
print("The first mission is done! Click 'Check' to earn cool rewards!")
Jan. 22, 2023
Comments: