Easy Office

Download Files uploaded by CA Vishal Pukale DISA





xls File
30 KB

Excel Extract Max Value with Two Conditions in Array

If you have data in excel in which one person has achieve sales in particular date and you want to extract max amount achieved by the person on a particular date. You can use the attached formula. Please note for array formula you need to press Ctrl+Shift...

Posted on 17 May 2016  (Downloads: 667) Info Technology