blanks

Hi, I have data in columns B2:B9, D2:D9 and F2:F9. Some of those cells have blanks. I would like to combine them into one column in starting in J2 and ignore the blanks. I know this is an array formula, and can get one column to work with this...

What would be the VBA code to find the last "X" in a column starting at cell E4 and looking as far as E350? Assume that the X's will be continuous from E4 without leaving blanks until the end. Is there also a formula that could do that?

Hello Does anyone have any nifty code that will Go To Special (Blanks) then delete entire row - all in once action? I guess you;d either need to select the column first or prompt the user to select the column when running the macro? Thanks

I am trying to write a formula that will ignore 0 or blanks with the sumproduct function. My current formula is =SUMPRODUCT(F47:F53,G47:G53)/SUM(G47:G53) Now I need to ignore 0 or blanks in this formula to make it work correctly. Can someone help?

I started a job where a weekly cash update spreadsheet is reported to corporate by one of it's entities. The worksheet has a column for every day of the week with the top section for cash receipts and the bottom for payments. It is very cumbersome. So, I created a data table for the entity to...

Hi all, I need a macro with the following requirements. 1. I need to filter blanks in columns U and update those blanks as BRANCH. 2. I need to paste as blanks only for the used range in a column :)

Hi all, I have been trying various formulas without success. I need to conditional format a range of cells, say A1 to G1 to highlight the minimum amount excluding any blanks in that range. I just can't do it and it's doing my head in! Any help is greatly appreciated. Fo

HI all, I have a macro that copies a list of emails addresses into an outlook email. Recently outlook replaces some of the emails with a blank so for example it shows in the "to" as: janedoe@hotmail.com; george@gmail.com;;;;; fpenner@aol.com;; gina@msn.com;; Where in between each semicolon...

For months I've been filling alternating blank rows by: 1. Selecting the area to be filled 2. Clicking on Find & Select - Go to Special - Blanks 3. From the automatically selected first blank area, typing =, then up arrow, and pressing Ctrl, Shift, Enter In the past, that combination has...

I have same data points from equation =IFERROR(K3+Q3;""). When I plot these numbers and "" blanks into scatter plot, "" blanks are treated as 0 numbers. Is there any way to prevent that?

Hello, I was wondering if there is a way to jump to the bottom of a cell range if you have blanks in between. Please see my example below, as I would like to get from 5 to 4 in one shortcut. I know Ctrl + down arrow goes to the end of the cell range if there are no blanks, but was hoping to get...

In cells K2:K9 I have values but sometimes there are blanks . For example in this particular case only have values on cells K4:K6 (K4=925, K5=755, K6=900). The formula {=TREND(K4:K6)} works fine and returns 872.5 for the first value on L4...BUT I don't know which cells from K2:K9 will be...

Hello all, I have a head scratching question in Q6:Q35 I have Data with Blanks (Theres is a formula here but has text) - These Are names in R6:R36 I have Data with Blanks (Theres is a formula here but has text) - These Are names in S6:S36 I have Data With blanks (Theres is a formula here but...

Hi all, Really basic excel user here with help needed on something i'm sure you'll be able to do within seconds. I have a column that has numbers in it generated from a formula. Some of the cells in the column have blanks as a result of returning " " when the the formula didn't match. I want...

I have 3 years of data organized Q Column Row1 January Row2 $ Row 3 $ Row 4 $ =sum(offset(Sheet1:Table 1::$Q$4,0,0,(COUNTA(Sheet1:Table 1::4:<wbr>4,"<>0")−12),1) I am trying to do a rolling total for 12 months which does not...

Hi All, I have an array formula on one sheet that is populating a list of results which I am using VBA to copy and place into a specific position by copying the entire named range the array is in. The problem I am having is that when I Paste as Values, the blank cells that contained the...

Hi, I'm hoping to create a VBA macro in excel to automate a task of deleting rows if they contain a zero in columns AB and AC. However I do not want it to delete blanks. Can anyone help? Thanks!

I have following code: With Application.ActiveWorkbook.Sheets("Requests").Cells(4, 4) .FormulaR1C1 = _ "=COUNTA('\\ad.com\TEAMS\TOOL_ADMIN\04_Requests\" & "[" & xFile.name & "]Request form'!C1)-5" .Copy .PasteSpecial xlPasteValues End With How can I change...

Hello, In my score sheets, there are often blank spaces left in between other cells that need to be zero. I know of the find/replace function that can substitute blanks with zeros, but that will substitute any blank cell, even those that are after (to the right of) the last filled cell in each...

Hello, I have some code that copies and pastes data from cells in certain workbooks into columns in the main workbook. When running this, the ary 0-3 seem to be mixed in order when pasted and come up with some blanks when there are none. I do not have the code available at the moment but I...