help! guru needed

Hi All, I have inherited a sizeable spreadsheet from a predecessor and need to clean it up to enable me to convert it to a CSV file our our CRM system. The problem is, she has entered all of the telephone numbers into one column and i need to distinguish between landlines and mobiles. Is there...

I'd like to know what kind of formula/what is the formula to have Excel figure something like this out: Say A=7 B=12 C=30 D=Scaling(1-100) Like a unit's level And it will make Q=((A*B*C)+(C*D(also D-1, etc)) like an Arithmetic progression. Where D is Q/((A*B*C)+(C*D(also D-1, etc)) So for the...

I have a worksheet that has 18K rows. Column A is numbered and the values repeat themselves various numbers of times. I want to count the values in the adjacent column and restart the count each time the values change so: 4 1 4 2 4 3 4 4 4 5 4 6 5 1 5 2 5...