i am trying to create a formula in excel where i can select certain entries to be posted in another sheet or table so basically what i have here is a tender for digital devices computers laptops mainframe and there is 4 companies that applied for the tender so after the technical and commercial study of the tender offers there is companies that passed in certain items and failed in others so i put the unit price in USD for each company for the items and iam trying to create a formula to pick up the lowest price for each company BUT with the condition that it should be labeled PASSED not failed so i can make the report with the lowest passed companies for each item with their company name i tried using minimum and match and index but that got me the lowest price including the failed companies so i don't know what to do i attached a copy of the dummy excel sheet for you to check it out and help me.
Best regardsDumy Excel sheet
Aucun commentaire:
Enregistrer un commentaire