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

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.
 
G

Gary''s Student

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)))
 
Top