Home » Forums » Open Source Learning Center » Question and Answer

Maximum Value

Submitted by elward18690 on 19 February, 2013 - 08:36

Hi guys,

What formulas should be employed to make the highlighted cells appear automatically when the figures in column C change,constantly?
(please view the attached file)

Many thanks!

Cheers

AttachmentSize
Excel pic.JPG50.46 KB
‹ Excel coding reqd to import data file to master file Determining the make up of a net value ›
»
mahaveersomani's picture

MAXIMUM VALUE

Submitted by mahaveersomani on 19 February, 2013 - 13:11.

USE THE FOLLOWING FORMULA
=MAX(C1:C9)
=MIN(C1:C9)

»