search worksheet

  • Thread starter Thread starter bill
  • Start date Start date
B

bill

i have a question on advance searching. i have a worksheet
with > 1000 cells and i want to search them to find all
that have the same text string in them.
 
You could add a column, number your entries sequentially,
use the IF function (=IF(b1="text", 1, "") then data sort
by the 1's column, you have the entries sorted by number
sequence that meet your requirements.
 
my data is a compilation of md5 sums and i want to
eliminate duplicate files that sometimes show up. to use
the find command i would have to know the exact value which
would be difficult to do with so many values.
 
Back
Top