if statements

Hi, I'm trying to filter a sheet using a userform, the user clicks a checkbox on the userform and the filter is applied immediately. It was working fine until a number of columns need to be filtered with the word "Valid" instead of just not blank. If the Checkbox is selected, check if that...

Hello excel experts, I have annoying (crappy) data, and I am trying to grab all names from a column that meets a couple criteria. In that column are subtotal rows with a count of names and a TOTAL heading, and category headings like: - 2020 Sold Properties - 2020 Completed Refi - 2021...

Hi Guys, Absolute VBA beginner here. I have been researching to find out how to do the following but to no avail. I have created a book with 12 months which has columns containing data. Please see snapshots I have added. New entries are being added to these lists via index match formulas...

Hello all! I have a spreadsheet at work that the techs enter in on/off times for equipment. I need to know how many hours the equipment has ran that day. <tbody> Date Initals OFF ALL DAY? ON ALL DAY? INITIAL SHUT DOWN INITIAL START UP SECONDARY SHUT DOWN SECONDARY START UP 5/1/2019 BB...

Good day! i have a table with 4 columns. col1 col2 col3 col4 Please help me with a formula that outputs the following: col1=empty & col2=empty & col3=empty & col4=empty => output a col1>0 & col2=empty & col3=empty & col4=empty => output b col1>0 & col2>0 & col3=empty &...

Hi All, Hoping some advice as I am not sure whether to use Excel or Access (I'm better with Excel than Access) to auto populate a cell based on multiple tables. I'll explain how I thought it may work in excel - I just want to see if this would be easier/better in Access or indeed if there is a...

I'm creating a spreadsheet to detail the fire door ratings based on the fire strategy and a physical survey. A straight forward exercise where the door is not fire rated (NFR), fire rated for 30/60 minutes (FD30/FD60) or fire rated for 30/60 minutes with a smoke seal (FD30S/FD60S). I want to...

Hi, Please could someone help me with an IF statement. I would like to write the below in an IF statement if possible. scenario: Total number of items = 39 For each item that is failed, 0.01 point deducted per 0.01% that the item is below 99.5% but above or equal to 96% and For each item...

Hi Guys, I am currently making a macro for a button to log queries, I tried to use an IF statement to check if the desired cell is empty, and if not, record the comments on the next cell to the right but it doesn't work, please any help would be much appreciated. See below: Option Explicit...

Hi There, I have a table with hospital admission date (column A), discharge date (column B), and a third column that calculates the duration of stay (column C). Sometimes, people forget to enter data for either the admission date (column A), or the discharge date (column B), or both (columns A...

I am hoping somebody can suggest a simplified version of what I currently have. I am tracking time spent on a project by other team members and have an extremely over complicated way of working out the costs. I created a user form for inputting the hours to make it simpler for the team and...

I have code below, works fine but notice the if statements and how it loops through two worksheets separately but ultimately does the same thing.. any ideas / advice feedback on how to make it more efficient if possible? I'm pretty new to VBA so this was the only way I new how to do this. Thanks...

I'm using this formula: =IF(D10>29,$D$3,IF(16<d10<29,$d$4,if(d10<16,$d$5))) For the 1st and 3rd 'IF' logic statements, the result is returned correctly. When the second logic statement is met, the result is 'False'. The table shows what I'm trying to do: <tbody> <tbody> DISTRIBUTION...

Hi There, I have an IF statement that currently has 10 IF statements within...

Hello everyone, Thank you in advanced for your help. I would like to have a macro run when a workbook is opened but only if the current date of a cell doesn't match up with the system date. What I have Private Sub Auto_Open() Application.ScreenUpdating = False...

<tbody> Value: 4533 Ratio: Returned Value: 100 Fund Amount 100 4533 100 654654 100 357 100 84768 110 64 115 34 120 6154 200 56484 200 84984 200 6846 400 4564 400 564987 400 6848 500 687465 </tbody> I'm trying to sum the...

Hi Guys I am trying and struggling to create a nested IF statement for risk assessment that works this way: The risk factor is calculated by multiplying the consequence(ranges from 1-7) and probability(ranges from 1-9). Based on the product of the two the values can be categorised as very low...

Hi, I have a formula that pulls two columns of time together into a third column. The formula is in Column S and is: =arrayformula( lower(TEXT(Q2,"h:mm AM/PM")&" to "&IF(R2="","",TEXT(R2,"h:mm AM/PM")))) (for example if both columns are not blank, this generates "6:00 pm to 8:00 pm") What...

I'm trying to display which quarter throuout a shift an error was made. I can get Q1 and Q2 to work but for whatever reason Q3 and Q4 returns #Value! as the result. Formula...

I have an excel database of survey information that returns the 1st, 2nd, and 3rd lowest values using SMALL formula, but I applied an IF formula on the spreadsheet to return the statement that value is tied to. However, if the value is the same it returns the same statement twice, rather than...