Formula That Selects Next Cell

T

ttdk1

Board Regular

Joined

May 21, 2014

Messages

189

• May 21, 2014

• #2

like this?

if(B5=B4,0,indirect(address(row(B6),2)))

 

Upvote 0

J

jmeyer180

New Member

Joined

May 21, 2014

Messages

19

• May 21, 2014

• #3

I won't be able to plug in B6 because that is the cell we are inputing the formula in. Does that make sense?

 

Upvote 0

T

ttdk1

Board Regular

Joined

May 21, 2014

Messages

189

• May 21, 2014

• #4

Try that formula in B6. and all all cells in column 6 unless i totally miss what you wanted to do

 

Last edited: May 21, 2014

Upvote 0

J

jmeyer180

New Member

Joined

May 21, 2014

Messages

19

• May 21, 2014

• #5

ttdk1 said:

Try that formula in B6. and all all cells in column 6 unless i totally miss what you wanted to do

Click to expand...

I figured out what I did wrong originally, however the formula still didn't quite work when I tried to drag across.

Maybe this will help, this is the actually sheet I'm working on. I'm trying to find the values in column S and column T. Almost all of them here will be 0, but row 24 should show "6" in cell T24.

To explain as simply as I can, Month 1 shows the very first entry in each row. After that, I want it to show the next number, whether that number is a 0 or a higher number. If I can get T24 to be "6" then I know the formula is correct.

 

Upvote 0

T

ttdk1

Board Regular

Joined

May 21, 2014

Messages

189

• May 21, 2014

• #6

Could you show an example like the first post with column S T include and what you would like the results for S and T. A simple if then clause is fine.

 

Upvote 0

J

jmeyer180

New Member

Joined

May 21, 2014

Messages

19

• May 21, 2014

• #7

If S7=8, then T7=0. If that is true, then U7=6.

In the sense of a formula for cell T7, if(S7=Q7,0,then a formula that I can drag right O7)

	M	N	O	P	Q	R	S	T	U
1	March	April	May	June	Grand Total		Month 1	Month 2	Month 3
2	2		1		3		2
3				1	1		1
4	1			1	2		1
5				1	1		1
6				3	1		3
7		8		6	14		8
8
9

<tbody>
</tbody>

 

Upvote 0

T

ttdk1

Board Regular

Joined

May 21, 2014

Messages

189

• May 21, 2014

• #8

try that S2: =IF($P2=$Q2,0,N2)

 

Upvote 0

J

jmeyer180

New Member

Joined

May 21, 2014

Messages

19

• May 21, 2014

• #9

ttdk1 said:

try that S2: =IF($P2=$Q2,0,N2)

Click to expand...

When entering that into cell S2, I get a value of 0.

I want to keep all of the values that are already there up until the columns titled Month 2 and Month 3. Those two columns are the cells that need to be filled.

Month 1 represents the first nonblank cell in each row. I want month 2 to show the cell directly after the first nonblank cell.

 

Upvote 0

T

ttdk1

Board Regular

Joined

May 21, 2014

Messages

189

• May 21, 2014

• #10

what the formula does is compare P2 and Q2, if P2=Q2, then 0, if not then it copies over the cell to the right of M2 which is N2. But since N2 is empty, you get 0

 

Upvote 0