Solved

excel 2010 MIN-MAX, VLOOKUP

Posted on 2015-02-13
4
121 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
[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
  • Learn & ask questions
  • 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 500 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

623 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