Want to segrigate data that has same order number, particular bill codes & same qty

[sansri005]

Hi All,

Please help me in extracting data from master file to another excel sheet. Below are the conditions

1. There are many order numbers - so I want all the order numbers which has running bill codes i.e. 4256 & 4257/4236 & 4237 etc, along with bill code 220/398.
2. Also rate for running bill code should be same. Below is the example of how extracted data should look like and attached excel with full data.

Order Number Bill Code Description Bill Division Id Bill Department Id Dept Bill Unit Qty
195955748 220 TRANSPORTATION HANDLING 3-INPATIENT 3003600-862 <B> 12
195955748 4256 #2000 STANDARD CARTON LTR/LGL, BOT 3-INPATIENT 3003600-862 <B> 50
195955748 4257 #2000 STANDARD CARTON LTR/LGL, TOP 3-INPATIENT 3003600-862 <B> 50

Please let me know if you need any other details.

Thanks,
Sanjeev

[shukla.ankur281190]

In Sheet Two A2 =IFERROR(INDEX('Sample Data'!$F$2:$F$256,MATCH(0,COUNTIFS(Sheet1!$A$1:A1,'Sample Data'!$F$2:$F$256),0)),"")with Ctrl+Shift+Enter for Unique Value and drag it down.

A2

Please Login or Register  to view this content.

In Sheet Two B2 =IFERROR(INDEX('Sample Data'!G$2:G$256,MATCH(Sheet1!$A2,'Sample Data'!$F$2:$F$256,0),MATCH(Sheet1!B$1,'Sample Data'!$F$1:$L$1,0)-COLUMNS($A$1:A1)),"")with Ctrl+Shift+Enter for Unique Value and drag it right and down.

B2

Please Login or Register  to view this content.

Excel sheet is attached for your information pls.