Excel Extract Max Value with Two Conditions in Array

Last updated: 17 May 2016
File details
XLS 30 KB 0 downloads Technology & Tools
File description
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
Download XLS 30 KB Like
Submitted by · Posted 17 May 2016 · Other files by CA Vishal Pukale DISA · Report
Comments

Recent Files in Technology & Tools

View more →
XLSX

How to Show Text after Value in Pivot Table

26 May 2025 Download
XLSX

Extract Company Name & CIN No. from NCLT E-Mail - Working IBBI

05 June 2025 Download
PDF

Project & Task Management - Google Sheet Template

07 April 2025 Download
PDF

TASK MESTRO - Free Google Sheet for Task & Project Management

27 March 2025 Download
RAR

Form 16A PDF Email Sender Utility

06 December 2024 Download
RAR

Import PDF Bank Statement in Tally Prime / Tally 9 / Tally 7

05 December 2024 Download

Trending Online Classes

view all classess

CCI Pro
Meet our CAclubindia PRO Members
Pro Member ANUPAMA L KANTANUPAMA L KANTPro Member MURALIKRISHNA EDDANAPUDIMURALIKRISHNA EDDANAPUDIPro Member CA. MOHIT SHARMACA. MOHIT SHARMAPro Member karnarajkarnarajPro Member yogesh koraniyogesh korani
Subscribe to Pro
Join an elite circle of professionals


Popular Files


  1. RBI Second Amendment Directions, 2026
  2. Review of Guidelines on Concentration Risk Management - Rural Co-operative Banks
  3. MTP Series I & II for CA Final Nov 2026 Exams
  4. CBDT Releases Crypto-Asset Reporting FAQs under IT Act 2025
  5. Guidance Note on Tax Audit u/s 44AB of the IT Act, 1961 - Revised 2026 Edition
  6. Taxation And Other Laws (Amendment) Bill, 2026
  7. Armed Forces Allowances Exemption Guide 2026
  8. FAQs: Taxation and Other Laws (Amendment) Bill, 2026
  9. ICAI | 77th Annual Report and Accounts for FY 2025-26