how do i calculate palindromes in Excel?

N

Niek Otten

In A1, enter the number 10.
In A2, enter the formula =A1+1. Fill down to A90.
In B1: =TEXT(A1,"00")&RIGHT(TEXT(A1,"00"),1)&LEFT(TEXT(A1,"00"),1)
Fill down.
 
G

Guest

Hi,

Use the following formula in any cell and autofill it across 10 columns and
down 9 rows (please don't exceed that range!)

=1001*ROW(A1)+110*(COLUMN(A1)-1)

OR

use the following formula in any cell, substituting "starting row#" with the
actual row number where you are entering the formula, and autofill to reach
"9999" as the result.

=(ROW()+10-starting row#)*100+MOD(ROW()+10-starting
row#,10)*10+QUOTIENT(ROW()+10-starting row#,10)

e.g., if you are entering the formula in any cell in Row 2, the formula
would be,
=(ROW()+10-2)*100+MOD(ROW()+10-2,10)*10+QUOTIENT(ROW()+10-2,10)

Regards,
B. R. Ramachandran
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Palindromes 3
Palindromes and repeats 27
palindromes 1
Macro for detect palindromes and repeats in letters/numbers string 1
Macro for detect palindromes and repeats in letters/numbers string 5
Macro for detect palindromes and repeats in letters/numbers string 3
Macro for detect and list palindromes and repeats in letters/numbersstring 3
how do i find palindromes using excel? 5

Top