can this be solved with excel?

[r_ivica]

I have this excel table:

Excel Workbook
	A	K	M	O	Q	S	U	Y	AB	AD	AF	AG	AH	AI	AJ	AK	BO	BP
1	StartTime	Ari A	Bro A	Cal A	Dor A	Eli A	Fis A	MAIN A	Game	MAIN B	Fis B	Eli B	Dor B	Cal B	Bro B	Ari B	PlayerA	PlayerB
2	23.2.10. 19:45	*	*	2,25	*	*	*	2,46	Basingstoke v Eastleigh : Match Odds	3,45	*	*	*	2,65	*	*	Basingstoke	Eastleigh
3	24.2.10. 17:00	*	1,40	*	1,35	*	1,40	1,38	Benfica v H Berlin : Match Odds	12,5	5,70	*	7,90	*	5,70	*	Benfica	H Berlin
4	19.2.10. 19:45	2,60	2,00	2,10	2,00	2,10	2,10	2,4	Aldershot v Dag and Red : Match Odds	3,55	2,90	3,00	3,30	3,10	3,10	3,00	Aldershot	Dag and Red
5	23.2.10. 19:45	1,65	1,65	1,65	1,70	1,65	1,65	2,04	Bournemouth v Barnet : Match Odds	4,8	4,10	4,65	4,25	4,50	4,10	4,10	Bournemouth	Barnet
6	23.2.10. 19:45	1,70	1,65	1,73	1,70	1,75	1,70	1,88	Bury v Morecambe : Match Odds	5,1	3,95	4,20	4,25	4,30	4,10	3,95	Bury	Morecambe
7	21.2.10. 19:45	1,60	1,60	1,60	1,55	1,65	1,60	1,78	Charlton v Brighton : Match Odds	5,8	4,25	4,40	5,55	5,00	4,25	4,25	Charlton	Brighton
8	21.2.10. 19:45	2,25	2,20	2,30	2,20	2,30	2,25	2,74	Cheltenham v Torquay : Match Odds	3,05	2,70	2,85	2,91	2,80	2,80	2,70	Cheltenham	Torquay
9	20.2.10. 19:45	2,40	2,40	2,50	2,40	2,40	2,40	2,7	Doncaster v Leicester : Match Odds Unmanaged	3,05	2,60	2,75	2,62	2,70	2,60	2,60	Doncaster	Leicester
10	20.2.10. 19:45	1,90	1,85	1,90	1,90	1,90	1,90	2,06	Dungannon Swifts v Ballymena : Match Odds	4,3	3,20	3,55	3,55	3,40	3,45	3,40	Dungannon Swifts	Ballymena
11	23.2.10. 19:45	2,45	2,40	2,45	2,40	2,40	2,30	2,42	Exeter v Bristol Rovers : Match Odds	3,45	2,65	2,70	2,62	2,65	2,60	2,55	Exeter	Bristol Rovers
12	23.2.10. 19:45	*	*	1,85	*	*	*	2	Gainsborough v Vauxhall Motors : Match Odds	4,4	*	*	*	3,45	*	*	Gainsborough	Vauxhall Motors
13	23.2.10. 19:45	2,55	2,60	2,55	2,62	2,60	2,55	3,05	Gateshead v Altrincham : Match Odds	2,74	2,45	2,40	2,40	2,50	2,40	2,45	Gateshead	Altrincham
14	19.2.10. 19:45	2,05	2,05	*	2,05	*	2,05	2,38	Gillingham v L Orient : Match Odds	3,7	3,00	*	3,22	*	3,00	3,00	Gillingham	L Orient
15	24.2.10. 19:45	2,35	2,20	2,25	2,15	2,15	2,15	2,3	Grimsby v Macclesfield : Match Odds	3	2,80	3,10	3,10	2,85	2,80	3,00	Grimsby	Macclesfield
16	18.2.10. 19:45	2,50	2,40	2,50	2,40	2,40	2,40	2,6	Hartlepool v Carlisle : Match Odds	3,1	2,60	2,70	2,62	2,60	2,60	2,50	Hartlepool	Carlisle
17	23.2.10. 19:45	2,40	2,40	2,50	2,45	2,40	2,40	2,76	Hereford v Northampton : Match Odds	2,94	2,60	2,70	2,56	2,60	2,60	2,60	Hereford	Northampton
18	24.2.10. 0:50	1,25	1,20	1,22	1,20	1,20	1,25	1,28	Internacional v Emelec : Match Odds	15,5	8,10	10,00	10,00	10,00	8,70	8,10	Internacional	Emelec
19	23.2.10. 19:45	1,50	1,45	1,50	1,45	1,45	1,50	1,52	Leeds v Oldham : Match Odds	8,6	4,80	6,50	6,20	6,00	5,20	4,80	Leeds	Oldham
20	20.2.10. 19:45	1,65	1,75	1,75	1,80	1,80	1,65	2,02	Cliftonville v Coleraine : Match Odds	4,8	4,30	3,95	3,90	4,00	3,85	4,10	Cliftonville	Coleraine
21	23.2.10. 19:45	1,70	1,60	1,70	1,65	1,70	1,65	1,83	Colchester v Brentford : Match Odds	5,8	4,10	4,40	4,95	4,30	4,25	3,95	Colchester	Brentford
22	23.2.10. 19:45	2,50	2,45	2,50	2,45	2,45	2,45	2,68	Crewe v Chesterfield : Match Odds	2,96	2,55	2,55	2,56	2,60	2,55	2,50	Crewe	Chesterfield
ref0

what i need to get here is to have 3 games multiplied from one house but some conditions to be true,
Conditions:

-the games need to be sorted by date and time accordingly. So, first game must start at least 2 hours before second game starts, and third game must start at least 2 hours after second game starts (example: 19.2.10. 19:45 / 19.2.10. 21:45 / 20.2.10. 01:00 should be true, but example 19.2.10. 19:45 / 19.2.10. 20:45 / 20.2.10. 01:00 should be false)

- product of 3 different games (which can be A or B) from house numbers of same house must be by 1% higher than product of 3 numbers from same game according to MAIN numbers
Example: we look house "Ari" and having games "Aldershot v Dag and Red" which starts at 19.2.10. 19:45 which we see in 4th row,
second game is "Exeter v Bristol Rovers" which starts at 23.2.10. 19:45 which we see in 11th row
third game is "Grimsby v Macclesfield" which starts at 24.2.10. 19:45 which we see in 15th row
So, first 'times condition' is true and product result of house numbers K4*K11*K15 = 14,97
and product of MAIN numbers for this same 3 games are Y4*Y11*Y15 = 13,36
so difference is 1,61 which is even 12% higher than MAIN product number of this 3 numbers of same game.

so result in some new cell should look like this:
Ari A Aldershot 2,60 Exeter 2,45 Grimsby 2,35 14,97 13,36 1,61

Notice: this all 3 players are playersA, this is for easiest example, it doesn't have to be all A or B, the result could be easy like this:
Ari A Aldershot 2,60 Exeter 2,45 Macclesfield 3,00 19,11 17,424 1,686

so actually need to get all this combination's out as result which have this conditions positive. Negatives need to be ignored

so excel guru's , please advise me please about this situation!
Thanks

 

[r_ivica]

looks like no one can help

let's try step by step.
can we solve this problem?
the games need to be sorted by date and time accordingly. So, first game must start at least 2 hours before second game starts, and third game must start at least 2 hours after second game starts (example: 19.2.10. 19:45 / 19.2.10. 21:45 / 20.2.10. 01:00 should be true, but example 19.2.10. 19:45 / 19.2.10. 20:45 / 20.2.10. 01:00 should be false)