blank cells

Hi - I am using the following code to search column D for either "Task Description" or "Method of Quoting" and when it finds either of those words, it looks in column E. If column E is empty then it returns an error message box. Does anyone know if its possible to return the cell address of...

I'm trying to create a grade tracker (pictured below) , and I have 2 questions regarding that. (note that I am a complete excel newbie, so please thoroughly explain each step to solve these problems, if possible.) 1. how do I leave the cells in column "Grade"(F8-F14) that have "0%" in them...

Hi there, To declare my problem I'd use a simple example here. On the table below, I want to have the average of values in column "B" which are corresponded to the cells on column "A" with a value equal to cell "C2" or "101". As it can be seen in the table, some corresponded cells are empty...

I have three columns as follows: Column A: Provides the number of days permitted to complete a task Column B: Provides the number of days that it actually took to complete the task Column C: This is where I need my IF Statement to calculate a simple Yes or No if the Actual Days to complete...

Hi, I'm trying to find the row number of the last cell in an array that is equal to zero but is not blank. My array is one column wide and 38 rows deep (K6:K43). The top 1 to x rows will always have a value (0, 3, 5 or 7) and the bottom x+1 to 38 rows will always be blank. I've tried...

Good day all, I currently use a macro to send an "Order Form' (an excel sheet) to my Stores. The end-user fills out the form for items then hits a button on the sheet and the sheet is sent to Outlook and waits for the user to hit SEND (they have to c.c. certain people) and then the form goes to...

I'm writing up a note on #N/A for my students (adult office workers). I condensed the answers to students' questions into 5 paragraphs. I would appreciate any comments about mistakes or potential logical problems. Much thanks, John. #N/A – An IntroductionA display of #N/A means not available...

Hi all, could use some help with a formula in my workbook. Creating a total tab which pulls from two other tabs. Looking for a formula that will pull the totals from the other tabs, but if the value is 0, than show the cell as completely blank. Example: Cell B24 = (Tab1 Cell B24 + Tab2 Cell...

Hi there, (First time poster!) I'm working on a pretty large file. I want to calculate a weighted average on the left hand side of my excel spreadsheet. I have several tables (15 to be exact) and each table has 10ish columns. I want to calculate a weighted average using just 2 columns from...

See code below... code Sub RemoveBlankCells() Dim rng As Range Set rng = Range("A1:D5000").SpecialCells(xlCellTypeBlanks) rng.Rows.Delete Shift:=xlShiftUp End Sub /code Code works good for what i want it to do but I dont want all the rows to shift up i.e. a, b, c, d is blank I want it to shift...

Hi guys, I need a script that loops each cell in row 1 (header) and if the cell dont contain any data go the next. Could someone help me? Thank you in advance.

Right, I am using the countIF and Countas formulas for calculations on my quote register at work. This will grow daily, so the range will increase....Right now if I count only the actually filled cells it will return a different result to if I change it to what I thin will be filled before I...

I am hoping for some help taking the dynamic charting one step further. I'm familiar with creating dynamic charts, but I'm stumped as to how I can do the following: I am pulling in Bloomberg data into an ever expanding data set called TABLE A. What this means is that there is one formula, and...

Hi everyone. I’ve been looking through so many topics here and many of them were really close to what I’m looking for as a solution but none of them no matter how many times I tried didn’t’ work out for my issue. Obviously I’m not an Excel guru. I have a situation with Average formulas and...

I have a tab in Excel in a normal database style. One of the columns categorises the items. I then have subsequent tabs - one per category - where I want formulas e.g. a vlookup to extract all the entries in that category from the base sheet. I can do this with a vlookup or IF function...

I've got a data range across A:K, with headers in row 3 (all data entries beginning in row 4). I'm trying to run a macro which takes the prospect's name in A, and tells me which cells in C:K, if any, are blank for each producer's initials found in B. For example: If A4:K4 are all filled, it...

Hi again hoping someone can help with the latest problem in my pet project. I am creating annual planner style spreadsheet and am having issues with a vlookup formula current formula =IF(ISERROR(VLOOKUP(O143,'Holidays & Observances'!$B$3:$D$52,2,FALSE))=TRUE,"",VLOOKUP(O143,'Holidays &...

Hi, I'm new to VBA and most of what I have learned has been through Google and I have found a lot on this site. I am trying to write a code that will prevent the user from printing the worksheet if two specific cells are blank. I have tried the following codes, none of which have worked. The...

Hey There. I have a general question. I find myself using the 'For Each' loop when going through either user selected ranges or pre-defined ranges to find cells that have specific values, are blank, or are non-blank. Is there a more efficient way to accomplish this? For example, I have a range...

Hi I want to return a cell (U930) blank if another cell is <>0 e.g. Formula in U930 =IF(U490<>0,AVERAGE(O490:U490),"") U490 is blank, however has a similar formula which leaves it blank. This formula therefore returns #DIV/0! in U930 This there anyway around this so that U930 will be blank...