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

Thread Starter
Joined
Oct 5, 2016
Messages
1
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
Joined
Oct 2, 2003
Messages
65,490
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.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Top