A B
Item1 Jul
Item1 Sep
Item1 Oct
Item2 Apr
Item2 Jun
Item2 Dec
e.g.
How to get the min and max date for Item1?
A B
Item1 Jul
Item1 Sep
Item1 Oct
Item2 Apr
Item2 Jun
Item2 Dec
e.g.
How to get the min and max date for Item1?
if they are real dates then these 2 array formulas
=MAX((A1:A6="item1")*(B1:B6))
=MIN(IF(A1:A6="item1",B1:B6,""))
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thank you
It works as you wrote it.
But when I change it to:
=MAX((A:A="item1")*(B:B))
=MIN(IF(A:A="item1",B:B,""))
they both return #VALUE
I suppose where the data ends in doesn't like the blanks.
But I have to run this formula against many rows that may grow over time. Any ideas?
that formula doesn't like a:a ,b:b try a1:a10000,b1:b10000
Could try array formulas -
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks