blank cells

What is the formula that I can use in Column C? I don't want to have to change any cell references as this data changes all the time so it will have to be smart enough to detect blank cells in column B and then place the subtotal in column C. Also, the subtotal in column C is only for a...

Hello, I'm trying to select the same cell and a blank cell multiple with a UNION(). Is this possible? Here's a summary of my code: Dim c Dim Rng As Range Dim blankC As Range Set blankC = Range("XFD1048576") Set Rng = Union(Cells(c.Row, 1), Cells(c.Row, 4), Cells(c.Row, 2), _...

I have a spreadsheet with several hundred records. I would like to populate blank fields in each record with information from another record with the same value in a particular field. In the example below (blank cells have been replaced with ___), I want to populate all the blank fields in...

Please find the below excel for understanding Lets consider only the first 3 rows on the attached excel I am reading the excel from a java file. so that the cells F2,G2,A3,B3 and E3 are taken as empty by which it is returning as "null". But for me it should taken as "". this can be achieved...

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...

I need to format cell D1 to have the fill color be red if any cell in D2:D21 is blank. I've tried =VLOOKUP("", $D$2:$D$21, 1, FALSE) but that returns #N/A (there is one blank cell in the range at the moment). Can anyone help me with this? I really don't want to use =OR($D$2="", $D$3=""...

Hi, I have a table like this that has 4 columns: Finished Product Number / Raw Material Number / Stock in Warehouse / Unit of measure Each Product Number may have different amounts of materials numbers. Finish Product# / Raw Material # / Stock in WH / Unit 1111 / BLANK...

Here is my situation: I have sheet1 "Population Names" I have sheet2 "Results" I need items in the range "E5:E21" of "Population Names" to copy to column "B" of "Results". PROBLEM(s): There are blank cells in "E5:E21" of "Population Names" which I don't want to copy over. I would like to...

Hi im currently trying to create a soccer table in excel that automatically updates when i put the scores in. I seem to have cracked everything but the amount of games played in the table. Basically im using the IF function to determine points from a certain result. However if both cells are...

Hello, I have two columns. A is full of numbers, and B has some numbers and some blank cells. I want a formula for C1 that says 'If B1 is blank, use the number in A1. If B1 isn't blank, use the number in B1'. So, for example, the end result would look like this <TABLE style="WIDTH...

Hello, First, let me say that I know a lot of threads have been done on this subject. I have been reviewing about 20 of them for the past two days and haven't found a proper solution to my problem. Well I found something very close but couldn't manage to make the formula work for my case or...

Hi. I have a pivot table (in Excel 2010), that has blanks in the result. In order to chart the results, I want to convert the blanks to 0 so there will be a continuous line. Does anybody know how to do that? Thanks...

Hey guys, I'm pretty new to using macros, but I've been trying to work on one to delete completely blank rows from row 108 to the end of the data. Ideally, I then want to copy the remaining cells and paste them in row 66. Would anyone be able to help me out? I'm struggling a little bit...

I have about 30,000 rows of data with merged cells. I have unmerged all of the cells to create a pivot table, and have many resulting blank cells. I need any easy way to copy data from the populated cells down to the blank cells, on a large scale since 30,000 rows. Example: copy data from...

Hi, I have selected all cells in my sheet and did "clean all". When I press CTRL+END the cursor goes to cell R202. The sheet should be empty! When I use the "goto special..." window and command it to go to blank cells I get a whole range from A1 to R202 selected. How do I get rid of that? What...

I use Excel 2010 for data analysis, but sometimes the raw data contains no value...(for example extracting information from previously cataloged items and no info was reported for a field such as the year or the author or location). I want to use pivot tables for a research report but what can...

Enigma: there are cells in my workbook that are "blank" even when you hover the mouse over the cell the formula bar is blank. However when I print the page I get 8 blank pages. When I go to print preview the cells are blank but excel thinks that it is used so it is not blank. when I use formula...

I have a large amount data with dates in 2 columns (example below). I am trying to build a macro where it can detect the blank cells and then delete the blank with the corresponding date. I am able to delete the blanks but I can't get rid of the dates so my data will be skewed with missing data...

I'm trying to go down every column and delete blanks by pasting up but I think I have an error in my coding. I have a date associated with number so I actually have to shift up two columns for every cell but I think the problem lies with the IsEmpty Cell Function. If anyone has another way to...

Hi, I'm working with the following VBA to remove text/blank but its very slow when working with larger data files. Is there a way to make it faster? For i = Lastline To 1 Step -1 If Not IsNumeric(Cells(i, 1).Value) Then Rows(i).Delete If Cells(i, 1) = "" Then Rows(i).Delete...