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





Trending Online Classes

view all classess

CCI Pro
Meet our CAclubindia PRO Members
Subscribe Now

Follow us

budget 26-27

Popular Files


  1. Tax Liability for FY 2026-27 as per Budget 2026
  2. Important DT Judgements of 2025 - A Live Law Digest
  3. Form No. 130: Section 395 TDS Certificate
  4. Draft Form 168 for AIS
  5. Analysis of Budget 2026 Proposals
  6. Draft Form No. 138: New TDS Compliance Framework
  7. FAQs on Union Budget 2026-27
  8. New CA Certificate (Draft Form 146) for Foreign Remittances
  9. Form No. 140: Quarterly TDS Statement for Resident Payments
  10. Supreme Court Annual Digest 2025