I have a data set that I want to be able to return multiple values for this to the same cell. The data set has a list of pours that are stored in BINS. I want to be able to return using a vlookup or similar to populate those pours into the relevant cell in the matrix like below the data. I would only return 1 of each if there are multply pour values in the data set.
The data set can cover many pours and many Bin allocations. I hope there is way to be able to do this even if it not a vlookup as I though I would use. Currenlty I can only get 1 pour value.
Cheers
NZAS
The data set can cover many pours and many Bin allocations. I hope there is way to be able to do this even if it not a vlookup as I though I would use. Currenlty I can only get 1 pour value.
Cheers
NZAS
POUR | RUN_COUNT | PRODUCT | ALLOY | WEIGHT | BINAREA | BIN | ||||||
11823 | 9 | 3A949 | AA190J | 1023 | STD1A | AC408 | This data set has a lot of data listed of all POURS that are stored in Bins. I need a formula that will return list of the Pour values that are in the same Bin Number as shown below. I have a formula that I have used but only returns one of the pour numbers. This data is downloaded from a data base to excel. This gives a more visual view of where pours are stored |