blanks

I am not very good with excel and need some help. I have searched but not finding what I need. I am trying to figure out a simple formula that calculates multiple cells while ignoring blanks or any other text for cell D. I was trying to use isnumber eg... =IF(AND(ISNUMBER(A2)...

Hi I have a table where I want to either show 'blanks' or show 'all'. The below code just keeps it on showing blanks. Can anyone help to add a filter if not applied and then show all / just show blanks based on field 5? many thanks in advance Private Sub ToggleButton1_Click() If...

Hi, I have a table which contains data in Col A (Part Description). I have a cell which I need to look at Col A, if Col A = Desc1, look in Column N and count the non blanks. Is there a function out there to do this? Thank you.

Hi, I have a table with data generated by formulas. When using the sort function in the filter I get lots of blanks between all values. I can not uncheck blanks in the filter since it will remove other information on the same row that is not related to the table data. Any tips?

Hi, My formula is in column C. I need to count all the multi-drops, leaving out the blanks. Once row with Column A "First Line" and Column B "Multi-Drop" are meet, restart the count. This is the formula that i have on Column C <code style="margin: 0px; padding: 0px; font-style: inherit...

I want to show that IF D:D= Yes then column E will show Pass, IF D:D=No then column E shows Fail, but ignoring if D:D is blank. HELP PLEASE!

Hi On sheet1, column B, I have a list of reference numbers. In sheet2, column A these may or may not appear. In Sheet1, I would like the Cell in Column B highlighted IF it does NOT appear in Sheet2, column A Blanks should also be ignored Many thanks

The below formula only works with an array. However there are some #N/As. And when I try to add IFERROR using the second formula all the found matches turn to blanks. Any ideas what I could be doing wrong...

I have a sheet called "Sales" I want to filter all the columns in row 5 which contains the headings and then filter all the values in the column where heading is "imported Shirts", excluding zeroes and blanks I have tried to write code to do this but cannot get it to work Sub Autofilter()...

Good Morning, I am terrible with formulas and was hoping to get some help. I'm trying to create a formula that counts blanks as well as any cell that contains these characters ("O", "TR", "LD", "D"). I keep getting a too many arguments error. Is this even possible? Here is what I thought the...

Excelites I'm using formula to state whether or not A3:D3 are each populated with a 'yes'. IF(AND(A3="yes",B3="yes",C3="yes",D3="yes"),"yes","no") But I cant work out how to write the formula so that if all of those cells are blanks then the formula should produce a blank. Would appreciate...

Hi all, I have a formula which returns an average number of orders placed per weekday which works nicely. The only problem is that it take blanks into consideration so the average number is really low! My formula is {=AVERAGE(IF(WEEKDAY('Data Range')=2,'Data Range'))} What do I need to add...

Hi all, I just want to try the below request in VBA. Is it possible. > Filter blanks in the Column "Work" and update as "Issue" in column "Remarks" > I just wanna update as "Issue" based on the usedrange column A. Thank you.:biggrin:

All, Trying to make so graphs with dynamic ranges using name manager. should be easy but I am missing something. I could fill all blanks In with 0 and it works but not without it. Here is what I have column B is a date June 2018- now and it always grows with each new day Column G-U is a...

Good afternoon, I have a excel database which is daily enteries of the amount of oil consumption from a machine. These enteries can also be blank if that entry was just a check, and those values are required to be ignored during the following steps. I would like each row to check the oil...

I have a data dump which results in blank cells in column H. The dump also brings in batch numbers in column I. I want to fill the blanks in H based on a non-blank string based on the same batch number from column I. ie: Column H Column I ach123 29874 38813...

I'm hoping this is an easy fix. I need a formula that will average data in a column if a column contains x or y. Currently I have: N22 ={IFERROR(AVERAGE(IF((SEN={"n",""}),KS2A)),"")} However, this is returning 4.49 when it should be 4.83. It might be converting blanks to 0 hence the...

Hi, I am running a MACRO in sheet2 by clicking on a bottom on sheet1, all of my code is working very well, except here: .Columns("H2:I20000").SpecialCells(xlCellTypeBlanks).Select .Selection.FormulaR1C1 = "=R[-1]C" What i am trying to do here is to tell excel to go to Find & Select >...

Hi all, really need your help I have a series of values and blanks randomly distributed in one column and I want to set up a formula in the next column which looks at the first column and says, if there is a value in first column then take that value, otherwise if there is a blank then use the...

For the formula below do you know of any way formula could be updated so that the sheet can automatic sort by the qty so the zeros or blanks rows would not be shown =IF(OR(G13="",Input!G13<=0),"",Input!H13)