| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding unique number from list
I have 2 work sheets.
Sheet one is an inventory of bolts. Each bolt has an uniek number. Bolts with same dimensions have an unique number. 0001 M16 x 40 8.8, 0002 M16 x 40 8.8, 0003 M16 x 30 8.8, 0004 M16 x 30 10.9, 0005 M16 x 40 8.8.... The second sheet contains bolt dimension. I need a solution to add the unique number to the bolt dimension. M16 x 40 8.8 -- 0001 (to be added), M16 x 30 8.8 -- 0003, M16 x 40 8.8 -- 0002, M16 x 40 8.8 -- 0005, M16 x 30 10.9 --0004 ..... I tried to work with formulas but didnot find the solution. Is there a wizz who could support me or point me in the right direction. Johg |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
adding unique number from list
try using a verticle lookup
" wrote: I have 2 work sheets. Sheet one is an inventory of bolts. Each bolt has an uniek number. Bolts with same dimensions have an unique number. 0001 M16 x 40 8.8, 0002 M16 x 40 8.8, 0003 M16 x 30 8.8, 0004 M16 x 30 10.9, 0005 M16 x 40 8.8.... The second sheet contains bolt dimension. I need a solution to add the unique number to the bolt dimension. M16 x 40 8.8 -- 0001 (to be added), M16 x 30 8.8 -- 0003, M16 x 40 8.8 -- 0002, M16 x 40 8.8 -- 0005, M16 x 30 10.9 --0004 ..... I tried to work with formulas but didnot find the solution. Is there a wizz who could support me or point me in the right direction. Johg |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting the number of unique values in a filtered list | Excel Discussion (Misc queries) | |||
| Obtaining Unique Number From Data Validation List | Excel Discussion (Misc queries) | |||
| How do I lookup the number of unique values from a list? | Excel Discussion (Misc queries) | |||
| how can i count the number of unique names in a list | Excel Discussion (Misc queries) | |||
| how to get the number of unique records in a list | Excel Worksheet Functions | |||
Linear Mode
