| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count difference based on Range
Hi
If I have a results column of positions that something has finished, and then I have a column of a persons guesses of where the finishing positions would be. How do I calculate the difference between the persons guess for each guess and the actual result please? i.e COLUMN A B C Result Guess Place Difference Germany England 4 Wales Ireland 1 Ireland Scotland 1 Scotland Wales 2 England Germany 4 France France 0 Cheers Rich |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count difference based on Range
In C1 enter:
=ABS(MATCH(B1,A:A,0)-ROW()) and copy down -- Gary''s Student - gsnu2007 "Richhall" wrote: Hi If I have a results column of positions that something has finished, and then I have a column of a persons guesses of where the finishing positions would be. How do I calculate the difference between the persons guess for each guess and the actual result please? i.e COLUMN A B C Result Guess Place Difference Germany England 4 Wales Ireland 1 Ireland Scotland 1 Scotland Wales 2 England Germany 4 France France 0 Cheers Rich |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count difference based on Range
Cheers, was getting in a mess with LOOKUP which kept bringing back odd
values. Rich |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count cells based on value in a range | Excel Discussion (Misc queries) | |||
| Is there a way to count cells in a range based on fill color? | Excel Worksheet Functions | |||
| Count cells based on date range in another column | New Users to Excel | |||
| Count cells in one range based on parameters in another range | Excel Worksheet Functions | |||
| I have a list of dates that I need to count based on a date range | Excel Worksheet Functions | |||
Linear Mode
