Excel

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

i have to find latest date for each item whenever i open the sheet. ....there r more than 100 items...and data is modified continiously.so the formula s'd consider latest changes in file and give latest date for each item

symbol qty lifted Q date
A 1400 1080 6/10/2010
A 4800 10200 6/19/2010
A 12600 24000 6/16/2010
A 15000 5400 6/10/2010
A 25200 9000 6/6/2010
B 6000 3000 6/2/2010
B 6000 21000 6/2/2010
B 9000 9000 8/22/2010
B 12000 11000 6/10/2010
B 17000 34000 6/6/2010
C 2400 20000 6/18/2010
C 16000 16000 5/5/2010
C 5200 1000 6/29/2010
C 10000 10000 6/6/2010
D 10500 10500 4/4/2010
D 7500 7500 5/4/2010
D 9000 9000 6/25/2010
D 6000 6000 4/4/2010


waiting for reply at shaileshsoni.205@gmail.com


1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Put the maximum value where ?

Any how you have to use an array function. To enter array formula, type in the formula and INSTEAD of pressing enter, you NEED TO PRESS, CTRL + SHIFT + ENTER. If you have done it correctly the formula would get enclosed within {}

this is based on assumption that that there would be a maximum of 500 rows

=MAX((A$2:A$500=A2)*(D$2:D$500))