Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nesting? How do I create a table to reference?
Tried to nest more than 8 componets but it did not work. Any help on creating a table to reference it would be appreciated. Never done it before. Tried the Excel help, and it was worthless. Here is my original post that explains mo http://www.excelforum.com/showthread.php?t=498860 -- mcr1 ------------------------------------------------------------------------ mcr1's Profile: http://www.excelforum.com/member.php...o&userid=15496 View this thread: http://www.excelforum.com/showthread...hreadid=498905 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nesting? How do I create a table to reference?
ok you have a two column table.starting in the lh column you type your 1k,2ac
etc going down the page,and in the cell next to each code you type the correspomding number,also going down the page so you end up with 1K 51126 2AC 36320 etc is that what you want? -- paul remove nospam for email addy! "mcr1" wrote: Tried to nest more than 8 componets but it did not work. Any help on creating a table to reference it would be appreciated. Never done it before. Tried the Excel help, and it was worthless. Here is my original post that explains mo http://www.excelforum.com/showthread.php?t=498860 -- mcr1 ------------------------------------------------------------------------ mcr1's Profile: http://www.excelforum.com/member.php...o&userid=15496 View this thread: http://www.excelforum.com/showthread...hreadid=498905 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nesting? How do I create a table to reference?
when I click table from the Data menu, no matter what I do I get the Input range is not valid. I have no idea how to even begin to create a simple table. -- mcr1 ------------------------------------------------------------------------ mcr1's Profile: http://www.excelforum.com/member.php...o&userid=15496 View this thread: http://www.excelforum.com/showthread...hreadid=498905 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nesting? How do I create a table to reference?
On Fri, 6 Jan 2006 18:51:47 -0600, mcr1
wrote: when I click table from the Data menu, no matter what I do I get the Input range is not valid. I have no idea how to even begin to create a simple table. Well for one thing, please don't split the same question off into a different thread by giving it a new subject name. This question has been answered in your original thread; something that someone coming across THIS thread may not realise, which would result in them wasting their time answering it here as well. But just for reference, the Data menu doesn't have anything to do with Paul's reply. A table (in this context) is just a range of cells that contain: - the value that you want to look up, and - the value that you want returned, in a side by side arrangement. --------------------------------------------------------- Hank Scorpio scorpionet who hates spam is at iprimus.com.au (You know what to do.) * Please keep all replies in this Newsgroup. Thanks! * |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you create formulas in pivot table eg simple division? | Excel Worksheet Functions | |||
paste reletive reference in pivot table | Excel Discussion (Misc queries) | |||
Create pivot table from 2 worksheets | Excel Discussion (Misc queries) | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
create space in line chart between points, linked to pivot table | Charts and Charting in Excel |