number of periods function where payments(inflows) are not equal

  • Thread starter Thread starter epcookjr
  • Start date Start date
E

epcookjr

i am looking for a function that returns the number of periods when the
period payments are not equal. such as calculating pay back on and investment
where the inflows are not equal.
 
If you have a set of values in A1 thru A10 and want the number that are not
equal:

=SUMPRODUCT(--((A1:A10)<>MODE(A1:A10)))
 
Back
Top