Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Values in a Table
I have 5 text strings in 5 cells, A2 through A6, in Sheet1. I want to select
one of them and place it in A7 based on values I have assigned in Sheet2. Sheet 1: A2 = Arenas A3 = Haywood A4 = Hughes A5 = Jamison A6 = Jeffries Sheet 2: Arenas = A Haywood = "-" Hughes = B Jamison = H Jeffries = I In Sheet2, the name that corresponds to the lowest letter (Arenas, A) is to be placed in A7 in Sheet1. The "-" value is considered to be higher than H. in other words it follows Z in the alphabet. Thanks in advance, Bob |
#2
|
|||
|
|||
Values in a Table
for just alph use DATASort
but you will find that sort puts "-' ahead of the alphs "bob" wrote: I have 5 text strings in 5 cells, A2 through A6, in Sheet1. I want to select one of them and place it in A7 based on values I have assigned in Sheet2. Sheet 1: A2 = Arenas A3 = Haywood A4 = Hughes A5 = Jamison A6 = Jeffries Sheet 2: Arenas = A Haywood = "-" Hughes = B Jamison = H Jeffries = I In Sheet2, the name that corresponds to the lowest letter (Arenas, A) is to be placed in A7 in Sheet1. The "-" value is considered to be higher than H. in other words it follows Z in the alphabet. Thanks in advance, Bob |
#3
|
|||
|
|||
Values in a Table
I need to know how to create a formula that will reference the values in
Sheet2 and display the lowest corresponding value in ascending order in Sheet1. I know what the Sort function does, but do not know how to implement it in this instance. Thanks. "Vacation's Over" wrote: for just alph use DATASort but you will find that sort puts "-' ahead of the alphs "bob" wrote: I have 5 text strings in 5 cells, A2 through A6, in Sheet1. I want to select one of them and place it in A7 based on values I have assigned in Sheet2. Sheet 1: A2 = Arenas A3 = Haywood A4 = Hughes A5 = Jamison A6 = Jeffries Sheet 2: Arenas = A Haywood = "-" Hughes = B Jamison = H Jeffries = I In Sheet2, the name that corresponds to the lowest letter (Arenas, A) is to be placed in A7 in Sheet1. The "-" value is considered to be higher than H. in other words it follows Z in the alphabet. Thanks in advance, Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Median ignoring Zero Values | Excel Worksheet Functions | |||
DonĀ“t show zero values in Pivot Table | Excel Discussion (Misc queries) | |||
changing values in a Word Table | New Users to Excel | |||
Do not show rows with no values in Pivot Table | Excel Discussion (Misc queries) | |||
table | Excel Discussion (Misc queries) |