Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help to build a table
Please help me to build a table similar to this one
The number on the first column will change after 16 times, it will go in sequence from 1001, 1002, etc€¦ The number in the second column will change after 4 times and it will go from 1 to 4 The number in the 3rd column will go from 1 to 4 2nd and 3rd column will keep the same pattern. Cabinet Shelf Location 1001 1 1 1001 1 2 1001 1 3 1001 1 4 1001 2 1 1001 2 2 1001 2 3 1001 2 4 1001 3 1 1001 3 2 1001 3 3 1001 3 4 1001 4 1 1001 4 2 1001 4 3 1001 4 4 1002 1 1 1002 1 2 1002 1 3 1002 1 4 1002 2 1 1002 2 2 1002 2 3 1002 2 4 1002 3 1 1002 3 2 1002 3 3 1002 3 4 1002 4 1 1002 4 2 1002 4 3 1002 4 4 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Build a Table | Excel Discussion (Misc queries) | |||
Different ways to build Pivot table | Excel Discussion (Misc queries) | |||
How do I build a sensitivity analysis table? | Excel Worksheet Functions | |||
Match 2 sheet and build table | Excel Discussion (Misc queries) | |||
How do i build a search table in excel | Excel Worksheet Functions |