Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bind Columns
First post here, scanned through a few pages of the forum but didn't find the answer and didn't know what search query would answer my question. I want to have 2 columns: one with a certain set of numbers and another with letters and what I want Excel to bind them together so that I can sort them numerically or alphabetize but keep the cells that are next to each other always next to each other. That's the best way I can explain my problem and thanks for any helpful replies. -- DarkChylde ------------------------------------------------------------------------ DarkChylde's Profile: http://www.excelforum.com/member.php...o&userid=28728 View this thread: http://www.excelforum.com/showthread...hreadid=484190 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bind Columns
In the column next to the two you're using, put in the following formula and
sort based on that column. =CONCATENATE(A1,B1) "DarkChylde" wrote in message ... First post here, scanned through a few pages of the forum but didn't find the answer and didn't know what search query would answer my question. I want to have 2 columns: one with a certain set of numbers and another with letters and what I want Excel to bind them together so that I can sort them numerically or alphabetize but keep the cells that are next to each other always next to each other. That's the best way I can explain my problem and thanks for any helpful replies. -- DarkChylde ------------------------------------------------------------------------ DarkChylde's Profile: http://www.excelforum.com/member.php...o&userid=28728 View this thread: http://www.excelforum.com/showthread...hreadid=484190 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bind Columns
That's not quite what I needed it to do. If I could relate it to Photoshop, it'd be like locking layers, where I could lock 2 layers together and when I move one, both of them would move together, but could still be individually modified. I want to be able to do the same thing with certain cells. -- DarkChylde ------------------------------------------------------------------------ DarkChylde's Profile: http://www.excelforum.com/member.php...o&userid=28728 View this thread: http://www.excelforum.com/showthread...hreadid=484190 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bind Columns
Bump for reply. -- DarkChylde ------------------------------------------------------------------------ DarkChylde's Profile: http://www.excelforum.com/member.php...o&userid=28728 View this thread: http://www.excelforum.com/showthread...hreadid=484190 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bind Columns
Not much point "bumping" if you don't include the text of your origial
question. Tim. "DarkChylde" wrote in message ... Bump for reply. -- DarkChylde ------------------------------------------------------------------------ DarkChylde's Profile: http://www.excelforum.com/member.php...o&userid=28728 View this thread: http://www.excelforum.com/showthread...hreadid=484190 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bind Columns
Does "next to" mean on the same row?
If yes, then select your range (all of it!) first, then use Data|sort. Each row in the selection will be kept together. DarkChylde wrote: First post here, scanned through a few pages of the forum but didn't find the answer and didn't know what search query would answer my question. I want to have 2 columns: one with a certain set of numbers and another with letters and what I want Excel to bind them together so that I can sort them numerically or alphabetize but keep the cells that are next to each other always next to each other. That's the best way I can explain my problem and thanks for any helpful replies. -- DarkChylde ------------------------------------------------------------------------ DarkChylde's Profile: http://www.excelforum.com/member.php...o&userid=28728 View this thread: http://www.excelforum.com/showthread...hreadid=484190 -- Dave Peterson |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bind Columns
if you click on a column header, then sort the column, the rows will
stay bound... this is related: does anyone know how to alphabetize by first name in a spreadsheet that has the last name first? (YGIAGAM why my boss wants this) -felix |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bind Columns
That depends on how the data is laid out.
Me--I'd be reluctant to let excel guess at what I wanted. === For your question, I'd separate the names into multiple columns. Insert a couple to the right of the lastname/firstname column. Then select data|text to columns delimited by space This works well when the names have two components. It doesn't work very well for names like: Reginald Osgood Smythe-Jones, Esquire III. wrote: if you click on a column header, then sort the column, the rows will stay bound... this is related: does anyone know how to alphabetize by first name in a spreadsheet that has the last name first? (YGIAGAM why my boss wants this) -felix -- Dave Peterson |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bind Columns
I guess a better wording for my question using kamchatka1's scenario. I have a list with 2 columns, one with last names, and one with first names. I depending on the situation I want to sometimes sort by first name, sometimes by last name, but always keep their last name and first name next to each other. -- DarkChylde ------------------------------------------------------------------------ DarkChylde's Profile: http://www.excelforum.com/member.php...o&userid=28728 View this thread: http://www.excelforum.com/showthread...hreadid=484190 |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bind Columns
Select the entire range (all the columns that should be kept together).
Then Data|sort DarkChylde wrote: I guess a better wording for my question using kamchatka1's scenario. I have a list with 2 columns, one with last names, and one with first names. I depending on the situation I want to sometimes sort by first name, sometimes by last name, but always keep their last name and first name next to each other. -- DarkChylde ------------------------------------------------------------------------ DarkChylde's Profile: http://www.excelforum.com/member.php...o&userid=28728 View this thread: http://www.excelforum.com/showthread...hreadid=484190 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to bind filtered data in list box? | Excel Discussion (Misc queries) | |||
Bind a textbox to Access data | Excel Discussion (Misc queries) | |||
how to bind cells together | Excel Worksheet Functions | |||
How do I bind a list in Excel to a combo box on a userform | Excel Programming | |||
Bind datatable to excel worksheet | Excel Programming |