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 denominator of the 2nd term which includes the following:
How can a range of values be equal to a single value?
A range of cells implies multiple values, right? So I understand when a range is part of a function — such as:
a) entering the formula =SUM(B1:B12) in cell B15 or
b) asking if the function of a range is equal to the value in a single cell: =IF(SUM(B1:B12)=B15,1,0)
But what does it mean to put a range of values equal to a single value?