Download Files uploaded by CA Vishal Pukale DISA





xls File
30 KB

Excel Extract Max Value with Two Conditions in Array

click here to download the file

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: 670) Info Technology





CCI Pro

Trending Online Classes

view all classess

Popular Files


  1. Invoice format: Self Invoicing under RCM
  2. CA Final Direct Tax Laws & International Taxation (DT) Question Paper New Course Nov 2024
  3. CA Final Advanced Auditing, Assurance And Professional Ethics Question Paper New Course Nov 2024
  4. TDS in Excel Format
  5. HUF Deed Format
  6. Tax Audit Checklist in Excel Format
  7. All in One TDS on Salary for the FY 2024-25
  8. TDS on Scrap Purchase in GST: Excel Automated Formulas Format
  9. Depreciation
  10. Form 15CA 15CB Excel Format Download (All Parts A, B, C, D)