-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Separating data into separate cells
- Thread starter Brew
- Start date
Greg Truby
MrExcel MVP
- Joined
- Jun 19, 2002
- Messages
- 10,025
Aladin,
Thanks for letting me know that was intentional. It took some experimenting, but now I see your point. Brew - Aladin's is more robust. By taking out the "+1" and adjusting the reference inside of Column() it makes the formula susceptible to error if one inserts a column between EV and EW or if one selects the cells and drags them rightwards. Aladin's formula does not suffer the same weakness.
Thanks for letting me know that was intentional. It took some experimenting, but now I see your point. Brew - Aladin's is more robust. By taking out the "+1" and adjusting the reference inside of Column() it makes the formula susceptible to error if one inserts a column between EV and EW or if one selects the cells and drags them rightwards. Aladin's formula does not suffer the same weakness.
Upvote
0
Excel Facts
Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Similar threads
- Question
