Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
BRAIN BUSTER!! MULTI COLUMN ROW DIFFERNCES
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
BRAIN BUSTER!! MULTI COLUMN ROW DIFFERNCES
NOTE:: The chart got a little screwed up after posting.
the | AMX - AC-RK is supposed to be at the end of the row above it. Thats it and good luck! "Tom Moffatt" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
BRAIN BUSTER!! MULTI COLUMN ROW DIFFERNCES
Also the same for the AMX z90
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multi column lookup | Excel Discussion (Misc queries) | |||
match in multi-column and multi-row array | Excel Discussion (Misc queries) | |||
Multi Column Sum and conditions | Excel Worksheet Functions | |||
Jargon Buster | Excel Discussion (Misc queries) | |||
Multi-Column Printing | Excel Discussion (Misc queries) |