Dear All,
I have entries in excel, all numbers are same but entries in plus and mines.
correct figureĀ in plus (for reference sheet attached)
please suggest me any formula for identifying the correct entry out of them.
Regards
Amit Varshney
Dear All,
I have entries in excel, all numbers are same but entries in plus and mines.
correct figureĀ in plus (for reference sheet attached)
please suggest me any formula for identifying the correct entry out of them.
Regards
Amit Varshney
=MAX(A2:A12)
The correct amount is
=ABS(A2)
When copied down, this will write the correct amount next to each amount in column A. Please read my comment on @k1w1sm's answer above.
A list of distinct amounts, where each amount appears only once, could be created using filters or cell formatting or even by tweaking the formula. One would need to kow the requirement and, most probably, what's in the other columns of the sheet.
WOW. From the way it's structured I'm amazed anyone could even understand the question. My hat's off to you guys.