banner_ad

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) Technology & Tools





banner

Trending Online Classes

view all classess

CCI Pro
Meet our CAclubindia PRO Members
Subscribe Now

Follow us
add to google news


Popular Files


  1. ICAI Releases Code of Ethics 2026 - Vol I
  2. ICAI Releases Code of Ethics 2026 - Vol II
  3. ICAI Releases Code of Ethics 2026 - Vol III
  4. FAQs on FIIs Exemption
  5. RBI (Urban Co-operative Banks - Governance) Amendment Directions, 2026
  6. FAQs on BIS Exemption
  7. RBI Bulletin: May 2026
  8. RBI (Rural Co-operative Banks - Governance) Amendment Directions, 2026

Latest Job Openings

View all
Company
24 May 2026
Accounts & Tax Executive

PARAS KHURANA AND CO

New Delhi

B.Com

View Details
Company
11 May 2026
Post office

Post office

Anakapalle

Others

View Details
Company
16 May 2026
Account & Audit Asst

RAHUL KHANDEBHARAD & ASSOCIATES

Nashik

B.Com

View Details
Company
ARTICLESHIP 14 May 2026
CA ARTICLE

PRAVEEN GARG & CO

Faridabad

CA Foundation

View Details
Company
14 May 2026
Senior Accounts Executive

Karan Gupta & Co.

New Delhi

Graduate (Any)

View Details
Company
ARTICLESHIP 28 May 2026
Accounts, Audit & Compliance Executive

Shyam Joshi & Associates

Pune

B.Com

View Details
Company
ARTICLESHIP 17 May 2026
CA Article /Trainee

Malik Sunil & co

New Delhi

CA Foundation

View Details
Company
22 May 2026
Audit assistant

Displayandbeyond

Mumbai

CA

View Details