Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help in extract of data
AA 28 29 30 31 32 33 34
BB XS S M L XL XXL This is the size chart. AA is the code of size, some code is count by 28 29 etc, some code is in SML. Then in the same sheet, I have to report that which size and how many pcs that I have my product in stock. What I do it in very manual way, is I look at the size code and go back to size chart and copy the size in the the cell. What I want is that when I type only AA in cell A10 , I would like to extract 28 29 30 31 etc into B10 B11 B12........... For example: size code AA 28 29 30 31 32 33 34 quantity 5 pcs 5 pcs 4 pcs 5 pcs Kindly help it could save my time cause I have do it to 1000 products in a time. Many thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help in extract of data
Suppose the size chart is in rows 1:2, then enter this formula in B10 and
drag it to the right until the last column of the size chart: =OFFSET($A$1,MATCH($A$10,$A$1:$A$2,0)-1,1,1,7) 7 in the formula is the No of columns in the size chart! Regards, Stefi €˛Ms. Latte€¯ ezt Ć*rta: AA 28 29 30 31 32 33 34 BB XS S M L XL XXL This is the size chart. AA is the code of size, some code is count by 28 29 etc, some code is in SML. Then in the same sheet, I have to report that which size and how many pcs that I have my product in stock. What I do it in very manual way, is I look at the size code and go back to size chart and copy the size in the the cell. What I want is that when I type only AA in cell A10 , I would like to extract 28 29 30 31 etc into B10 B11 B12........... For example: size code AA 28 29 30 31 32 33 34 quantity 5 pcs 5 pcs 4 pcs 5 pcs Kindly help it could save my time cause I have do it to 1000 products in a time. Many thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help in extract of data
Thank you so much. However, this could apply to single row. I understand taht
$A$10 means the cell that I will key in the size code, but if I want to copy this formular to many row, then what is the fomular that will change $A$10 to many many single cell (i.e. the right cell of the one I put fomular to). Many thanks for your kind help. "Stefi" wrote: Suppose the size chart is in rows 1:2, then enter this formula in B10 and drag it to the right until the last column of the size chart: =OFFSET($A$1,MATCH($A$10,$A$1:$A$2,0)-1,1,1,7) 7 in the formula is the No of columns in the size chart! Regards, Stefi €˛Ms. Latte€¯ ezt Ć*rta: AA 28 29 30 31 32 33 34 BB XS S M L XL XXL This is the size chart. AA is the code of size, some code is count by 28 29 etc, some code is in SML. Then in the same sheet, I have to report that which size and how many pcs that I have my product in stock. What I do it in very manual way, is I look at the size code and go back to size chart and copy the size in the the cell. What I want is that when I type only AA in cell A10 , I would like to extract 28 29 30 31 etc into B10 B11 B12........... For example: size code AA 28 29 30 31 32 33 34 quantity 5 pcs 5 pcs 4 pcs 5 pcs Kindly help it could save my time cause I have do it to 1000 products in a time. Many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tying to extract all data from a pivot pulling from external data | Excel Discussion (Misc queries) | |||
How to extract the data | Excel Worksheet Functions | |||
extract data | Excel Discussion (Misc queries) | |||
Extract Data | Excel Discussion (Misc queries) |