# Assistance with creating a range in Excel

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

#### Tanya367

Hi,

I would like assistance inserting a formula for a range into Excel 2016.

For a series of cells on my spreadsheet, I need to create a range of numbers
of the numbers appearing in any given column. In other words, the minimum
and maximum number need to appear in the destination cell.

Example #1

If the numbers in the column were:

2
3
6
1
4

I would like the formula to indicate a range of 1 - 6.

Example #2

5
5
5
5
5

I would like the formula to indicate a range of 5 - 5.

Thank you very much for your assistance. I greatly appreciate it.

Tanya

#### etaf

Wayne
Moderator
assuming the range of numbers are in cells A2 to A6

then in B2 put the following
=MIN(A2:A6)&" - "&MAX(A2:A6)

we are finding
The Minimum value
=MIN(A2:A6)
The Maximum Value
=MAX(A2:A6)

The we are using concatenate (using the & ) to join the two answers together and also put " - " in-between
=MIN(A2:A6) & " - " & MAX(A2:A6)

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

As Seen On