-
What happens if N is zero? What should be the logic then?
-
Just want to summarize.
N column which is the amount should not be greater than any of the columns (M or R) irrespective of the signs (-ve or +ve) or Zeroes/Blanks in the columns.
-
That worked correct after incorporating with all other codes.
what code would be required if i want to create a pivot and then paste the pivots on an email body. Is this possible through a code?
-
But a zero value N column is possible. I think my formula above should work.
EDIT: I posted the above without knowing OP had responded.
The queries regarding pivot table an mailing is digressing from the original question. So please start a new thread for that.