Excel AutoFil

		Microsoft Office Forums > Microsoft Excel > Excel
Excel AutoFil

01-28-2011, 01:34 PM

ConneXionLost ConneXionLost is offline

Windows XP Excel AutoFil

Office 2003

Simulacrum

Join Date: Jan 2010

Location: Victoria, Canada

Posts: 86

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,

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel Hyperlinks crash Excel programme	martinlest	Excel	8	01-26-2011 04:23 AM
Opening multiple Excel files within the same Excel window.	lost9471	Excel	2	05-01-2010 01:57 PM
How do I use an Excel form to populate and Excel spreadsheet	apostht	Excel	0	05-21-2006 11:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:04 PM.