Max Value in SharePoint List: Get the Highest Value from 3 Columns

SharePoint is a powerful tool for managing and organizing data. One common task is to find the maximum value in a list. In this article, we will show you how to get the highest value from three columns in a SharePoint list.

Finding the Max Value in SharePoint List

To find the maximum value in a SharePoint list, you can use the Max function. This function returns the largest value in a column. However, if you want to find the maximum value across multiple columns, you will need to use a different approach.

Get the Highest Value from 3 Columns

To get the highest value from three columns, you can use a formula that combines the values from each column and then uses the Max function to find the largest value. Here's an example:

=Max(Column1, Column2, Column3)

In this formula, Column1, Column2, and Column3 are the names of the columns that you want to include in the calculation. The Max function will return the largest value from these three columns.

Example

Let's say you have a SharePoint list with the following columns: Price1, Price2, and Price3. To find the highest price from these three columns, you can use the following formula:

=Max(Price1, Price2, Price3)

This formula will return the largest price from the three columns. For example, if Price1 is 10, Price2 is 15, and Price3 is 20, the formula will return 20.

Notes

• Make sure to replace Column1, Column2, and Column3 with the actual names of the columns in your SharePoint list.
• If a column contains text values, the Max function will return the text value that is alphabetically last. For example, if a column contains the values "Apple", "Banana", and "Carrot", the Max function will return "Carrot".
• If a column contains empty cells, the Max function will ignore these cells. For example, if a column contains the values 10, 20, and "", the Max function will return 20.

In this article, we have shown you how to get the highest value from three columns in a SharePoint list. You can use the Max function to find the largest value in a column, and you can use a formula that combines the values from multiple columns to find the largest value across all columns. This is a useful technique to know when working with SharePoint lists, and it can help you to quickly identify the highest values in your data.

References