Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-10-2017, 06:08 PM
JDM JDM is offline Organizing columns Windows 7 64bit Organizing columns Office 2013
Novice
Organizing columns
 
Join Date: Mar 2017
Posts: 1
JDM is on a distinguished road
Default 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?
Reply With Quote
Reply

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
Organizing columns 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
Organizing columns Using columns katrinao Word 1 06-14-2014 12:08 PM
Organizing columns How to compare 2 columns with other two columns in EXECL 2007? Learner7 Excel 5 06-12-2010 09:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:08 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft