#1
|
|||
|
|||
Organizing columns
Hi this is my first time and I need easy to follow help.
I wish to make at least 3 columns of information . in col1 will be a list of subjects. In col 2 will be a larger list of subjects referring to each individual subject in col1 and in col 3 another list referring to each subject in col 2. Eg. Subject 1. Subject A. Subject 1Aa Subject 1Ab Subject 1Ac Subject B. Subject 1Ba Subject 1Bb Subject 1Bc Subject C. Subject 1Ca Subject 1Cb Subject 2. Subject D. Subject 2Da Subject 2Db Etc I want to be able to bring up any subject in col 2 or col 3 in a search and have the necessary information beside it in the other columns. For example if I search for the details such as subject 1Bc in col 3 then the details in col 2 will show subject B and the details of col 1 will show subject 1. There is a probability the col 1 may have 100+ subjects, col 2 will have 2/3+ subjects per subject in col 1 and col3 may have 4/5 subjects per subject in col 2. (Hope I have explained this properly) If it can't be done in word can it be done in excel? |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Insert 8 columns into 3 columns | BendixB | Excel Programming | 2 | 08-08-2018 12:39 PM |
Matching the values in two columns A and B and to see if there are common values in both the columns | Asadmir27 | Excel | 8 | 12-29-2016 12:06 AM |
Organizing Pages | Telescopist | OneNote | 3 | 01-15-2015 04:00 PM |
Using columns | katrinao | Word | 1 | 06-14-2014 12:08 PM |
How to compare 2 columns with other two columns in EXECL 2007? | Learner7 | Excel | 5 | 06-12-2010 09:54 AM |