Formula in Excel to display the date for the last occurrence of a value in a table
This is a follow-up question to the above thread. The formula given (by Flyster
) for the solution was:
My question in this
thread relates to the structure of the 2nd term:
I have seen (and I now use) a number of solutions — usually from Barry Houdini
— which include a reciprocal argument
. (Is that correct terminology, ie for when a function is a denominator)? However, I don't really understand the rationale or mechanism at work and therefore cannot exploit the same approach in other similar situations.
Can someone provide a brief explanation of reciprocal arguments or point me to a resource which explains this form?