blank

From this post: The OP's question was this: Why does the lookup range start with "1/"? What does it do? All I can think is that it really is meant to be a reciprocal, because the OP wants the previous non-blank cell - ? I experimented with removing "1/" and got an #N/A error. Also, if...

I need one more thing <d2,"in darkness",if(h8="D2,"Under" light",if(and(h8=""><f2),"under light",if(h8=""><d2,"in darkness",if(h8="D2,"Under" light",if(and(h8=""><f2),"under light",if(h8="">=IF(H8< D2,"In Darkness",IF(H8=D2,"Under Light",IF(AND(H8> D2,H8< F2),"Under Light",IF(H8>...

I have this formula <d2,"in darkness",="" if(h8="D2,"Under" light",="" if(and(h8=""><f2),"under light",="" if(h8=""><d2,"in darkness",if(h8="D2,"Under" light",if(and(h8=""><f2),"under light",if(h8=""> <d2,"in darkness",if(h8="D2,"Under" light",if(and(h8=""><f2),"under light",if(h8=""><d2,"in...

Hello All, I have a program where I declare some variables e.g. a number for a header of a column this program then calls another program that opens other workbooks and runs some code in the workbook and needs to references the declared variable in the "main program" to add into each workbook...

Hi there I'm working on excel template where column E formula would be =IFS(F8<$Q$3,F8*$P$3*$O$3,AND(F8>$Q$3,F8<$Q$4),F8*$P$3*$O$4,F8>$Q$4,F8*$P$3*$O$5) this is working fine, but when column F is blank it shows #VALUE !, how can fix this to show blank. also is there a way we can update...

Hi Everyone. I need a macro that can help me clean up my data range. We export data from our CRM system which is very old and the data needs sorting out before i can do anything with it. I've done most of the macros but am stuck and looking for help. I need a macro to help me empty out cells...

Hi all, I am having trouble with a nested if statement. I have several columns of data I need help with a formula that will look at the first column of data in column B if nothing found then go to Column C if nothing go to D if nothing go to E. If all the columns are blank then pull value from...

Hi All I have a formula that works in a table : =IF([@[GroupedCommissioned Weekly Cost ]]>750,"more than £750","Less than£750") <tbody> Grouped Commissioned Weekly Cost More Or Less than £750 Less than £750 £91.98 Less than £750...

Hello everyone, I am trying to make a spreadsheet that includes a calendar for task scheduling and the project details in another tab. Columns B and C in the calendar look something like this: <tbody> B C proj.1 task 1 (blank) task 2 (blank) task 3 proj 2 task 1...

I'm trying to count how many agents hit goal in a particular quarter. I've set up the following formula to see if the number in column B is greater than that in column H, subtracting if LOA is entered. My problem is it's counting blank spaces, totally throwing off my calculations, and I can't...

I have a sheet that has two columns - one with a name and the other a date. I use another sheet to show all results for a certain date. For example, sheet one shows: David 10/1/19 Adam 9/30/19 Mary 8/1/19 Jill 8/15/19 Mark 10/1/19 Sheet two then has a user defined date input. Say, for...

Hi there, I have a range, L1:Q50 - this is a 6 column range. I have data on some of the rows (for each row there is always something in column L, but not nessesarily in the other 5) I'm looking to move each row (of 6 cells) up so that there are no blank 'rows' separating them... I can't use...

Hi guys, Wondering if anybody a help with the following: I am currently using the following formula to return blanks when an error results from 'E25' being blank: =IFERROR(VLOOKUP(E25,'WORKSHEET'!$A$1:$S$1000,19,FALSE,"") However, when E25 is not blank but row '19' in '$A$1:$S$1000' has no...

Hello, I have a column that has a list of "0" and dates. I am looking for a formula that will return the Month name on any cell that does not contain the text "0" and if it has a "0" return a blank cell. Here is the formula I wrote but unfortunately it does not seem to be working...

I have the below but i also need it to count days between Out Date (H6) and Return Date (J6) if J6 is blank on G6 will have the day count using today date until a date is put in J6 =IF(ISBLANK(J6),"",IF(ISBLANK(H6),TODAY()-H6,J6-H6))

Hi, I created a macro today to rename two tabs. Since then, when I tried to launch excel, it doesn't bring a blank worksheet but it asks me if I want to open a new sheet or one of my most recent files. Is there anything under options>Advanced that i need to tick? to bring me to a sheet 1...

I'm trying to use the conditional formatting option to highlight cells where the value is less than 100%, (the cell values are percentages), but I need to ignore any cells that are blank. Can anyone help me please?

Hello Everyone, i have the following formula that compares 2 sheets and returns Yes Or NO. The formula is auto filled entire column. So if my data spans from AD3 to AD 80, i will have 8 rows of "No". iS there a way to blank this out? =IF(ISNA(VLOOKUP(A11, 'SP'!$AD$3:$AD$88,1,FALSE)), "No"...

Hi, I've got a data worksheet with over 1 million rows. I need to remove blank rows so that I can chart the data. The following code worked fine for worksheets with tens of thousands of rows but Excel stops responding when the data set goes into the hundreds of thousands of rows: Sub...

Hello, I'm looking to use this formula =SUMPRODUCT(LEFT(G3:G100,2)+(RIGHT(G3:G100,8))) with cells that have numbers in but some in the middle are blank. If I try and return it at the moment, I get a value error due to blank cells. How do I get it to skip blanks? I don't want to shorten the...