• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 157
  • Last Modified:

excel 2010 MIN-MAX, VLOOKUP

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
Czher
Asked:
Czher
  • 2
  • 2
1 Solution
 
Hakan YılmazTechnical Office MEP EngineerCommented:
Look at the attached file, i used array formula. Max(If(,)) and Min(If(,)).
Sample.xlsx
0
 
CzherAuthor Commented:
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
 
Hakan YılmazTechnical Office MEP EngineerCommented:
I rewrite the same formula to RDA sheet, you mean this?
Sample-1-.xlsx
0
 
CzherAuthor Commented:
Yilmaz,

Thank you for your help....


Czher
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now