View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Margo Guda
 
Posts: n/a
Default 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