Microsoft Office Forums - View Single Post - [Solved] Excel AutoFil

Thread: [Solved] Excel AutoFil

View Single Post

Old

01-28-2011, 01:34 PM

ConneXionLost ConneXionLost is offline

ConneXionLost is offline

ConneXionLost uses Windows XP

Windows XP ConneXionLost uses Office 2003

ConneXionLost uses Office 2003

Office 2003

Simulacrum

Join Date: Jan 2010

Location: Victoria, Canada

Posts: 86

ConneXionLost is on a distinguished road

Default

If you place the desired row number in cell E2, then these formulas will provide you with the MAX and MIN of column C:

Code:

=MAX(INDEX($C$1:INDEX($C$1:$C$10,E2),,1))

and,

Code:

=MIN(INDEX($C$1:INDEX($C$1:$C$10,E2),,1))

Cheers,

Reply With Quote