blank

Hello, I have a sheet that I've created a blank row after each change in Column J. I need to have column P in that row to have the formula, but dynamic values for the column O should be dynamic : =ROUND(COUNTIF($O$2:$O$1007,"Late")/COUNTA($O$2:$O$1007)*100,2) at each blank line. I've got the...

Hello: This is my formula =[@[UPGRADE MRC]]-[@[CURRENT TOTAL MRC]] When the upgrade MRC cells are blank how can I make the result blank? In other words there would be no difference because there is no upgrade MRC. Do I need to add a , "" or a ISBLANK I tried ISBLANK and it produced false...

Hi, I have a formula where I am checking if a cell is blank = if(a1="","",do math) I am then applying conditional formatting to cells above a number. Any of the cells that are true or "", get applied that conditional formatting even thought it is blank. Any ideas? I do not want "0" to show in...

Not sure why I keep getting an Invalid Syntax error for this formula. I want it to return "Complete" in the cell when StepsDetailOpen column cell is blank. Below is the formula I'm using. Any thoughts?? Steps Detail Status: IIF([StepsDetailOpen]" ","COMPLETE")

Hi, I have the following formula which almost does what I want it to. =SUMPRODUCT(COUNTIF(B8:DG22,B8:DG22)-1)>0 However, in the range B8:DG22, which is made up of 5-digit numbers and the word "Blank", I want it to tell me if there's any duplicate entries in the range but ignore the word...

Hello, I have one cell which contains 4 different words and want to do an if statement which shows when the word comes up then leave a blank cell. Please reply with if statement. Chris

Hello I have 3 cells I would like to check if blank So if Cell B19 is blank check Cell B25 if not blank multiply B19*15 (then equation is done if its not blank, if blank go to next cell) If B25 is Blank go to Cell B27 if not blank multiply B27*10 (then equation is done if not blank, if blank go...

Hi, i want to create a vba where i have a cell which when i put a value from a range it brings me back value in a cell that has a formula if from another range it yes . if it's no or blank don't bring anything. here is the example. Run the code and in column D if in B1 is Yes then put the value...

hello everyone, i have a big sheet and data fetch from other workbook via vlookuop where i have blank cell in base sheet, results are 01/0/1900. i need to fetch month details but bcoz of this it;s showing january which is incorrect. kindly help me to get the month result "0" or blank if we...

I have an attorney billing template in which I enter data as follows in one cell: Office conference with Blank Client regarding freight damage [1.25]; review documents provided by Blank [1.5]; memo to file re potential case [.5]. I would like a formula or way to have all the numbers inside...

Hi All, I want to post to the first blank cell in Row 'L' after L3, but it is pasting to B3. Any correction pls?

I need help with simple VBA Code. I have a SAP BW Excel Extract. In Row 3 there are are column headers of ten Depts. Each Dept's name occurs four times. I want to find the last occurrence of each Dept's name and insert two blank columns for each Dept. All the first blank column's header must be...

What am I doing wrong I am using this formula in cell E7 successfully =IF(D7-C7<0, 1+D7-C7, D7-C7). But when cell C7 has no data I do NOT want ‘0’ to appear in E7. I have tried various formulas including this one =IF(C7=””,””,D7-C7<0, 1+D7-C7, D7-C7) but it doesn’t work. Can someone please...

I am trying to concatenate unique column text into a single cell. After spending an afternoon researching, I can now concatenate all the text in different column cells and remove duplicates. However, if one of these cells is empty, I get a blank value. as an example, I want to concatenate all...

Hello, Im looking for VBA to input a formula into a cell based on the cell value next to it. If the Cell value next to it is blank it shall stop. I have the below which loops and stops when a blank cell is found, but I need it to perform an action. Sub DoWhile_Loop() Dim BlankFound As...

Hello all, A1 on sheet Log, will be a Month and Year only (Mar 2019) A2 Should be first day of the month selected in A1, Col A will have all the next dates of the month until the last 31st But what I would like is if I select Feb 2019 in A1 all the col A fill up until the 28th Feb (Cell A29)...

I have 2 columns (K and L) with the dates in the format: 08/27/2019 & 08/29/2019. I want to use a Concatenate formula to have the end result showing: Aug 27 - Aug 29. The formula I wrote is as follows: =CONCATENATE(TEXT(K3,"[$-409]mmm d;@")," - ",(TEXT(L3,"[$-409]mmm d;@"))) However this...

I'm looking to change cells to blank if their content is greater than 30 using VBA anyone know how to do this please

I am trying to write a formula to total data in column C and column E (C+E) only when C or E have data. In other words, when C and E are blank, i would like the formula to return "-". When C or E have data, including a 0, i would like the formula to add C+E. My only experience with sumif is...

Hi I have been sent a multipage spreadsheet with thousands of rows. Many rows are blank/contain no data and appear randomly throught the sheets.. Is there a shortcut to delete/hide all blank rows. I do not want to highlight them all individually and format/hide Thank you