Previous Xup number .

[Sunline]

Hello all ,

I am needing to get a macro that gives me the results I have in cols
BJ and BK . I tri
I have entered 2 x new dates in col B hilited in yellow .
I know horse Magic is xup 5 today col BI . Cell B17
I know horse Tavistock is xup 2 today col BI. Cell B25

Just need to look back for exact same xup number (hilited in brown) and
put results into cols BJ:BK

If previous xup number doesn’t exist , leave blank .

Looking for any ideas .
Thanks .

Excel Workbook
	B	AH	AI	AJ	AL	AO	BI	BJ	BK
1	Date	HorseName	Age	Gender	Finishingposition	Decimalmargin	Xup	Pl	Mg
2	6/05/2016	Magic (AUS)	3	g	8	10.5	1
3	1/06/2016	Magic (AUS)	3	g	9	19.6	2
4	8/12/2016	Magic (AUS)	4	g	5	3.2	1
5	24/12/2016	Magic (AUS)	4	g	4	5.1	2
6	14/01/2017	Magic (AUS)	4	g	11	6.3	3
7	22/01/2017	Magic (AUS)	4	g	6	4.1	4
8	9/02/2017	Magic (AUS)	4	g	6	3.7	5
9	8/03/2017	Magic (AUS)	4	g	4	4.6	6
10	24/03/2017	Magic (AUS)	4	g	1	1	7
11	1/04/2017	Magic (AUS)	4	g	1	0.2	8
12	15/04/2017	Magic (AUS)	4	g	4	4.8	9
13	22/09/2017	Magic (AUS)	5	g	8	5.2	1
14	6/10/2017	Magic (AUS)	5	g	4	1.1	2
15	28/10/2017	Magic (AUS)	5	g	5	2	3
16	11/11/2017	Magic (AUS)	5	g	1	1.8	4
17	9/12/2017	Magic (AUS)	5	g			5	6	3.7
18	22/03/2017	Tavistock	3	f	2	1.3	1
19	9/04/2017	Tavistock	3	f	3	0.7	2
20	25/04/2017	Tavistock	3	f	14	5	3
21	17/05/2017	Tavistock	3	f	1	2.3	4
22	17/06/2017	Tavistock	3	f	4	1.8	5
23	8/07/2017	Tavistock	3	f	9	4.2	6
24	17/11/2017	Tavistock	4	m	1	1.3	1
25	9/12/2017	Tavistock	4	m			2	3	0.7
Sheet1

 

[Sunline]

Find last value of same enter result .

Hello all ,

Here I have 3 x different horses .
Needing to find last cell entry in col BI for each horse , then looking back until same
number is found in col BI .

Then look left to cols AL and AO and result into cols BJ , BK .

Example , Farbaric last entry col BI is 3 in cell BI26 .
Previous 3 mentioned is in cell BI22 .
Results same as cells BJ26:BK26 .

Hopefully macro will work as I have over 440,000 rows .

Thanks .

Excel Workbook
	AH	AL	AO	BI	BJ	BK
1	HorseName	Finishingposition	Decimalmargin	Xup	Pl	Mg
2	Bahhare Babe	11	9.2	1
3	Bahhare Babe	2	3	1	11	9.2
4	Bahhare Babe	9	6.7	1	2	3
5	Bahhare Babe	4	1.3	2
6	Bahhare Babe	12	10.3	3
7	Bahhare Babe	13	10.2	1	9	6.7
8	Bahhare Babe	5	1.4	2	4	1.3
9	Bahhare Babe	F	F	1	13	10.2
10	Sarbara Ann	2	0.5	1
11	Sarbara Ann	1	0.4	2
12	Sarbara Ann	3	6.2	3
13	Sarbara Ann	8	2.4	1	2	0.5
14	Sarbara Ann	4	2.6	2	1	0.4
15	Sarbara Ann	4	1.9	1	8	2.4
16	Sarbara Ann	5	1.8	1	4	1.9
17	Sarbara Ann	RO	RO	2	4	2.6
18	Sarbara Ann	1	0.1	3	3	6.2
19	Farbaric	10	17	1
20	Farbaric	1	3.8	1	10	17
21	Farbaric	2	0.5	2
22	Farbaric	2	0.3	3
23	Farbaric	6	1.7	4
24	Farbaric	1	1.7	1	1	3.8
25	Farbaric	4	4.1	2	2	0.5
26	Farbaric	1	0.1	3	2	0.3
Sheet1

 

[Sunline]

Re: Find last value of same enter result .

I have managed to find a post by Aladin Akyurek Re: Return last value
where by pure luck I changed this function to suit my results .

=IFERROR(LOOKUP(9.99999999999999E+307,1/($BI$1:BI1=$BI2),$AL$1:AL1),"")
=IFERROR(LOOKUP(9.99999999999999E+307,1/($BI$1:BI1=$BI2),$AO$1:AO1),"")

If I could just get this function to acknowledge only one horse and not put false data in
relating to another as in cells BL10:BM12 , BL19:BM19
and BL21:BM22 .

A macro of this would be the ultimate solution . I will plod on .

Thanks .

 

[Macropod]

Re: Find last value of same enter result .

Sunline: As per Rule 12 (http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html), please don't ask the same question in multiple threads. I have merged them.

 

[Sunline]

Re: Find last value of same enter result .

Ok sorry for that when can i start a new thread as no body will attempt to answer this now .
Thanks .

 

[Joe4]

Re: Find last value of same enter result .

Ok sorry for that when can i start a new thread as no body will attempt to answer this now .

Why not?

If you do not receive a response, you can simply "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.

 

[Sunline]

Re: Find last value of same enter result .

bump , thanks .