Reply to thread

Message: [QUOTE="Mike H, post: 3251305"] Danelle, I've been trying to get my head around how may combinations this is but it is so many Excel can't calculate it or at least i can't come up with a formula. having said that here's the formula you posted modified for all combinations of 0 - 9 =MOD(INT((ROW(A2)-1)/9765625),5)&MOD(INT((ROW(A2)-1)/1953125),5)&MOD(INT((ROW(A2)-1)/390625),5)&MOD(INT((ROW(A2)-1)/78125),5)&MOD(INT((ROW(A2)-1)/15625),5)&MOD(INT((ROW(A2)-1)/3125),5)&MOD(INT((ROW(A2)-1)/625),5)&MOD(INT((ROW(A2)-1)/125),5)&MOD(INT((ROW(A2)-1)/25),5)&MOD(INT((ROW(A2)-1)/5),5)&MOD(ROW(A2)-1,5) BTW I ran out of rows in Excel 2007 and was nowhere near the end Mike [/QUOTE]