Spreadsheet: 775605d1649229961-need-formula-which-can-extract-bold-value-in-opp-column-need-formula
Sheet: PLAN  06-04-2022

FROM WH | ORD | DATE 06-04-2022 | DF | REF L | REF S | REF M | SPLIT | WD | Grand Total
UN2 | BRW | NEW PAK PUNJAB ELECTRONICS-FAISAL BAZAR-HAROON ABAD-PUNJAB--PK |  |  | 2 |  |  |  |  | CANCEL
 |  | KHAWAJA ADEEL ELECTRONICS-8 / E, KHAWAJA ROAD-CHISHTIAN-PUNJAB--PK |  |  | 6 |  |  |  |  | CANCEL
UN2 |  | AL MUMTAZ GROUP OF ELECTRONICS-VEHARI BAZAR NEAR FISH MARKET-BUREWALA-PUNJAB--PK |  |  |  |  | 76
UN2 | DIK | MAMASH KHEL ELECTRONICS-CHOWK BAZAR-BANNU-KHYBER PAKHTUNKHWA--PK |  |  | 3 |  |  |  |  | CANCEL
UN2 |  | TAHIR ELECTRONICS-MAIN BAZAR-DOMIL-KHYBER PAKHTUNKHWA--PK | 4 |  |  |  |  |  |  | CANCEL
UN2 |  | RASHID ELECTRONICS-CHOWK BAZAR-BANNU-KHYBER PAKHTUNKHWA--PK |  | 2 | 2 |  |  |  |  | CANCEL
UN2 | HYD | NATIONAL ELECTRONICS-FOUJDARI ROAD-HYDERABAD-SINDH--PK |  |  | 2 |  |  |  |  | CANCEL
UN2 | FSD | SHAH GEE ELECTRONICS & MOBILES-MAIN ROAD DHUDI WALA JARANWALA ROAD-FAISALABAD-PUNJAB--PK |  | 1
UN2 |  | ZAINAB ELECTRONICS-KOTWALI ROAD NEAR MCB BANK-FAISALABAD-PUNJAB--PK |  | 2 |  |  |  |  |  | CANCEL
UN2 | GRT | WORLD ELECTRONICS-G-T ROAD SARAI ALAMGIR-GUJRAT-PUNJAB--PK |  |  |  |  | 10 |  |  | CANCEL
UN2 | MUL | MASHA ALLAH ELECTRONICS-USmania Chowk, [NAME], [NAME], [NAME] PUR-PUNJAB--PK |  | 3 |  |  |  |  |  | CANCEL
UN2 |  | MASHA ALLAH ELECTRONICS ([NAME] AGHAHI ROAD-MULTAN-PUNJAB--PK |  |  |  |  | 200 |  |  | CANCEL
UN2 |  | BISMILLAH ELECTRONICS-PLOT NO#30,SHEET10, SHERPOW COLONY NO.2,-KARACHI-SINDH--PK |  |  | 80 |  |  | 400 |  | CANCEL
UN2 | WAH | MURAD ELECTRONICS & REFRIGERATION-SHOP SAFDAR PLAZA, G.T. ROAD KUTBA MORE, KAMRA CANTT NEAR BANK ALFALAH-KAMRA-PUNJAB--PK |  |  |  |  |  | 1 |  | CANCEL
UN2 | QTA | FAZAL ELECTRONICS-NAJEEB STREET-QUETTA-SINDH--PK | 6 |  |  |  |  |  |  | CANCEL
TOTAL PMS
FROM WH | ORD | DATE 06-04-2022 | DF | REF L | REF S | REF M | SPLIT | WD | Grand Total
PMS | BRW | AL MUMTAZ GROUP OF ELECTRONICS-VEHARI BAZAR NEAR FISH MARKET-BUREWALA-PUNJAB--PK |  | 1 | 908
PMS | DIK | ZAIN ELECTRONICS-WEST CIRCULAR ROAD NEAR DERA TOWN POLICEN STATION, TANK [NAME]--PK |  | 3 | 7
PMS | HYD | ALI AKBAR ELECTRONICS-STATION ROAD BHIRYA ROAD-HYDERABAD-SINDH--PK |  |  | 15
PMS | SWL | PAK ALI ELECTRONICS-78-79-80, [NAME] PUR ROAD, SARWAR CHOWK-OKARA-PUNJAB--PK |  | 2
PMS | WAH | MURAD ELECTRONICS & REFRIGERATION-SHOP SAFDAR PLAZA, G.T. ROAD KUTBA MORE, KAMRA CANTT NEAR BANK ALFALAH-KAMRA-PUNJAB--PK |  |  | 22
PMS | PSH | PESHAWAR ELECTRONICS-Main Bazzar-SHABQADAR-Khyber Pakhtunkhaw--PK | 10 | 45 | 158 | 30
PMS |  | EMARAT ELECTRONICS-SADDAR BAZAR-NOWSHERA-Khyber Pakhtunkhaw--PK |  | 1
PMS | KHI | IMRAN AUTOS-SHOP NO: 23 & 24, SUPER JAMIA MARKET, MALIR, , [NAME]--PK |  | 109 | 324 | 20
PMS |  | AL-MUSTAFA WHOLE SALE HOUSE-SHOP NO. 3/4 SHAFI EXCELLENCY, SECTOR 5-1 NEAR CHASE UP, [NAME], KARACHI CENTRAL NORTH KARACHI TOWN-KARACHI-SINDH--PK |  | 6
PMS |  | CITY ELECTRONICS-M-SHOP 102 SHUMAIL COMPLEX MOSAMIYAT CHOWK UNIVERISTY-KARACHI-SINDH--PK |  |  |  |  |  | 30
PMS |  | PAK KARACHI ELECTRONICS-SHOP NO 80, SHUMAIL COMPLEX MOSMIAT CHOWK UNIVERSITY ROAD-KARACHI-SINDH--PK |  |  |  |  |  | 30
PMS |  | NEW SAMNAN ELECTRONICS-LS-31/32, SECTOR 5C-2 SUPER DELUX HOTEL-KARACHI-SINDH--PK |  |  | 15
PMS |  | CITY ELECTRONICS-SHOP# 1 SHEIKH CENTER BLOCK 13-B GULSHAN E IQBAL-KARACHI-SINDH--PK |  |  |  |  |  | 20
PMS |  | BISMILLAH ELECTRONICS-PLOT NO#30,SHEET10, SHERPOW COLONY NO.2,-KARACHI-SINDH--PK |  | 58
PMS | RYK | FAIZ ELECTRONICS-25-SHAHI ROAD RAHIM [NAME] YAR KHAN-PUNJAB--PK |  | 10
TOTAL PMS
Grand Total