Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Realising values from more than one cell
Hi all,
I want to create a points table, from four groups of four teams. I am trying to get a value in a cell in my points table to realise if a team has played one, two or three games. Cells in question might be C3, M7 and H13, and the team in question is A1 (Group A, Team 1 - NOT A CELL REFERENCE!). All entries might not run sequentially. If a score is entered in any one of the aforementioned cells, I want the Points table's 'played' cell (T2) to increment from 1 to 3. So, logically, if the first score is entered in C3, then (T2=1). Subsequently, when the next score is entered in M7, then (T2=2) and so on to include H13. There will only be 3 games played per team. Once someone cracks that formula for me, I think I am a long way to cracking the rest of the spreadsheet! Hope I'm on the right Excel list anyway, and thanks in anticipation! DubboPete |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Realising values from more than one cell
You could try this:
=--ISNUMBER(C3)+ISNUMBER(M7)+ISNUMBER(H13) Each function returns a 1 if you have any numbers in the appropriate cell - this assumes that the cells are blank until the points are entered. Hope this helps, and that your spreadsheet is cracked !. Pete DubboPete wrote: Hi all, I want to create a points table, from four groups of four teams. I am trying to get a value in a cell in my points table to realise if a team has played one, two or three games. Cells in question might be C3, M7 and H13, and the team in question is A1 (Group A, Team 1 - NOT A CELL REFERENCE!). All entries might not run sequentially. If a score is entered in any one of the aforementioned cells, I want the Points table's 'played' cell (T2) to increment from 1 to 3. So, logically, if the first score is entered in C3, then (T2=1). Subsequently, when the next score is entered in M7, then (T2=2) and so on to include H13. There will only be 3 games played per team. Once someone cracks that formula for me, I think I am a long way to cracking the rest of the spreadsheet! Hope I'm on the right Excel list anyway, and thanks in anticipation! DubboPete |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Realising values from more than one cell
magic Our Morris!
done the job great, especially as all the cells WILL start off blank... thanks Pete Pete Pete_UK wrote: You could try this: =--ISNUMBER(C3)+ISNUMBER(M7)+ISNUMBER(H13) Each function returns a 1 if you have any numbers in the appropriate cell - this assumes that the cells are blank until the points are entered. Hope this helps, and that your spreadsheet is cracked !. Pete DubboPete wrote: Hi all, I want to create a points table, from four groups of four teams. I am trying to get a value in a cell in my points table to realise if a team has played one, two or three games. Cells in question might be C3, M7 and H13, and the team in question is A1 (Group A, Team 1 - NOT A CELL REFERENCE!). All entries might not run sequentially. If a score is entered in any one of the aforementioned cells, I want the Points table's 'played' cell (T2) to increment from 1 to 3. So, logically, if the first score is entered in C3, then (T2=1). Subsequently, when the next score is entered in M7, then (T2=2) and so on to include H13. There will only be 3 games played per team. Once someone cracks that formula for me, I think I am a long way to cracking the rest of the spreadsheet! Hope I'm on the right Excel list anyway, and thanks in anticipation! DubboPete |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Realising values from more than one cell
Thanks for feeding back - glad it worked for you.
Pete DubboPete wrote: magic Our Morris! done the job great, especially as all the cells WILL start off blank... thanks Pete Pete Pete_UK wrote: You could try this: =--ISNUMBER(C3)+ISNUMBER(M7)+ISNUMBER(H13) Each function returns a 1 if you have any numbers in the appropriate cell - this assumes that the cells are blank until the points are entered. Hope this helps, and that your spreadsheet is cracked !. Pete DubboPete wrote: Hi all, I want to create a points table, from four groups of four teams. I am trying to get a value in a cell in my points table to realise if a team has played one, two or three games. Cells in question might be C3, M7 and H13, and the team in question is A1 (Group A, Team 1 - NOT A CELL REFERENCE!). All entries might not run sequentially. If a score is entered in any one of the aforementioned cells, I want the Points table's 'played' cell (T2) to increment from 1 to 3. So, logically, if the first score is entered in C3, then (T2=1). Subsequently, when the next score is entered in M7, then (T2=2) and so on to include H13. There will only be 3 games played per team. Once someone cracks that formula for me, I think I am a long way to cracking the rest of the spreadsheet! Hope I'm on the right Excel list anyway, and thanks in anticipation! DubboPete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA: For Count, when count changes from cell to cell | Excel Discussion (Misc queries) | |||
Cell References | Excel Discussion (Misc queries) | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions |