hi
i have a price list. alot of the entries are duplicate. my main objective is to remove the duplicates.
but just removing duplicates with the default function is not what i want.
i tried sorting the column in alphabetical order but that doesnt help completely. as there some entries of a single product which are named differently (basically a space between or a minor spelling mistake). in this case sorting alphabetically doesnt help. example "abcd" and "ab cd". these 2 records are of the same product but they wont land one below the other if sorted alphabetically.
is there a way i can group approximately matching entries together with respect to 2 columns. one column would be the product name itself, and other would be the price.
the price column would always have the same value for a single product listed multiple times.
i have a price list. alot of the entries are duplicate. my main objective is to remove the duplicates.
but just removing duplicates with the default function is not what i want.
i tried sorting the column in alphabetical order but that doesnt help completely. as there some entries of a single product which are named differently (basically a space between or a minor spelling mistake). in this case sorting alphabetically doesnt help. example "abcd" and "ab cd". these 2 records are of the same product but they wont land one below the other if sorted alphabetically.
is there a way i can group approximately matching entries together with respect to 2 columns. one column would be the product name itself, and other would be the price.
the price column would always have the same value for a single product listed multiple times.
