Hi
Welcome to the board
Try:
=MIN(IF(MOD(ROW(A1:A17),4)=1,IF(A1:A17<>0,A1:A17)))
This is an array formula, you have to confirm it with CTRL-SHIFT-ENTER.
Hi thank you, it's a great forum
but I only want some of the cells in the row to be included, not all? See the exaple below, I only want min value (exclude 0) for the cells marked with an x.
<TABLE style="WIDTH: 645pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=857><COLGROUP><COL style="WIDTH: 54pt" width=72><COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2112" width=66><COL style="WIDTH: 58pt; mso-width-source: userset; mso-width-alt: 2464" width=77><COL style="WIDTH: 48pt; mso-width-source: userset; mso-width-alt: 2048" width=64><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2368" width=74><COL style="WIDTH: 61pt; mso-width-source: userset; mso-width-alt: 2592" width=81><COL style="WIDTH: 66pt; mso-width-source: userset; mso-width-alt: 2816" width=88><COL style="WIDTH: 48pt; mso-width-source: userset; mso-width-alt: 2048" width=64><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2368" width=74><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 2752" width=86><COL style="WIDTH: 83pt; mso-width-source: userset; mso-width-alt: 3552" width=111><TBODY><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #e2e2e2; BORDER-LEFT: #e2e2e2; BACKGROUND-COLOR: transparent; WIDTH: 54pt; HEIGHT: 14.25pt; BORDER-TOP: #e2e2e2; BORDER-RIGHT: #e2e2e2" height=19 width=72></TD><TD style="BORDER-BOTTOM: #e2e2e2; BORDER-LEFT: #e2e2e2; BACKGROUND-COLOR: transparent; WIDTH: 50pt; BORDER-TOP: #e2e2e2; BORDER-RIGHT: #e2e2e2" width=66>
A</TD><TD style="BORDER-BOTTOM: #e2e2e2; BORDER-LEFT: #e2e2e2; BACKGROUND-COLOR: transparent; WIDTH: 58pt; BORDER-TOP: #e2e2e2; BORDER-RIGHT: #e2e2e2" width=77>
B</TD><TD style="BORDER-BOTTOM: #e2e2e2; BORDER-LEFT: #e2e2e2; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #e2e2e2; BORDER-RIGHT: #e2e2e2" width=64>
C</TD><TD style="BORDER-BOTTOM: #e2e2e2; BORDER-LEFT: #e2e2e2; BACKGROUND-COLOR: transparent; WIDTH: 56pt; BORDER-TOP: #e2e2e2; BORDER-RIGHT: #e2e2e2" width=74>
D</TD><TD style="BORDER-BOTTOM: #e2e2e2; BORDER-LEFT: #e2e2e2; BACKGROUND-COLOR: transparent; WIDTH: 61pt; BORDER-TOP: #e2e2e2; BORDER-RIGHT: #e2e2e2" width=81>
E</TD><TD style="BORDER-BOTTOM: #e2e2e2; BORDER-LEFT: #e2e2e2; BACKGROUND-COLOR: transparent; WIDTH: 66pt; BORDER-TOP: #e2e2e2; BORDER-RIGHT: #e2e2e2" width=88>
F</TD><TD style="BORDER-BOTTOM: #e2e2e2; BORDER-LEFT: #e2e2e2; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #e2e2e2; BORDER-RIGHT: #e2e2e2" width=64>
G</TD><TD style="BORDER-BOTTOM: #e2e2e2; BORDER-LEFT: #e2e2e2; BACKGROUND-COLOR: transparent; WIDTH: 56pt; BORDER-TOP: #e2e2e2; BORDER-RIGHT: #e2e2e2" width=74>
H</TD><TD style="BORDER-BOTTOM: #e2e2e2; BORDER-LEFT: #e2e2e2; BACKGROUND-COLOR: transparent; WIDTH: 65pt; BORDER-TOP: #e2e2e2; BORDER-RIGHT: #e2e2e2" width=86>
I</TD><TD style="BORDER-BOTTOM: #e2e2e2; BORDER-LEFT: #e2e2e2; BACKGROUND-COLOR: transparent; WIDTH: 83pt; BORDER-TOP: #e2e2e2; BORDER-RIGHT: #e2e2e2" width=111>
J</TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #e2e2e2; BORDER-LEFT: #e2e2e2; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #e2e2e2; BORDER-RIGHT: #e2e2e2" class=xl71 height=19>
1</TD><TD style="BORDER-BOTTOM: #e2e2e2; BORDER-LEFT: #e2e2e2; BACKGROUND-COLOR: #fcd5b4; WIDTH: 50pt; BORDER-TOP: #e2e2e2; BORDER-RIGHT: #e2e2e2" class=xl65 width=66>
x</TD><TD style="BORDER-BOTTOM: #e2e2e2; BORDER-LEFT: #e2e2e2; BACKGROUND-COLOR: #fac090; WIDTH: 58pt; BORDER-TOP: #e2e2e2; BORDER-RIGHT: #e2e2e2" class=xl66 width=77></TD><TD style="BORDER-BOTTOM: #e2e2e2; BORDER-LEFT: #e2e2e2; BACKGROUND-COLOR: #fcd5b4; WIDTH: 48pt; BORDER-TOP: #e2e2e2; BORDER-RIGHT: #e2e2e2" class=xl65 width=64></TD><TD style="BORDER-BOTTOM: #e2e2e2; BORDER-LEFT: #e2e2e2; BACKGROUND-COLOR: #fcd5b4; WIDTH: 56pt; BORDER-TOP: #e2e2e2; BORDER-RIGHT: #e2e2e2" class=xl65 width=74></TD><TD style="BORDER-BOTTOM: #e2e2e2; BORDER-LEFT: #e2e2e2; BACKGROUND-COLOR: #fac090; WIDTH: 61pt; BORDER-TOP: #e2e2e2; BORDER-RIGHT: #e2e2e2" class=xl66 width=81>
x</TD><TD style="BORDER-BOTTOM: #e2e2e2; BORDER-LEFT: #e2e2e2; BACKGROUND-COLOR: #fcd5b4; WIDTH: 66pt; BORDER-TOP: #e2e2e2; BORDER-RIGHT: #e2e2e2" class=xl65 width=88></TD><TD style="BORDER-BOTTOM: #e2e2e2; BORDER-LEFT: #e2e2e2; BACKGROUND-COLOR: #fac090; WIDTH: 48pt; BORDER-TOP: #e2e2e2; BORDER-RIGHT: #e2e2e2" class=xl66 width=64></TD><TD style="BORDER-BOTTOM: #e2e2e2; BORDER-LEFT: #e2e2e2; BACKGROUND-COLOR: #fac090; WIDTH: 56pt; BORDER-TOP: #e2e2e2; BORDER-RIGHT: #e2e2e2" class=xl66 width=74></TD><TD style="BORDER-BOTTOM: #e2e2e2; BORDER-LEFT: #e2e2e2; BACKGROUND-COLOR: #fcd5b4; WIDTH: 65pt; BORDER-TOP: #e2e2e2; BORDER-RIGHT: #e2e2e2" class=xl65 width=86>
x</TD><TD style="BORDER-BOTTOM: #e2e2e2; BORDER-LEFT: #e2e2e2; BACKGROUND-COLOR: #fac090; WIDTH: 83pt; BORDER-TOP: #e2e2e2; BORDER-RIGHT: #e2e2e2" class=xl66 width=111></TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #e2e2e2; BORDER-LEFT: #e2e2e2; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #e2e2e2; BORDER-RIGHT: #e2e2e2" class=xl71 height=19>
2</TD><TD style="BORDER-BOTTOM: #e2e2e2; BORDER-LEFT: #e2e2e2; BACKGROUND-COLOR: transparent; BORDER-TOP: #e2e2e2; BORDER-RIGHT: #e2e2e2" class=xl67>
0</TD><TD style="BORDER-BOTTOM: #e2e2e2; BORDER-LEFT: #e2e2e2; BACKGROUND-COLOR: transparent; WIDTH: 58pt; BORDER-TOP: #e2e2e2; BORDER-RIGHT: #e2e2e2" class=xl68 width=77>
836400</TD><TD style="BORDER-BOTTOM: #e2e2e2; BORDER-LEFT: #e2e2e2; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #e2e2e2; BORDER-RIGHT: #e2e2e2" class=xl68 width=64>
1234</TD><TD style="BORDER-BOTTOM: #e2e2e2; BORDER-LEFT: #e2e2e2; BACKGROUND-COLOR: transparent; BORDER-TOP: #e2e2e2; BORDER-RIGHT: #e2e2e2" class=xl67>
80100</TD><TD style="BORDER-BOTTOM: #e2e2e2; BORDER-LEFT: #e2e2e2; BACKGROUND-COLOR: transparent; WIDTH: 61pt; BORDER-TOP: #e2e2e2; BORDER-RIGHT: #e2e2e2" class=xl69 width=81>
192240</TD><TD style="BORDER-BOTTOM: #e2e2e2; BORDER-LEFT: #e2e2e2; BACKGROUND-COLOR: transparent; WIDTH: 66pt; BORDER-TOP: #e2e2e2; BORDER-RIGHT: #e2e2e2" class=xl68 width=88>
1153440</TD><TD style="BORDER-BOTTOM: #e2e2e2; BORDER-LEFT: #e2e2e2; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #e2e2e2; BORDER-RIGHT: #e2e2e2" class=xl70 width=64>
1324</TD><TD style="BORDER-BOTTOM: #e2e2e2; BORDER-LEFT: #e2e2e2; BACKGROUND-COLOR: transparent; WIDTH: 56pt; BORDER-TOP: #e2e2e2; BORDER-RIGHT: #e2e2e2" class=xl70 width=74>
81300</TD><TD style="BORDER-BOTTOM: #e2e2e2; BORDER-LEFT: #e2e2e2; BACKGROUND-COLOR: transparent; BORDER-TOP: #e2e2e2; BORDER-RIGHT: #e2e2e2" class=xl67>
178209,6</TD><TD style="BORDER-BOTTOM: #e2e2e2; BORDER-LEFT: #e2e2e2; BACKGROUND-COLOR: transparent; WIDTH: 83pt; BORDER-TOP: #e2e2e2; BORDER-RIGHT: #e2e2e2" class=xl68 width=111>
1153809,6</TD></TR></TBODY></TABLE>