Find Value in Last Cell from specific cells

[Celticshadow]

Hi All

What formula do I need to find the last entered value in a row of cells that would be in

A1, C1, E1, G1, I1, K1, N1, P1, R1, T1.

Thanks in advance.

Kind Regards

 

[bryonwoods30]

is the value numeric or text or both?

 

[Celticshadow]

is the value numeric or text or both?

Hi Byronwoods30

The value is numeric.

Kind Regards

 

[bryonwoods30]

if the cells only contain numeric values then use the following and put your range of cells where it says range.

=INDEX(range,MATCH(9.99999999999999E+307,range))

 

[Celticshadow]

Hi Bryonwoods30

I have entered that formula using the cells mentioned in my post but I keep getting an error message (with the formula).

Kind Regards

 

[bryonwoods30]

for the range, you need to put a1:t1, listing the individual cells doesn't work.

 

[Celticshadow]

Hi Byronwoods30

I believe I have a problem as it is those specific cells I require to look at. I In between those cells is data I do not wish to look at.

Kind Regards

 

[Haseeb Avarakkan]

Hello,

Try this Array Formula, must hit Control+Shift+Enter, not just Enter.

=INDEX((A1, C1, E1, G1, I1, K1, N1, P1, R1, T1),,,MATCH(2,1/CHOOSE({1,2,3,4,5,6,7,8,9,10},A1,C1,E1,G1,I1,K1,N1,P1,R1,T1)))

 

[Celticshadow]

Hello,

Try this Array Formula, must hit Control+Shift+Enter, not just Enter.

=INDEX((A1, C1, E1, G1, I1, K1, N1, P1, R1, T1),,,MATCH(2,1/CHOOSE({1,2,3,4,5,6,7,8,9,10},A1,C1,E1,G1,I1,K1,N1,P1,R1,T1)))

Hi Haseeb Avarakkan

That works an absoloute treat, many thanks for you reply. Another problem solved, thanks very much it is really appreciated.

Kind Regards

 

[T. Valko]

Hi All

What formula do I need to find the last entered value in a row of cells that would be in

A1, C1, E1, G1, I1, K1, N1, P1, R1, T1.

Thanks in advance.

Kind Regards

Just an observation...

The cells follow a pattern of every other cell up to K1 then it skips 2 cells.

Is that the correct range or is it supposed to be evey other cell throughout the range?

If it's supposed to be every other cell:

A1, C1, E1, G1, I1, K1, M1, O1, Q1, S1

=LOOKUP(2,1/((MOD(COLUMN(A1:S1)-COLUMN(A1),2)=0)*A1:S1),A1:S1)