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





CCI Pro
Meet our CAclubindia PRO Members
Subscribe Now

Trending Online Classes

view all classess

Follow us

Popular Files


  1. TDS Party-Wise Section-Wise Reconciliation Format
  2. Fixed Assets & Depreciation - Excel Format
  3. Annexure: GST & Non-GST Expenses for FY 2024-25
  4. Capital Gain Format
  5. Mutual Fund Taxation: 2025-2026
  6. Portfolio Valuation Report Format
  7. Tax Report Unlisted Share
  8. Portfolio Holding Report Unlisted Share
  9. Year-End GST Filing 2025 - A Complete Guide for CAs
  10. Distributorship Application Format