blank

I am looking for a quick VBA solution. I have a range of numbers (not consecutive) in one column, 881 to be exact. I need to insert 146 blank rows in between each number, then move to the next number in the same column and then insert 146 more blank rows, until I reach the end. Does anyone...

I have a table of data which is broken up by a number of blank rows at irregular spacing. I need to find the row number of the next blank row after the last occurance of a string in col A---which can be somewhere in the middle of the data table. I've got the row number of the last occurence of...

Hi, I'm trying to figure out a formula that has a number of parts. Let's say that we have columns A, B and C. Column A will contain either a date, or be a blank cell. B will contain "Accepted", or a blank cell. I want Column C to return either "Open", "Approved", or be blank, depending on...

I have a large spreadsheet that I have pasted values into from another worksheet (I literally used 'paste values' from the context menu). The sheet I'm pasting into is set up with drop down menus that the data i'm pasting needs to match. I am attempting to us data validation circles to find the...

Hello all, hope you can help me on this. Since I cannot attached any spreadsheet I will have to explain it a bit... Row #1 are the headers of each column Column A contains agents' names. However, a lot of the cells are blanks since this is how the cleaned up data I will be getting. For...

i am hoping someone can help me with an IF formula that has multiple conditions. I have tried a few different ways but still I cannot get it to work. What I require is if A2="0" then return a blank if L2 ="0" then return a blank If A2>L2 return "Late" If A2 is <=L2 then return "on time"...

I have a large spreadsheet that I have pasted values into from another worksheet (I literally used 'paste values' from the context menu). The sheet I'm pasting into is set up with drop down menus that the data i'm pasting needs to match. I am attempting to us data validation circles to find...

I currently have a filter formula that works great to pull my data; however, I was wondering if there is a way to make it give show something different than what is pulled? Currently it pulls the date of install and I simply want it to be a check box. Is it possible to make that happen in the...

I need a formula that will calculate two dates Sample In Column K put the number of dates between the Starting Date (I20) and Ending Date (J20), but if I20 or J20 is blank Leave K blank

Hi all, I am trying to remove rows based on if a cell in column C is not blank for that row. Ive searched multiple threads but nothing is seeming to work for me. I have this one below that works great for removing rows where a cell IS blank. But I need to remove if the cell actually contains...

Hi there, Using the IF function, I'm simply looking to return the contents of a cell only if it has text in it. I thought the Logical test might be; IF A1 = " " This is clearly wrong. Can anyone assist please? Also, if the cell is blank (False)then it currently returns a 'zero'. I would...

Hi, I'm trying to get a table to always have a fixed number of blank rows in a given column, this is to make sure that my helper table always contains all the data available. I think it should be something like a macro that counts the blank cells in a given columns and adds a column if the count...

Hi, I'm trying to return the value of a couple cells, depending upon whether or not they contain a value. I'm using the formula below: =IF(OR(IF(NOT(ISBLANK(SEARCH($BP$2,B2))),$BP$2,""),IF(NOT(ISBLANK(SEARCH($BP$3,B2))),$BP$3,"")),"") The idea is that either BP2 or BP3 will contain a value...

hi all.. how to make average formula exclude 3 criteria text, blank cell, zero (0) =IF(COUNT(H8:T8);AVERAGE(H8:T8);"") but still not fully working thanks in advance.. .sst

Hello all, I am calculating multiple text boxes on a user form and the code i am using seems to be working out okay. The problem i'm having is if I tab into the text boxes that have the code to multiply and divide are left blank are giving me a error message. Some days I may leave those text...

Hey! I need to combine 3 spreadsheets into a big one but I dont know how long each one will be. What I have so far is a short macro that merges them together and then deletes the blank rows between each other, but his seems very clunky. Anyone has a quick fix for this? Thanks!

I am trying to figure out how to build a macro to spot missing sequence and add in a new row when found. There should be 1440 data points in column A The date and time formatting goes as followed 10/10/2019 7:41 10/10/2019 7:42 10/10/2019 7:43 10/10/2019 7:44 10/10/2019 7:45 10/10/2019 7:46...

Hi, Any ideas why this simple formula wont work: =IF(COUNTBLANK(I10:J10),"",NETWORKDAYS(I10:J10)) ? Many thanks

I have a formula that adds up information between 6 worksheets. If there is no information greater than ZERO in either cell I want it to be BLANK but it returns 0 =IF(OR(F3>0, O3>0,F3-((IF(SUM('Week 42:Week 52'!P3)>0,SUM('Week 42:Week 52'!P3))))), " ") Cell F3 is just a standard number, cell...

Hello, I have a dataset corresponding to snowfall sum per day, for a number of years (30+). There are often blanks for certain days. Where there is a blank day in a month, I wish to set the entire month (every day in the month) a value M (for missing) or set the entire month blank, either is...