Excel Formula: finding last value in a row and getting value next to it

[kiril98]

Hello Everyone,

I am trying to get the value of the last (left to right) "BID" and "ASK" entry in every row.
Basically I need somehow to find the last BID/ASK entry in every row and get the value next to it.
I've tried so far with INDEX, MATCH, Vlookup but without any success. Most likely I am doing something wrong or not setting up the parameters correctly.
Any help is much appreciated.

Thanks!

 

[Toadstool]

Hi Kiril98,

This should do what you ask.

Kiril98.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1	Bid	Ask	MDEntryType	MDEntryPX	MDEntryType	MDEntryPX	MDEntryType	MDEntryPX	MDEntryType	MDEntryPX	MDEntryType	MDEntryPX
2	1111		BID	1	BID	11	BID	111	BID	1111
3	11111	2222	ASK	2	ASK	22	ASK	222	ASK	2222	BID	11111
4	3333	22222	BID	3	BID	33	BID	333	BID	3333	ASK	22222
5
6	33333	4444	ASK	4	ASK	44	ASK	444	ASK	4444	BID	33333
7	555		BID	5	BID	55	BID	555
8	44444		BID	6	BID	66	BID	666	BID	5555	BID	44444
9		55555	ASK	7	ASK	77	ASK	777	ASK	6666	ASK	55555
Sheet1

Cell Formulas
Range	Formula
A2:B9	A2	=IFERROR(INDEX($C2:$L2,AGGREGATE(14,6,COLUMN($C2:$L2)-COLUMN($B$1)/($C2:$L2=A$1),1)+1),"")

 

[Dossfm0q]

sorry Toadstool But started and completed next you

ww.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1														BID	ASK
2	BID	1.1783	BID	1.17829	BID	1.17829	BID	1.17829	BID	1.17829	BID	1		1
3	BID	1.17829	BID	1.17829	BID	1.17828	BID	1.17828	BID	1.17828	ASK	2		1.17828	2
4	BID	1.17827	BID	1.17827	BID	1.17827	BID	1.17827	BID	1.17826	BID	3		3
5	BID	1.17829	BID	1.17828	BID	1.17828	BID	1.17828	BID	1.17828	BID	4		4
6	BID	1.17828	BID	1.17828	BID	1.17828	BID	1.17828	BID	1.17828	BID	5		5
7	BID	1.1783	ASK	1.17831	ASK	1.17832	ASK	1.17832						1.1783	1.17832
8	ASK	1.17831	ASK	1.17831	ASK	1.17832									1.17832
9	ASK	1.1783	ASK	1.1783	ASK	1.17831	ASK	1.17831	ASK	1.17831	ASK	8			8
10	BID	1.17831	BID	1.17829	BID	1.17829	BID	1.17829	BID	1.17829	BID	9		9
11	ASK	2.17831	ASK	1.17832	ASK	1.17832	ASK	1.17832	ASK	1.17833	ASK	10			10
12	BID	1.1783	ASK	1.17832	ASK	1.17832	ASK	1.17832	ASK	1.17832		11		1.1783	1.17832
ورقة1

Cell Formulas
Range	Formula
N2:O12	N2	=IFERROR(INDEX($A2:$L2,AGGREGATE(14,6,(COLUMN($A2:$L2)-COLUMN($A2)+1)/($A2:$L2=N$1),1)+1),"")

 

[kiril98]

Thank you both Mr. Toadstool and Mr. Dossfm0q!!!!