Excel: Counting of smiliar type of data based on certain conditions


Hi All I have a set of data in a single column stated below :

30.32
73.82
133.99
51.93
51.77
54.55
55.24
60.95
60.95
60.95
52.35
Now if i want to get the final result where all rows ending with .95 should be true or else false, how can i derive through simple excel formula. Thanks in advance in anticipation to get positive response.


This question generated 8 answers. To proceed to the answers, click here.

This thread is current as of November 08, 2014.


For more resources for Microsoft Excel