Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

excel 2010 MIN-MAX, VLOOKUP

Posted on 2015-02-13
Medium Priority
132 Views
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
Question by:Czher
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2
• 2

LVL 5

Expert Comment

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

Author Comment

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

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

ID: 40609435
Yilmaz,

Czher
0

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
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 demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Suggested Courses
Course of the Month6 days, 18 hours left to enroll