Tag Archive | Excel

MAX & LARGE Excel

I was wondering…

Is there a way to find out the cell reference of the source of instance K (from LARGE) or the given value from MAX?

And if not: why not?!

Excel shenanigans

I have been involved with a great stack of data over the last few months; building a massive formula that so far covers all the possible falsey input I can think of!

I’ve edited all cell references so it’s obvious where they lie; and not what they refer to. Personally I find cognitive search-and-replace really frustrating, and Excel has never made debugging input to its formula bar easy (I can only imagine the frustration a command-line PHP dev’ must have!)…

The magic started life as:

=IF(OR(I6="",K6=""),"?",NETWORKDAYS(I6,K6,))

Designed around NETWORKDAYS to figure out the amount of time between two user-defined dates; it makes a nominal effort to filter out bad data. Read More…