Sorry...i think its not solved.Maybe,
=MIN(C3,N(OFFSET(F3,,{1,4,7,10})))
Regards
Bosco
As per your layout, please give your expected results.Sorry...i think its not solved.
As per your layout, please review deeper file attached.
Thanks Buddy.
Regards,
Tiong999
If you have a longer table, your can use this array formula instead.I'm sorry for my bad illustration.
Actually your formula is okay...but this consume time and fragile for human error when my Table is far Larger than the example.
Please review my expected result.
Regards,
Tiong999
hello,
Im actually hard to digest formula.
May u explained us how the formula translate it (especially which in underlined pink color part)?
MIN(C3,N(OFFSET(F3,,ROW(INDIRECT("1:"&ROUNDUP((MATCH(9^9,3:3)-COLUMN(F3))/3,0)))*3-2)))
Regards,
Tiong999
Hello Bosco,
But, suppose 1 of long table range cell contain blank (example cell J3=empty)...it will return 0 instead 3 as the minimum result i expected.
And the fact many cell will contain blank cell in long run table.
How am i supposed to modified the formula?
Tiong999
To get every 3rd value position in "Table" range.Hello Bosco,
............
Btw, why must /3 as for ROUNDUP((16-6)/3,0) ??
Tiong999
=MIN(IF(CHOOSE({1,2},C3,N(OFFSET(F3,,ROW(INDIRECT("1:"&ROUNDUP((MATCH(9^9,3:3)-COLUMN(F3))/3,0)))*3-2)))>0,CHOOSE({1,2},C3,N(OFFSET(F3,,ROW(INDIRECT("1:"&ROUNDUP((MATCH(9^9,3:3)-COLUMN(F3))/3,0)))*3-2)))))
Bosco
Sorry, i just played this formula and i get N/A as result.
Will u review it. I appreciated for your contribution.
Tiong999
See attached file
Regards
Bosco
=MIN($C$3,IF(MOD(COLUMN($G$3:$P$3)-COLUMN($F$3),3)=1,IF($G$3:$P$3<>0,$G$3:$P$3)))
Press CTRL+Shift+Enter to get the answer.