Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Does anyone have any suggestions on how to determine the values within table?
The range of table is from C10 to AU54, there is a list of numbers within this table Starting from C10 is 1, D10 is 56, ... AU10 is 1981 C11 is 2, D11 is 57, ... AU11 is 1982 C12 is 3, D12 is 58, ... AU12 is 1983 .... C54 is 45, D54 is 90, ... AU54 is 2025 There is a given value in BB1, which is 197 in cell G26, and I would like to determine a list of numbers in diagonal location in BC1 column, for example, On the left top diagonal angle, 151, 105, 59, 13 On the right top diagonal angle, 241, 285m 329, 373, 417, 461, 505, 549, 593, 637, 681, 725, 769, 813, 857, 901 On the left bottom diagonal angle, 153, 109, 65, 21 On the right bottom diagonal angle, 243, 289, 335, 381, 427, 473, 518, 564, 610, 656, 702, 748, 794, 840, 886, 932, 979, 1025, , 1071, 1117, 1163, 1209, 1255, 1301, 1347, 1393, 1439, 1485 Would it be able to do it in Excel? Does anyone have have any suggestions? Thanks in advance for any suggestions Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If to determine lessor of three values | Excel Worksheet Functions | |||
How to determine the values? | Excel Discussion (Misc queries) | |||
How to determine the values? | Excel Worksheet Functions | |||
How to determine the values from a list? | Excel Worksheet Functions | |||
I need to determine how frequently two values appear together | Excel Discussion (Misc queries) |