Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default How to determine the values within table?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
If to determine lessor of three values Jo-Anne[_2_] Excel Worksheet Functions 3 September 12th 08 12:40 AM
How to determine the values? Eric Excel Discussion (Misc queries) 1 August 24th 08 11:24 AM
How to determine the values? Eric Excel Worksheet Functions 6 May 2nd 08 12:40 PM
How to determine the values from a list? Eric Excel Worksheet Functions 7 March 30th 07 06:34 AM
I need to determine how frequently two values appear together Alfie Excel Discussion (Misc queries) 2 December 21st 06 01:41 AM


All times are GMT +1. The time now is 02:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"