blank cell

i have 3 rows of words only 1 column in each row has a word and i want to make them all on the same line and get rid of the # vaule...the problem is that the "empty" spots have a formula in them so they are not technically blank -- removed inline image ---

I am having troubles with my =Vlookup function.. I am using for horse racing, as an entry form. I am wanting there to be a main entry page, and then from there, it sorts all of the horse/riders into their appropriate class. I have about 10 different pages to my workbook. The first page, is...

Hi. It is my first question here and I am sorry it is too trivial. I am constructing a formula with multiple criteria. =COUNTIFS(D21:D868, "INT OUT Employees", F21:F868, “>0.01”) But I have one more criterion. It is that I do not want to count a cell if the cell 4 rows above is not empty...

I have this in H13 <tbody> =IF(G13>TIME(14,0,0),"✘", "✔") When there is no info in G13, I want H13 to blank. How do I do this. I've fiddled with ISBLANK, but nothing seems to work. Thanks for the help! </tbody>

Hi everyone, I need help writing a formula for our laboratory work. In essence, our log indicates this: Column A: Subject # (unique identifier) Column B: Status (x if deceased, blank if alive) Column C: Location Number Basically, there can be multiple subjects in one location. I would like to...

Hello, Is it possible to capture change in cell value but only if the initial value of the cell was not blank. Unless I am missing something doesn't seem to be possible to do with the Worksheet_Change event. Thanks

I have an Excel Spreadsheet I am working on. In Column D, I will be posting a date. In Column E, I will be posting the date +2 years. This is the formula I created: =DATE(YEAR(D3)+2,MONTH(D3),DAY(D3)) However, if any cells in Column D are blank, Column E produces the number 12/30/1901. I...

Hey Guys, I've got the following issue: Using W7 and Excel 2010, I have a data sheet containing ca. 34.000 rows. I currently have a column which calculates the difference in time between two time entries through the use of a formula. The formula i'm currently using is...

Hi all, Hope you can help me with this little annoyance.... Section Score Pass/Development/Fail 1 Pass 2 Pass 3 Pass This is the formula that's in the first "Pass" box, opposite "1". =IF(H28>=90%,"Pass",IF(H28>=75%,"Development...

Hi everyone, This one is a little tricky, I've been spinning my wheels without much luck. I have 2 columns of data in columns A and B. Column B has a value in every single row whereas column A only has values in every other row or every 3 or 4 rows, it varies. I'm trying to create a formula...

Hi everyone, I have a spreadsheet tracking monthly insurance payments. I want to create a list at the bottom of my spreadsheet that will populate with the individuals names that have not paid for each month. Each person spans across 4 rows. When someone loses coverage, I merge the 4 rows for...

Hi Everyone: I have been sorting through a problem, but cannot exactly figure out how to do it.. We need to be able to start a specific cell "F283" and move down through column F until there is a blank cell, and copy that column for use somewhere else. I have seen a couple offerings that are...

I need a macro to copy data from one sheet to another. In sheet 2 i need to copy data from the same row in a range between columns C to H. The row will change to be the bottom row with data in it.(can a formula be in the cell and it not be recognised by this if it is blank? or am I asking too...

I work for a recruitment firm and as such much of my day is spent calling numerous people. Many of these people are unable to talk at the present time and instruct me to call back days, weeks even months later. I record all calls etc in an excel spreadsheet and would like to be add call back...

Hi, I have a list of names in one column, and how much they spent on the second. On the side I am using this formula to calculate how much each person has spent: "=SUMIFS(Spent,Name,L7,Spent,">0")" where Spent is the dynamic range of the names column, spent the dynamic range for how much they...

I need a macro solution to perform the following tasks... 1. Filter column A for all blanks 2. Select first resulting cell and enter a formula in it 3. Copy that formula into columns B thru O then down to last row in filtered list 4. Copy all new formula cells and paste value over them

Hi, I need to build a complete non-blank criteria in an advanced filter. I know <> will give me all non-blanks (skipping pure blank cells). But as you see in the auto-filter criteria "Blanks" will also give the impure blanks (i.e cells containing only a space/spaces as thier value). How to build...

Hi Community, I'm producing a template for auditing purposes and is going to be provided to outsourced companies to complete the task. I'd like to know if there is a data validation or macro that wont allow the auditor to leave a cell blank when he clicks on it because in the past we have had...

I want to add Rows into Column Example: <tbody> Style style1 Style 2 Style 3 Style 4 Style 5 12 12A 12B 12C 12D 12E 13 13A 13B 13C 13D 13E 14 14A 14B 14C 15 15A 15B 16 16A </tbody> To this one given below <tbody> Style Style 1 Style 2 Style 3 Style 4 Style 5 12 12A...

I have a large spreadsheet (57,000 rows of mostly text cells) and need to identify the first blank cell (or if easier, the last populated cell,) in each row, between columns A and X, and put that cell address in column AK. I will then use formulas to retrieve certain data to the left of that...