rrtts
10-25-2006, 07:03 PM
Anybody else have this problem...seems like there are hundreds of ways for Excel to achieve the desired results...and it never fails, once I get help or figure out how to do something...I think of a different way I should've done it.
Okay...here's my real problem.
Lets say I have the following data - each entry in a single cell.
GeoLoc1/Unit Name1
GeoLoc2/Unit Name2
Now, lets say GeoLoc1 = UK and GeoLoc2 = USA.
I'm trying to get these results - in two cells.
Unit Name1 | UK
Unit Name2 | USA
There will be about 30 to 40 individual Unit Names and almost as many GeoLoc...although the Unit Names may share GeoLoc names...
So
GeoLoc1/Unit Name1
GeoLoc2/Unit Name2
GeoLoc1/Unit Name3
GeoLoc1/Unit Name4
GeoLoc2/Unit Name5
GeoLoc2/Unit Name6
would be
Unit Name1 | UK
Unit Name2 | USA
Unit Name3 | UK
Unit Name4 | UK
Unit Name5 | USA
Unit Name6 | USA
Hope that makes sense...
Okay...here's my real problem.
Lets say I have the following data - each entry in a single cell.
GeoLoc1/Unit Name1
GeoLoc2/Unit Name2
Now, lets say GeoLoc1 = UK and GeoLoc2 = USA.
I'm trying to get these results - in two cells.
Unit Name1 | UK
Unit Name2 | USA
There will be about 30 to 40 individual Unit Names and almost as many GeoLoc...although the Unit Names may share GeoLoc names...
So
GeoLoc1/Unit Name1
GeoLoc2/Unit Name2
GeoLoc1/Unit Name3
GeoLoc1/Unit Name4
GeoLoc2/Unit Name5
GeoLoc2/Unit Name6
would be
Unit Name1 | UK
Unit Name2 | USA
Unit Name3 | UK
Unit Name4 | UK
Unit Name5 | USA
Unit Name6 | USA
Hope that makes sense...