exact

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...

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...

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...

I wrote a macro that allows a user to input a date of their choice in the Format: MM/DD/YYYY and I want to make sure they follow that exact format. Is there some code that will allow me to do just that? Thank you!

I'm using the NOW function to give the time in cell A1 I thought it would be easy to highlight the row which corresponds to the time, by EXACT matching A1 to the column B... but it's not working! What's the best way to get this to work? Thanks for your help!

It seems that nearly all of the macros I coded in the previous version of Excel have had some significant performance degradation since we migrated over to 365 and windows 10. Even simple code to just select, copy, and paste takes an inordinate amount of time to run. The exact same code runs...

Hi, I receive a data set every month and want to verify if the rows in the new data (one row at a time, so by starting at the top say A2:X2), match with a row in the previous data. However, the tables wont be the same length each month, so I can't just select the respective row in the prior...

Hi All I have the following formula that references a row that contains a two digit code, that then automatically imports data into another worksheet based on that two digit code. The problem I have is that this two digit code can be GD or Gd and mean two different things. Am I able to...

I simply want to conditionally format a number in one cell if it is at least 2 times (or More) lower than the cell to the left of it. Here are my exact layout grid numbers. What would be the exact formula for this? So K7 is 2x's LOWER than J7. I want to format it a certain other color ...

I have two pieces of code. They are both subroutines. They have the exact same coding up to a certain point but the 2nd one is giving me a "type mismatch" error. I don't see why it's reacting differently to the EXACT same coding!! Sub DeleteSeqCol(HeaderCount%, HeaderNames As Variant)...

HI, I would like a formula that could find certain exact words ( 2 - 5 words) in a paragraph, and returns with values. Eg 3 exact words found in a paragraph, return values = 3 thanks....

Hi. I have a basic VBA script in a workbook of about 11 sheets. Right now the below script is running on the “financials” worksheet. I need these exact columns hidden in two other worksheets (“Total Financials” and “Current Deal”) but was hoping it could be run off of the exact same cell E9...

I am trying to get this array to work. =MAX(IF(Submissions!$K:$K=Sheet1!$A2,IF(Submissions!$P:$P="*"&Sheet1!$P$5&"*",Submissions!$M:$M),)) I believe the P5 element is incorrect, but I can’t get it towork, I am looking for the latest date in column M, when column P contains theword in P5. If I...

Hello - I have the formula below but want to add ability to catch if B7 is not an exact match due to letters being lower or capital. i.e. ABcDE would not match ABCDE. I tried to add TRUE and EXACT terminology into the formula but could not make it work or I had it wrong somehow... ugh. Any...

<tbody> Joe & Sue Smith 123 Main St Chicago, IL 60601 Lets say I have a large column of data in this exact format. Any way I can separate this out quickly in excel into a name, then address, then city, state, zip formats? </tbody>

Hi, Is there any way that you can solve the exact value of a cell say E9=21.09 using goal seek. I assigned a button for a macro that solves the value of a E9. The problem is for example I input a value say 5, goal seek will return a value of 0 for E9. Hope i could assign a restrain say...

Hello, I have two formulas that calculate the exact same numbers, however I'm getting two different results. First one is as follows: =('CONBUD - SUBS'!AF7-'CONBUD - SUBS'!BV7)*('CONBUD 1'!BA9/'CONBUD - SUBS'!BH7) Translates to: =(5727010-5703134.04249506)*(63710728.16/5727010) Answer...

I am trying to match multiple columns. I have data in columns c&h, there are 23000 rows and I want to find an exact match in columns s&v and there are 1200 rows in these columns. example column a column c column h column n...

I am looking for a way to extract unique exact values from a text string. I have found way to get multiple values but they are not exact. Examples: A1- Unique Values: 19 20 35 40 B1 - There were 40 cats who ran up a tree in 1920. C1 - Result: 19 20 40 I would need the result to be 40...

=SUMPRODUCT(SUMIF(ABQSTATS!$A:$A,ALFONSOABQ,ABQSTATS!K:K))+SUMPRODUCT(SUMIF(GJSTATS!$A:$A,ALFONSOGJ,GJSTATS!K:K))+SUMPRODUCT(SUMIF(DENSTATS!$A:$A,ALFONSODEN,DENSTATS!K:K)) So this is looking for R8 as part of the named range but also finding R80 and matching and summing both numbers. How do I...