T
Tom Moffatt
My question is
How would I go about making a worksheet that I have to find the common
traits of a cell, match it to a another cell, and put it in the same row.
Alphabetically from left to right. I dont want to erase what was already
occupying that cell. I am trying to categorize by column what each item is
missing basically.
To better understand my worksheet is set up like so (items all mixed up)
VENDOR | DIAGRAMS | CONTROL | RACK |DETAILS
AMX |AMX_MAX-2000| AMX -1000 |AMX-NXA-AVB|AMX - AC-RK
AMX - NI-4000 | AMX MAX -2000| AMX 50BG |AMX_Z90
To Turn to this
VENDOR | DIAGRAMS | CONTROL | RACK | DETAILS
AMX | | AMX -1000 | |
| | | AMX_50BG |
| | |
|AMX - AC-RK
|AMX_MAX-2000| AMX MAX -2000 | |
AMX - NI-4000 | | |
| |AMX_NXA-AVB|
|
| AMX - Z90
Alphabetically by row and column.
Basically its like a treeview(i think) only more complicated.
***1. The formating is different a lot of the time so it would be best to
compare sections of a cell, like a section of all consistent characters
(letters, numbers etc) and compare to the other cells in the row, then the
next set of consistent characters get compared etc.
(Maybe also a way to disregard certain characters like spaces, _ , -,+)???
2. If cell is empty then check the next cell. Keep matching items in the
same row (DONT CHANGE COLUMNS!). EACH DIFFERNT ITEM HAS ITS OWN ROW. I am
trying to categorize by column what each item is missing basically.
3.Organize the columns by empty cells first. (see above)
4. Each of these columns is already sorted alphabetically in ascending order
already so you can use that as a basis of how to compare items with diff
formats.
If anyone can help it would be very very gratefully appreciated. This
project is a monster and any responses would help. Thank you, Tom Moffat.
How would I go about making a worksheet that I have to find the common
traits of a cell, match it to a another cell, and put it in the same row.
Alphabetically from left to right. I dont want to erase what was already
occupying that cell. I am trying to categorize by column what each item is
missing basically.
To better understand my worksheet is set up like so (items all mixed up)
VENDOR | DIAGRAMS | CONTROL | RACK |DETAILS
AMX |AMX_MAX-2000| AMX -1000 |AMX-NXA-AVB|AMX - AC-RK
AMX - NI-4000 | AMX MAX -2000| AMX 50BG |AMX_Z90
To Turn to this
VENDOR | DIAGRAMS | CONTROL | RACK | DETAILS
AMX | | AMX -1000 | |
| | | AMX_50BG |
| | |
|AMX - AC-RK
|AMX_MAX-2000| AMX MAX -2000 | |
AMX - NI-4000 | | |
| |AMX_NXA-AVB|
|
| AMX - Z90
Alphabetically by row and column.
Basically its like a treeview(i think) only more complicated.
***1. The formating is different a lot of the time so it would be best to
compare sections of a cell, like a section of all consistent characters
(letters, numbers etc) and compare to the other cells in the row, then the
next set of consistent characters get compared etc.
(Maybe also a way to disregard certain characters like spaces, _ , -,+)???
2. If cell is empty then check the next cell. Keep matching items in the
same row (DONT CHANGE COLUMNS!). EACH DIFFERNT ITEM HAS ITS OWN ROW. I am
trying to categorize by column what each item is missing basically.
3.Organize the columns by empty cells first. (see above)
4. Each of these columns is already sorted alphabetically in ascending order
already so you can use that as a basis of how to compare items with diff
formats.
If anyone can help it would be very very gratefully appreciated. This
project is a monster and any responses would help. Thank you, Tom Moffat.