I have an Excel file containing two sheets:
- `Teams` (which contains details of teams and time schedule of their matches)
- `Results` (contains calculation and number of matches and results, etc).
What`Results`did is that each game that has launched status on `Teams` it gets on `Results` sheet and then`Results`input the number and calculation on that sheet.
My problem is that when there is a game inside two started games, when it starts the new name comes and shifts the name row below it and keeps the details of the row below it for itself, while it should be to next of it, here is my example:
**`Sheet1` `Teams`**
-
A B
1 **Names** **Status**
2 TEAM A Launched
3 TEAM B Pending
4 TEAM C Pending
5 TEAM D Launched
**2 `Results`**
-
A B C D E
1 **Names** **1st Half goals** **2nd half** **total** **points**
2 TEAM A 1 2 3 13
3 TEAM D 3 1 4 10
So what happens here is that if change the status of TEAM B on `Sheet1` of `Teams` it will be appear on 2 `Results` and it will take the row input of TEAM D.
It will be like this:
**2 `Results`**
-
A B C D E
1 **Names** **1st Half goals** **2nd half** **total** **points**
2 TEAM A 1 2 3 13
3 TEAM B 3 1 4 10
4 TEAM D
Is there any solution to keep entire row moving together? please let me know.
This is the formula on `Sheet 2 Results` Cell `A2`
`=IFERROR(INDEX(TEAMS!A$2:A$550,SMALL(IF(TEAMS!B$2:B$550="Launched",ROW(TEAMS!B$2:B$550)-ROW(TEAMS!B$1)),ROW(TEAMS!B2))),"")`
and `Cell B & C & E` there is no formula only manual input, and for `Cell D` `=SUM(C2,B2)`
- `Teams` (which contains details of teams and time schedule of their matches)
- `Results` (contains calculation and number of matches and results, etc).
What`Results`did is that each game that has launched status on `Teams` it gets on `Results` sheet and then`Results`input the number and calculation on that sheet.
My problem is that when there is a game inside two started games, when it starts the new name comes and shifts the name row below it and keeps the details of the row below it for itself, while it should be to next of it, here is my example:
**`Sheet1` `Teams`**
-
A B
1 **Names** **Status**
2 TEAM A Launched
3 TEAM B Pending
4 TEAM C Pending
5 TEAM D Launched
**2 `Results`**
-
A B C D E
1 **Names** **1st Half goals** **2nd half** **total** **points**
2 TEAM A 1 2 3 13
3 TEAM D 3 1 4 10
So what happens here is that if change the status of TEAM B on `Sheet1` of `Teams` it will be appear on 2 `Results` and it will take the row input of TEAM D.
It will be like this:
**2 `Results`**
-
A B C D E
1 **Names** **1st Half goals** **2nd half** **total** **points**
2 TEAM A 1 2 3 13
3 TEAM B 3 1 4 10
4 TEAM D
Is there any solution to keep entire row moving together? please let me know.
This is the formula on `Sheet 2 Results` Cell `A2`
`=IFERROR(INDEX(TEAMS!A$2:A$550,SMALL(IF(TEAMS!B$2:B$550="Launched",ROW(TEAMS!B$2:B$550)-ROW(TEAMS!B$1)),ROW(TEAMS!B2))),"")`
and `Cell B & C & E` there is no formula only manual input, and for `Cell D` `=SUM(C2,B2)`
Last edited by a moderator: