• Buffer
  • Sharebar
  • Buffer
jethro's picture

Finding MAX date with an Array Formula in Excel

Last week I was struggling with getting an array formula to work properly with the MAX function.
I had a column of business units, a column of dates and a status column.
I wanted to find the most recent date for any given business unit where the status was a particular criteria.
I did try using Bob Phillip's sum product page and Chris Pearson's array formulas page, but it still wasn't working right. Fortunately Bob emailed me with the answer and explained it very well. (I was missing the IF function).
Heres the formula and what Bob said about it:
=MAX(IF((criteria_range1="criteria1")* (criteria_range2="criteria2")* (criteria_range3="criteria3"), date_range))

Lena's picture

Microsoft Mobile Memory Mouse 8000

Microsoft's new mouse is according to their claim a comfortable mouse that is the most advanced mobility tool available. It's features are:

  • Transceiver with 1 GB Flash Memory
  • 2.4 GHz Wireless Technology
  • USB Rechargeable with Magnetic Connectors
  • High Definition Laser Technology
  • Battery Life Indicator

Its transceiver contains 1 GB Flash Memory, which frees up 1 USB port. Apparently you can even continue to work while your mouse is charging.

I think we will continue to see more of these types of combinations of hardware as manufacturers attempt to differentiate their products from the generic masses.

jethro's picture

Powernap

I have been working hard since 8:30am. A power nap was needed at 2:30pm.
45 minutes later I was woken by a client calling my phone. Now I feel refreshed for another hour and a half of work before we go to the gym.

Lena's picture

A collection of free images

Sources for Free Stock Images

When designing a website or blog, you've probably wanted to add images to your creation. It's easy to forget that the images belong to the people who have created them. Staying legal means you’ll have to either create your own images or buy them from stock sites. This website has a collection of free images that can be used.