Posted to microsoft.public.excel.programming

Claus Busch Claus Busch is offline

external usenet poster

Posts: 3,872

Array formula for lookup a max value cost too much time

Hi Johan,

Am Tue, 1 Sep 2020 20:35:39 -0700 (PDT) schrieb :

The problem is that when there is no value in column YY then it results with COUNTIF in 0 and with MAXIFS in "" (empty).

try:
=IF(COUNTIFS(I:I,I2,Y:Y,"<")=0,"",MAXIFS(Y:Y,I:I, I2))

Regards
Claus B.
--
Windows10
Office 2016

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating a total cost chart where a component cost is a step cost	gvm	Charts and Charting in Excel	0	April 28th 10 02:10 PM
Nested Array Formula to Determine Average cost Per Mile in 100 mileincrements	Mark Gaipo	Excel Worksheet Functions	1	October 15th 09 06:59 PM
Array formula lookup	CJ-22	Excel Worksheet Functions	6	February 8th 06 05:45 PM
An Array Lookup Formula	SueDot	Excel Programming	4	April 18th 05 06:04 PM
Two-Way Lookup Array Formula	Sam via OfficeKB.com	Excel Worksheet Functions	2	February 5th 05 09:33 PM

All times are GMT +1. The time now is 05:21 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us