Thread: function for finding largest value from cell that are not in array

function for finding largest value from cell that are not in array

I have to find out the largest value from a line (single row and a single column where the values to be considered(each) are 4 cells apart. and the in between cells cant be included.
I am using LARGE and SMALL function but that considers only array.

+ I want to extract data that is in the adjacent cell to that
eg
a1 100000
b1 50000
c1 50 (b1% of a1)
d1 507

e1 200000
f1 50000
g1 25 (f1% of e1)
h1 500
so answer should be
i1 (larger of c1 and gi)
j1 (smaller of d1 and h1)

LARGE & SMALL both accept non-contiguous ranges as do MAX & MIN

=LARGE((C1,G1),1)

or

=MAX(C1,G1)

and

=SMALL((D1,H1),1)

or

=MIN(D1,H1)

On a final note - I removed your email address from your post - first: all correspondence should go via the board; second: you'd be spammed to oblivion