[Solved] LAST ORDER DATE

General Excel Questions & Answers

2 Posts

2 Users

0 Reactions

1,644 Views

RSS

Md Saliha

(@navsal66)

Posts: 136

Estimable Member

Topic starter

how to find last order date based on supplier dat, i need this result in E4

Posted : 18/04/2025 3:39 pm

Riny van Eekelen

(@riny)

Posts: 1448

Member Moderator

That would be:

=MAXIFS(B2:B6,A2:A6,E2)

Posted : 18/04/2025 4:56 pm

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed