Modify an IFERROR INDEX array function to LINK a cell to ROW reference

**XOR LX** · 01-27-2015, 07:06 AM

Apologies, but no - I don't understand.

Perhaps this is a case where, instead of attempting to explain how you would like your existing formulas to be modified, you actually gave details of precisely what you are trying to achieve. It may be that a solution which is completely different to your current set-up is available.

Either way, it's often easier to derive one's own solutions than to untangle those of someone else.

Regards

**paulmacro** · 01-27-2015, 07:53 AM

XOR LX,

Sorry you don't understand, I try my best to keep it simple but its not easy for me.
We really tried to be precise with the "Requirement", see below and on workbook and with the best so far ideas = a macro to replace ROW(A1)in the function with contents of cell F.
We don't mind a completely different function but of course we adhere to the forum rules the best we can in how we go about it.

Requirement: the start and end values in column I index of the three variable values in G1 G2 & G3 by position via column H, large & small
G1 = Maximum
G2 = Minimum other than 0
G3 = independent value between G1 & G2 that is not 0
Column H length can vary H1:H60000, generally ascending or 0 (from an IF origin)
The total count of values other than 0 see in F4 can also vary

Thanks again for your comments

Kind Regards

Paul

**XOR LX** · 01-27-2015, 08:09 AM

Originally Posted by paulmacro

Requirement: the start and end values in column I index of the three variable values in G1 G2 & G3 by position via column H, large & small
G1 = Maximum
G2 = Minimum other than 0
G3 = independent value between G1 & G2 that is not 0
Column H length can vary H1:H60000, generally ascending or 0 (from an IF origin)
The total count of values other than 0 see in F4 can also vary

I'm very sorry but that appears to be precisely the same text as that entered in the workbook, which I've already read several times and, unfortunately, still can't understand.

Hopefully someone else who can work out your requirements will pick up on this thread shortly.

Regards