Excel MAX Function Tips

Using New Functions In Excel

To find the Maximum/Minimum Values Specified by a Certain Criteria

Creating a Case Sensitive VLOOKUP

Normally, the VLOOKUP function lookup function is normally not sensitive to case

How To Use Sparkline

The Sparkline in Excel is a tiny chart, which can be included within the background a cell. This is used to provide visual representation of data, showing the variations, minimum/ maximum values and data trends.

Use Cluster Values to Generate Sequence Numbers

If you are wondering if it is possible to create sequence numbers from clustered values, then you should definitely consider reading ahead to find out more

How to use MAXIFS function

MAXIFS function is considered to be one of the advanced statistical functions available in Excel.

Finding minimum, maximum and average number in a list and counting the number of cells. 

Using the MIN(), MAX(), COUNT() and AVERAGE() functions on a list