Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Fri, 07 Feb 2025 01:16:38 +0000

How to Post a Message for Support

Post From: Spreadsheet programming question

[2020-05-13 00:43:58]
[Go To First Post]
User183724 - Posts: 191
just a quick follow up - i found the following works pretty solid and it supports relative column reference and absolute row reference to Study Subgraph

=MIN(INDEX(BU3:BU1002, any supported variable type ,1):INDEX(BU3:BU1002, any supported variable type ,1))


where a calculated MIN (MAX etc) is desired.

INDEX(BU3:BU1002, any variable type ,1) establishes the column the data will be obtained from and the variable can be direct or indirect...

examples

=MIN(INDEX(BU3:BU1002, any supported variable type ,1):INDEX(BU3:BU1002, any supported variable type ,1))

with data coming from column BR3 and BR12

=MIN(INDEX(BU3:BU1002, BR3 ,1):INDEX(BU3:BU1002, BR12 ,1))

or

=MIN(INDEX(ID2.SG1@3:ID2.SG1@1002, BR3 ,1):INDEX(ID2.SG1@3:ID2.SG1@1002, BR12 ,1))

something a little more complex

=MIN(INDEX(BU3:BU1002, ((BS3-BJ3)+1),1):INDEX(BU3:BU1002, ((BS3-BJ12)+1),1))

thx again tim