How to do inverse database?

[RedSonia]

Hello, Hi!
I want to do database with 0. I want to put 20 "0" after every 200 numbers. And i want too the numbers are decreasing, from largest to smallest.
See file to understand what i want to do (black text in file).
I have a formula but i don't know how to put decreasing numbers (red text in file).
Sorry for my english.
I doesn't use Excel but this time i need it for special numerotation.

Thanks!

 

[Hui]

RedSonia

Firstly, welcome to the Chandoo.org Forums

In C2: 41215499
In C3: =IF(AND(MOD(ROW()-2,220)>=200,MOD(ROW()-2,220)<=219,ROW()>20),"00000000",MIN(IF($C$2:C2<>0,$C$2:C2))-1) Ctrl+Shift+Enter
Copy C3 Down

See attached file:

 

[RedSonia]

Thanks Hui! Thanks for file. When i try to copy down, it doesn't work. Maybe i use Apple computer?
Excel formula is a art! I am impressed and i really don't understand where you take all numbers and symbols! I try to dissect the formula I are really not. Wow!

 

[Hui]

You enter the formula into C3: =IF(AND(MOD(ROW()-2,220)>=200,MOD(ROW()-2,220)<=219,ROW()>20),"00000000",MIN(IF($C$2:C2<>0,$C$2:C2))-1)
Press Ctrl+Shift+Enter not Enter
Copy C3 with Ctrl+C
Select C4:C1000 (or your last cell)
Ctrl+V

I think Apples use a different key for Ctrl but the actions are the same

Or you may be able to Click the Bottom Right Black handle of C3 then drag it down

You can't Double Click the Bottom Right Black handle of C3

Let us know what works

 

[RedSonia]

The formula works, but not when I drag it down. 00000000 work after every 200 numbers, but where there are 200 numbers that writes #VALUE!

Thank you again for your help
And sorry for my english

 

[Hui]

Update:

Excel's Array formulas are entered with Command+Return on the Mac

So you enter the formula into C3: =IF(AND(MOD(ROW()-2,220)>=200,MOD(ROW()-2,220)<=219,ROW()>20),"00000000",MIN(IF($C$2:C2<>0,$C$2:C2))-1) Command+Return

Then copy and paste this down