Home

Downloading cells from one Worksheet to another

%3CLINGO-SUB%20id%3D%22lingo-sub-490152%22%20slang%3D%22en-US%22%3EDownloading%20cells%20from%20one%20Worksheet%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-490152%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20There%2C%3C%2FP%3E%3CP%3EI%20use%20this%20formula%20to%20extract%20some%20cells%20from%20Worksheet%20%22Suppliers%22%20based%20on%20a%20certain%20condition%20and%20load%20it%20into%20Worksheet%20%22P%3CSPAN%3E%26amp%3BL%22%3C%2FSPAN%3E.%20The%20formula%20works%20fine%20but%20I%20do%20not%20know%20how%20to%20modify%20it%20to%20exclude%20the%20duplicate%20values.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIFERROR(INDEX(Table1%5B%5BSupplier%20Name%5D%3A%5BProduct%20Type%5D%5D%2CSMALL(IF((Table1%5BProduct%20Type%5D%3D%24A%249)%2CROW(Table1%5BProduct%20Type%5D)-1)%2CROWS(%24C%249%3AC9))%2C1)%2C%22%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20a%20sample%20file%20to%20demonstrate%20what%20I%20need%20to%20do.%20The%20duplicate%20cells%20are%20highlighted%20in%20Yellow%2C%20which%20I%20need%20to%20exclude.%20If%20the%20formula%20I%20use%20cannot%20be%20modified%20to%20do%20the%20job%2C%20I%20appreciate%20your%20input%20with%20another%20one.%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-490152%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
saad soliman
Occasional Contributor

Hi There,

I use this formula to extract some cells from Worksheet "Suppliers" based on a certain condition and load it into Worksheet "P&L". The formula works fine but I do not know how to modify it to exclude the duplicate values.

 

=IFERROR(INDEX(Table1[[Supplier Name]:[Product Type]],SMALL(IF((Table1[Product Type]=$A$9),ROW(Table1[Product Type])-1),ROWS($C$9:C9)),1),"")

 

Thank you

 

I have attached a sample file to demonstrate what I need to do. The duplicate cells are highlighted in Yellow, which I need to exclude. If the formula I use cannot be modified to do the job, I appreciate your input with another one.

Thank you