Improve company productivity with a Business Account.Sign Up

x
?
Solved

excel 2010 MIN-MAX, VLOOKUP

Posted on 2015-02-13
4
Medium Priority
?
167 Views
Last Modified: 2015-02-13
Hello experts,

Good day,

I attached a file where i need to find the min date and max date of delivery based on a PO/ITEM in MSA sheet in a correct PO/ITEM in RDA sheet as ive colored the column where i need to put the formula, can anyone help me, i'm trying to do the Vlookup max but i cant get the correct formula.

Thanks.

Czher
Sample.xlsx
0
Comment
Question by:Czher
  • 2
  • 2
4 Comments
 
LVL 5

Expert Comment

by:Hakan Yılmaz
ID: 40609407
Look at the attached file, i used array formula. Max(If(,)) and Min(If(,)).
Sample.xlsx
0
 

Author Comment

by:Czher
ID: 40609417
yilmaz,

i need to show it in RDA sheet( red ), need to compare the MSR and RDA and put there the min and max date

thank you
0
 
LVL 5

Accepted Solution

by:
Hakan Yılmaz earned 2000 total points
ID: 40609425
I rewrite the same formula to RDA sheet, you mean this?
Sample-1-.xlsx
0
 

Author Closing Comment

by:Czher
ID: 40609435
Yilmaz,

Thank you for your help....


Czher
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This article describes a serious pitfall that can happen when deleting shapes using VBA.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

595 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question