xls

Excel Extract Max Value with Two Conditions in Array

  Download   Preview

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+Enter button #xls
CA Vishal Pukale DISA

on 17 May 2016

Other files by the user
673 times
30 KB
Rating: Total votes : 43

Download Other files in Info Technology category


Share Report
Summarize this with AI
ChatGPT Perplexity Claude Google AI Grok

CCI Pro
Comments

CAclubindia's WhatsApp Groups Link


Trending Downloads

pdf
TDS/TCS Book Adjustment New Draft Format
On : 04 March 2026
Download
pdf
Guidance Note for CA Final May 2026 Exams
On : 03 March 2026
Download
pdf
Draft Form No 166: Structured Reporting Format for Reportable Accounts
On : 04 March 2026
Download
pdf
Guidance Note for CA Intermediate May 2026 Exams
On : 03 March 2026
Download
pdf
Guidance Note for CA Foundation May 2026 Exams
On : 03 March 2026
Download

view more



Trending Online Classes

view all classess

CCI Pro
Meet our CAclubindia PRO Members
Subscribe Now

Follow us
add to google news


Popular Files


  1. Form 121: One Declaration for TDS Exemption
  2. TDS/TCS Book Adjustment New Draft Format
  3. Draft Form 141: New TDS Compliance Rules for Individuals and HUFs
  4. CBDT Introduces Draft Form No 28 for Net Worth Computation
  5. Draft Form 170: New Income Tax Valuation Rules
  6. Guidance Note for CA Final May 2026 Exams
  7. Draft Form 104 Sets New Compliance Rules for NGOs
  8. Fee Chart for May 2026 CA Exams
  9. Draft Form 165 Introduces Detailed SFT Reporting Framework
  10. Permanent Exemption Window (Intermediate & Final) - May 2026 CA Exams