Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple references
I'm struggling with designing a spreadsheet. I am cataloging quotes referred
to in various speeches and organizing them by topic. My columns look like this: Topic Quote Original Reference LDS Reference My problem is two fold. First when I have the same quotation referenced by two different speakers. Duplicating the original reference seems redundant but is it necessary for recording the raw data. The second problem is when a quote covers multiple topics. If something refers to both pride and weakness. I can't put both topics in the same cell and filter for pride because it records pride, weakness as a single entry. I am expecting this to get to over a thousand quotes and need my design to support that much data so having three topics columns is a pain. Is that the only way? I've been through tutorials and looked everywhere and am still in a quandry. Do I just record everything separate and then use various sorting methods and pivot table to interpret the data? HELP!!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003- multiple references | Excel Discussion (Misc queries) | |||
Multiple cell references | Excel Worksheet Functions | |||
How do I put multiple references in the same cell? | Excel Worksheet Functions | |||
multiple cell references | Links and Linking in Excel | |||
Multiple References | Excel Discussion (Misc queries) |