data filtering based on last two digits of large number
Do you mean add a column with this formula to the whole dataset? (i.e.
in a new column, put one in every cell where column A has a number?).
That would pose a different problem. The file as it now stands is over
14 MB. I'm not sure if my system can handle it if I do this (There are
tens of thousands of data to do!)
Bernard Liengme wrote:
Try IF(--RIGHT(A5,2)=53,1,0) then filter or sort on the 1s and 0s
|