how do i calculate palindromes in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
Back
Top