Get instant live Excel expert help with MATCH Functions

I want to upload sales leads into our CRM software. However, I don't want to have duplicate leads, or that we have already entered in. To avoid this, I must remove duplicates, however names are not EXACTLY the same. (example the lead may say "MOUSE COMPANY" and the sheet may say "MOUSE COMPNAY INC". They are the same, but wont be recognized immediately by excel as duplicates) I want to be able to remove duplicates if the first 5 letters are the same. The rows i want to compare are row C and I of first sheet (new sales leads names) and compare it to row E on sheet 2 (this is our existing customer database) and end goal is all unique names.

I am looking for a way to compare a detailed expense report with a very simplified budget report, what would be the best way to go about this?

I'm having trouble with vlookup two values. I need help to fix a logic check formula to compare two values, but pull one as text *1 to take formatting into account. I'm attempting '=IF(INDEX(TEXT(A16,"0"))*1)=(INDEX(C16)),"CORRECT","FAIL" but a VLOOKUP might work as effectively Relates to a significant excel bug - see sheet

i need to compare two excel file one file have 3 (a,b1,c1) columns and another one have 4(a,b,c,d) columns there is one column just the same in each other(b1 and c1 is updated data of the a and b).how can i extract and file like (d,b1,c1)

I have a pivottable chart and i would like to see the % of a category within a parent category and compare it to the same category within another parent category (i.e. females in dog and child condition). My problem is, the data keeps updating to reflect the percent total from what data is shown. When filtered the numbers change giving me 100% in each.

I need to do a month to month compare by product

Count the number of times each 'Type' of customer sale appears in Column A (on sheet 'Customer Orders') from 1st Of September 2018 to todays date, and compare for same period last year. The formulas need to go into the 'Orders' worksheet with the ?. The dates are referenced in rows 10 to 14 of 'Orders'. (the count must change as todays date changes!). Tks

Complete the data table in the "What-if Analysis" section of the worksheet to compare the net profit for various values of the attendance forecast and the arena fee. [34 points]

HI, I need to verify that a formula I was given is going to work correctly. I have a 200K row spreadsheet and the results are not producing what I expect. In a small file that was used to test the formula, it appears to work. The formula is =SUMPRODUCT(($A:$A=A2)*(B2>$B:$B))+1 I need to take value in A, compare it to value in B, and then in the next column, rank the items in B numerically. However, the values in column A and B frequently change. So there may be results 1, 2, 3 or 1,4,5,3,2 (I will need to sort to get the results in numeric order). I do know sumproduct is an extremely resource intensive formula.. Thank you.

Example: Log diameter is 48cm (known) Dropdown list has ranges (centimetres) 40-49, 50-69, 70+ Dollar values for 40-49 is $10, for 50-69 is $15, for 70+ is $20 I need a formula that will see the log diameter, compare it to the dropdown list range and apply the correct price. Please Thank you Mervyn