Multiply Numbers Increasingly

**c a g a t a y** · 10-02-2020, 11:32 AM

I dont decide how to write title?
And ExcelForum cant allow to attach Excel file, but PNG
Please look attached PNG,

Think that ColumA have number "1" (from A1 to A640 all cells are "1")
i wanna do this;
the first 8 will be 1,
the next 8 are 2,
the next 8 are 3,
the next 8 are 4,
....
....
it will continue increasingly like this (i did it in column B manually) (yellow field)
i know it is possible by formula?

best regards

**MrShorty** · 10-02-2020, 11:38 AM

Here's how I usually do this:
1) Select B2:B8 and array enter 1 (Type 1 then press ctrl-shift-enter to enter a 1 in each cell).
2) In B9, enter the formula =B2+1. Copy/paste/fill down to B640.

Will that work?

**c a g a t a y** · 10-02-2020, 11:51 AM

why I CANT ATTACH EXCEL file?
I can attach PNG, JPG, DOC but XLSX ??
Any idea?

@MrShorty
In fact I cant understand your solution?
I am not good in Excel formula system, it is my problem

I wanna do this in column A, not B
If it is possible for you, please do it in an excell and upload/attach it

so i can see attachment problem is for me or for everyone?

kindly regards

**Pepe Le Mokko** · 10-02-2020, 11:55 AM

See the yellow banner on how to attach a file

**c a g a t a y** · 10-02-2020, 12:05 PM

* showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) -- LOL

@MrShorty
attached my sample file
i wanna do this in ColumnA

**Pepe Le Mokko** · 10-02-2020, 12:11 PM

And FYI, the Forum as a very nice FAQ which will help you out...

**Pepe Le Mokko** · 10-03-2020, 03:09 AM

Please explain the negative rep? I only pointed out that the info you requested is available on the forum

**José Augusto** · 10-03-2020, 02:59 PM

Try in B2
=QUOTIENT(ROWS($A$2:$A2),8)+1

**c a g a t a y** · 10-03-2020, 03:12 PM

Originally Posted by José Augusto

Try in B2
=QUOTIENT(ROWS($A$2:$A2),8)+1

Great job Agusto
I am appriciated to you

I tired it with 16, donnow why the first are 15 (it should be 16)

Anyway..i can correct it manually

best regards

**bebo021999** · 10-04-2020, 11:08 PM

In your manual results in #1 with counting set of 8, first set of 8 is actually 7 of 1's. (A2:A8)
If you expect 1st set is counted from row 1 (although first 1 starts from row 2): use #8 formula
If it was typo, and all set of 1 is counted from cell A2, use:

In B2:

=INT((COUNTIF($A$2:$A2,1)-1)/8)+1

Drag down.

Change 8 to 16 for next requirement of set 16.

**c a g a t a y** · 10-05-2020, 02:05 AM

Dear Bebo
Your formula returns with this error

#my sample xlsx file also attached

**bebo021999** · 10-05-2020, 02:22 AM

Here you are. 2 case 8 &16.

**c a g a t a y** · 10-05-2020, 02:29 AM

That is...
Thanks a lot Bebo...Lovely

Regards

Multiply Numbers Increasingly

LinkBack

Thread Tools

Rate This Thread

Display

Multiply Numbers Increasingly

Re: Multiply Numbers Increasingly

Re: Multiply Numbers Increasingly

Re: Multiply Numbers Increasingly

Re: Multiply Numbers Increasingly

Re: Multiply Numbers Increasingly

Re: Multiply Numbers Increasingly

Re: Multiply Numbers Increasingly

Re: Multiply Numbers Increasingly

Re: Multiply Numbers Increasingly

Re: Multiply Numbers Increasingly

Re: Multiply Numbers Increasingly

Re: Multiply Numbers Increasingly

Thread Information

Users Browsing this Thread

Similar Threads

Check if value is in increasingly bigger ranges loop

Multiply numbers from text

multiply numbers by corresponding price on given day for a large array of numbers

[SOLVED] How do I multiply numbers?

[SOLVED] macros run increasingly slowly

multiply a row of numbers by %

How do Multiply whole numbers by decimals

Bookmarks

Bookmarks

Posting Permissions