# exact

1. ### Check Row Matches a row in an array

Hi All I have 2 workbooks and i want to check if a row matches another row in another book. Lets say in Workbook1 you have the following Workbook 1 Workbook2 A B C D T Y U O W E R T A B C D I have the following formula but its not working...
2. ### How to get excel to ignore letters in a cell

Hello All, I have a data set where I need to match some numbers with each other but they have two letters in front of them that make it currently impossible to do. So for example I have: CP2003 in Cell B2 and RD2003.001 in Cell C2. I would like to know how to get a formula that matches just...
3. ### Substitute Exact

Hi All i want to be able to find an exact match when using substitute, not sure if possible. I currently have the substitute formula working fine up until cell A10 =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(E5, A5, B5), A6...
4. ### EXACT Function to ignore blank / empty cells

Hi All, I have the following formula that works when I just look at a list of populated cells, but as soon as the list contains blank cells it then fails and returns 'In Progress'. Is there a way that I can ignore the blanks? My formula is...
5. ### Calculate EXACT number to achieve an EXACT percentage

I know the exact % I need to achieve. In this example column G2 is the target % of 67.201%. G2 = 67.201% (This is the target %) D4 = 4,250 (This is the number I need to increase to meet the percentage. The amount I need it to be is 4,681 for a difference of 431) As the percentage of G2...
6. ### VBA / AdvancedFilter exact result

Hi, I put a filter with AdvancedFilter. For some search strings I get to manz results. So f.e. for "John" I get also"Johnsson", "Johnson" etc., everzthing that fits to John*. I know already by using the string ="=John" that I would get ONLY "John" like I want. But my Subroutine has not a...
7. ### Find last exact match in column

Can someone show me how to find the row number last exact match in column C? The values are all numeric, so it needs to be a precise match and must be the last value found as there will be duplicates. Sheet1 <tbody>#cacaca[/URL] "] C #cacaca[/URL] , align: center"]1 1234 #cacaca[/URL] ...
8. ### Vlookup ---> then QTY Extact match or Greater Qty

Hi All I'm trying to build formula to lookup one column (Product) (has Duplicate value in Table Array) and if "Product" matches with lookup table ("A:B") then ---> it should look for Exact Qty or Greater Qty (column B) but the first preference is "Exact match" for reference I have uploaded...
9. ### Search a string in one cell for an exact match of a value from another cell

I have a formula that searches a string of text in one sheet, and sets the value of the cell where the formula is stored based on the true/false boolean results. The problem is, it will return true when it is a partial match instead of an exact match and I can't seem to find out how to only...
10. ### help tweaking my formula ifna match index

{=IFNA(INDEX(PO[Price],MATCH([@[SO Date]]&[@[User Name]]&[@[Item No.]]&[@[SO Qty]],PO[Posting Date]&PO[User Name]&PO[Item No.]&PO[Quantity],0)),INDEX(PO[Price],MATCH([@[Item No.]]&[@[Cost Exact Match]],PO[Item No.]&PO[Sales Exact Match],0)))} My formula works but I know it should be written...
11. ### VBA Macro to paste the values with row and column alignment automatically.

HI Everyone, I need a macro to align my results in same sheet according to last maximum used rows from multiple columns. I have given image link that how am expecting result that will give exact idea. Please check and do the needful your support will be very helpful for me. Image link given...
12. ### Changing Numbers for security purposes

Hi, I have tens of thousands of item numbers. At time I need to circulate spreadsheets that contain them. However, there are times where I do not want people or organizations to know these exact item numbers. Is there some tool, function or script that can change these item numbers to another...
13. ### SUMPRODUCT and EXACT problem

Here is the formula i am using and it is working. =SUMPRODUCT(--((\$A\$56:\$A\$300>=3))*(EXACT(S\$56:S\$300;"AE")+(EXACT(S\$56:S\$300;"BE")+(EXACT(S\$56:S\$300;"RB"))))) I have a value that has to be >=3 in A56:A300. And i have two letter code in S56:S300 that might be AE, BE, qB, AB, BB, RB, PB ...
14. ### instr to get exact match

I have this line of code, but I thought it was to get exact match. How can I get the exact match? If InStr(1, Cells(RowNum, 1).Value, "BA", vbTextCompare) > 0 Then
15. ### Exact function

I am trying to compare A to B cell with exact function. The problem is when there are two empty cells it returns me TRUE. I would like to return me number 0. Thank you in advance
16. ### Index match & countif

Hi, Do you know how I would combine INDEX MATCH with COUNTIF I need to find a match for D5 in range I4:I86, once that match is found, I need it to then COUNTIF on that exact row vertically for any "H". Any ideas? Many Thanks
17. ### IF EXACT Formula with multiple chains

Hello, I am attempting to do an IF/EXACT formula that contains two different values. Here is the formula that I've come up with, but it keeps returning a #N/A value: =IF(EXACT(G2,"B"),"Btl"),IF(EXACT(G2,"b"),"btl","")
18. ### Check External Cell References in Row for exact match excluding blanks/zeros

Hi all, I'm just writing as i'm struggling to work out how to check a row that cells match exactly whilst excluding any blanks. The thing that complicates this is all values are pulled in as external references from various other worksheets (L-Q in below example). I have done quite a bit...
19. ### Compare entire rows in excel - looking for exact duplicates in the rows.

I need a macro or formula that will compare the cell values in a row and if all the cell values across all the columns are EXACTLY the same (excluding formatting) then they mark a specified column as true and filter the spreadsheet with just those rows. In essense, I'll looking to filter based...
20. ### Index-match return exact match, if not closest match

I have this formula : INDEX(A2:A20,MATCH(1,(F10=C2:C20)*(F11=B2:B20),0) It returns the exact match. I need the formula to return the closest match if the there's no exact match this is my data : A2:A20 I need to find the PO that is closest to the date 19-03-17 , the result should be : P91180...

### This Week's Hot Topics ### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?    ### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option. Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com". Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button. Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button. Go back