Formula That Selects Next Cell

[jmeyer180]

I'm using Excel 2011 on my Mac, and I need to find a way to make excel do the following in a large amount of data:

Put into words, if column 6 doesn't equal the total, then the input needs to be the next cell to the right. Sorry this is the best way I know how to explain it, please let me know how to fix it!

Thanks,

Joel

	1	2	3	4	5	6	7
A				Total	First nonblank entry	Formula I need to figure out
B	3		1	4	3	if(B5=B4,0,if not then the cell after B1 which is B2
C		3		3	3	Should be 0
D	3			3	3	Should be 0
E	5		1	6	5	Should be 0
F	3	2	3	8	3	Should be 2
G			1	1	1	Should be 1

<tbody>
</tbody>

 

[jmeyer180]

Haha it was very hard to understand when I was handed the project as well. I'll try putting it this way, maybe it will help:

User 7 purchases 8 items in April. This is user 7's first month. As a result, he gets an 8 in the Month 1 column. In May, he didn't buy anything. Therefore, month 2 gets a "0". In June he made 6 purchases, causing him to get a 6 in the month 3 column.

The formula Aladin gave gets rid of all empty cells. That would work, but I need to include the cells once the user starts buying from the company.

 

[jmeyer180]

What I just mentioned above is what I want to happen. Instead, I get the 8,6,0 like you said.

 

[Aladin Akyurek]

Haha it was very hard to understand when I was handed the project as well. I'll try putting it this way, maybe it will help:

User 7 purchases 8 items in April. This is user 7's first month. As a result, he gets an 8 in the Month 1 column. In May, he didn't buy anything. Therefore, month 2 gets a "0". In June he made 6 purchases, causing him to get a 6 in the month 3 column.

The formula Aladin gave gets rid of all empty cells. That would work, but I need to include the cells once the user starts buying from the company.

What I just mentioned above is what I want to happen. Instead, I get the 8,6,0 like you said.

Are you saying that the formula somehow does not satisfy? If so, in which way?

 

[ttdk1]

Gonna put a helper column in. at cell R2:=SMALL(IF(ISNUMBER(M2:P2),COLUMN(M2:P2)),1) ctrl+shift+enter and drag down as far as you need to.
in cell S2: =IF($R2+COLUMNS($S2:S2)-1>16,0,INDIRECT(ADDRESS(ROWS(S$1:S2),$R2+COLUMNS($S2:S2)-1))) drag down and to the right as far as you need to.