multiple cell comparison

Hello, I have a large spreadsheet that I use to find patients that have had a procedure outside of their admission and discharge dates. The spreadsheet has worked perfectly until 1/1/2020. The conditional formatting formula I am using is: Cell Value ---> not between ---> J7 --->...

Hi experts I am new to vba and looking for a way to modify data in a large file (extract below) as explained below. <tbody> Record ref Date created Type Stage Status Department Client Cost Price AAM000001 01/04/2015 APP Closed - Funded Application v1 - Approved CEEEE FUN00023 487,993.00...

Ok here goes....I have a spreadsheet with multiple data charts. I need a formula (for column J) which searches through column C for a specific text (which could occur in any or all of the cells), and when returns true, adds the numbers up in the correlating cell in colum d. Example C...

Hello everyone. I am new to this, please bear with me. I hope I am phrasing my question well. Thanks for your help in advance! I have a spreadsheet with hundreds of URLs, and buried somewhere in that URL is a product code. Convention is not the strong suit here, so the code can be anywhere in...

Hello everyone. I am new to this, please bear with me. I hope I am phrasing my question well. Thanks for your help in advance! I have a spreadsheet with hundreds of URLs, and buried somewhere in that URL is a product code. Convention is not the strong suit here, so the code can be anywhere in...

Hi.. I have a table with entries like (Example from table, real table is very large) - <tbody> Length Width No 300 300 50 600 200 30 900 600 10 250 450 25 </tbody> I want to extract information where if I give a number for length and width the query can tell me all possible...

So I've applied conditional formatting to columns A and B to highlight and bold any blank entries. However since those guys tend to show up a thousand rows or so down I don't have anything to alert me that there is a problem. I know that I can just filter those columns to check but I'm not the...

Hello excel gurus, I've got a sheet that I need to get the average % from in (column R). Obviously, I could easily do this: =AVERAGE(R29:R35). However, I need to also check another column (column J of the same rows) to see if there is any data in the cell. If the cell in column J is blank, I...