Need Help with Formula

  • Thread starter Thread starter WandaGM
  • Start date Start date
W

WandaGM

I need help trying to come up with a formula for a friend
of mine. This is what he wants -- Using any 9 numbers --
he wants Excel to come up with every possible 3-digit
combination of numbers that are divisible by 7.

Is there anyone who could assist me with a formula that
will perform this calculation? Can Excel do such a
calculation?

Thanks so much for any assistance you can offer.
 
In A1, enter the number 7.
Select A1:A142.
Edit>Fill>Series, Step value 7. Format>Cells>Custom, "000".
If with "using any 9 numbers" you mean you don't want any zeros, enter this
formula in B1:
=IF(ISERROR(FIND(0,TEXT(A1,"000"))),A1,"") and fill down to B142

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Back
Top