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))
Microsoft's new mouse is according to their claim a comfortable mouse that is the most advanced mobility tool available. It's features are:
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.
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.
Recent comments
10 years 37 weeks ago
10 years 37 weeks ago
10 years 39 weeks ago
10 years 39 weeks ago
10 years 39 weeks ago
10 years 39 weeks ago
10 years 39 weeks ago
10 years 39 weeks ago
10 years 39 weeks ago
10 years 39 weeks ago