In a given set of data you want to find maximum or minimum number you can use the MAX + IF forumla,
Note : this is a CSE Formula, so please ensure you press Ctrl + Shift + Enter after typing this formula, instead of just pressing Enter.
Eg : A Vendor has many purchase records, you want to know when you purchased last
Say the records are this way
You want to know the last purchase details
The formula is
No comments:
Post a Comment