Help with Match Index and MAX Formula

B

brendongl

New Member
Joined
Jun 16, 2011
Messages
46
AI
101/05/17Apple
202/05/17Orange
301/06/17Apple

<tbody>
</tbody>

Hello. I have spent quite some time making a formula to display the date for the latest sale of some of my products. I have another topic about this but those formulas did not work, i believe because the max function only operates if you are using numbers? (it says on the microsoft support site "[FONT=&quot]If the arguments contain no numbers, MAX returns 0 (zero).")
[/FONT]
Column A is actually a formula giving them date as it is a vlookup function. Maybe that is why i have been failing making this formula??
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Sort by date Sort by votes
I am trying to get the maximum date. The example is a very small sample, sometimes i have many Products sold on the same day, but i just need the date of the latest sold displayed on another sheet.
 
Upvote 0
You just want the newest date in column A regardless of the product in column I?

Howard
 
Upvote 0
No.

For example.

INDEX(a1:a3,MATCH([@SKU],I2:I$3,0)),0)

@SKU will be a cell value.
But the formula above only returns the earliest date, ive tried changing the last number but it still returns the first date.

Sorry i am terrible at explaining.
 
Upvote 0
That worked, kind of. Can you explain what 9.99999999999999E+307 is for? I just tried it using data from a different sheet and its caused my excel to freeze after formatting 1000 cells the same formula >.<

EDIT: Its causing my whole sheet to slowdown actually. :(
I have a i7 Processor as well. Perhaps there is another formula which won't cause such slowdowns?
 
Last edited:
Upvote 0
brendongl said:
That worked, kind of. Can you explain what 9.99999999999999E+307 is for? I just tried it using data from a different sheet and its caused my excel to freeze after formatting 1000 cells the same formula >.<
Click to expand...

What do you mean by "formatting 1000 cells the same formula"? And which formula are you addressing: the second?
 
Upvote 0
You must log in or register to reply here.

Similar threads

K
  • Solved
Identifying the duplicate id names with latest date by formula or VBA
Replies
2
Views
238
kismatstha
K
J
  • Solved
Excel Formula to highlight most recent record
Replies
3
Views
98
etaf
etaf
A
  • Solved
AVERAGEIFS with 4 criteria
2
Replies
16
Views
313
Fluff
Fluff
G
  • Solved
Counting zero billing days in Excel until current date
Replies
5
Views
541
awoohaw
awoohaw
J
  • Question
SUMIFS formula modification help
Replies
5
Views
191
SanjayGMusafir
SanjayGMusafir

Forum statistics

Threads
1,214,847
Messages
6,121,911
Members
449,054
Latest member
luca142

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top