how can I convert then match two lists of numbers? One list has thousands of 7 digit numbers. The other list is even longer, but contains all of the numbers in the first list, looking at the first 7 digits of each. The difference is, the numbers have an additional digit on the end.
I know there is a way to rank a list without using the "sort" feature in excel but rather formulas. I need to sort the list of 25 items below by the first column with the highest value first. What formulas do I use? Thanks for the help. Weight Management 65% 74% 67% 84% 75% Healthy Heart 46% 24%...