LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 190
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Build a Table jxbeeman Excel Discussion (Misc queries) 2 August 12th 09 11:19 PM
Different ways to build Pivot table Jan T.[_3_] Excel Discussion (Misc queries) 1 March 3rd 09 08:46 PM
How do I build a sensitivity analysis table? OS Excel Worksheet Functions 1 September 12th 07 08:55 PM
Match 2 sheet and build table npereira Excel Discussion (Misc queries) 9 August 11th 06 07:35 PM
How do i build a search table in excel Obi-Wan Kenobi Excel Worksheet Functions 2 March 20th 06 03:20 PM


All times are GMT +1. The time now is 02:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"