blank cells

Hi All I am looking for a little advice as i expect i am going to get a spreadsheet soon with exported data and i wanted to get a head start on a piece of VBA that i'm not aware how to do: So i have the example data below as follows: <tbody> A B C D 1 Name Date Time In Time Out 2 John...

Hello all - I have been given some great help recently in trying to return the MODE of a series of TIMES (as in times of day). This has been very helpful, and I thank you all. Now I have hit a snag in implementing it. In col C2 I have the following formula: =IF(Main!DG3="X",Main!G3,"") This...

Hi, I require a VBA code to help me remove blank cells across different column labels to reflect the first non-blank cell in each column across unique row labels. This: Has to end up looking like: Where all the duplicated row labels are removed, with only unique values remaining and the...

Hi everyone, This is the sample text. What I require is to remove all the blank cells and lookup the first non-blank cell value as each category for each Name has ONLY one unique value. So this: -- corrupted image removed --

Hi, I have a spreadsheet which has data imported from a very old excel format (excel 2.0). There are cells in this file which appear blank however excel 2017 does not perceive them as such. The really odd thing here is that if i use F2 to edit the cell and then hit enter or Tab to move off of...

The following code of mine is not running: Sub Blank_Cell_Alert() Range("A2").Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Selection.Name = "MyRange" ActiveSheet.Name = "MySheet" If...

I am trying to get the data to continue numbers while duplicating the previous rows. Then I need it to go over a blank row every 48 or so rows. I need this continuously for over 35,000 rows. Image for help attached - Please note I put in the image how I would like the numbers to keep going...

Hi, Can someone help me with this formula please.. If any of the I cells (I18, I19, I20) are blank I need them not to be counted. =(C13/(C13/I18+C13/I19+C13/I20)*K6*K18)+(C13/(C13/I18+C13/I19+C13/I20)*K6*K19)+(C13/(C13/I18+C13/I19+C13/I20)*K6*K20) Cheers

Hi all, I am just trying input a formula to know if a large spread sheet with a certain task has been completed or not. I have 100 cells that all need to be input with a value (e.g. cell is not blank) for it to be deemed to have been completed. The cells are...

Hey guys, im looking for a vba to merge the current cell with all the blank cells below it. I'm automating a report, which turns into a pivot table, and then i need that pivot table in text format for something else. I was thinking of doing something like this and merge cells while recording...

Hi guys, im trying to fill all the blank cells in a selected range with the text "no data". however, im doing a monthly report, and its not necessary for each month to have blank cells. so how can I make an if loop where it checks if blank cells exist in the range, if they do, fill with "no...

I'm trying to get a column of raw data, remove the blank cells, and have them be outputted to another column. Is there a simple way to do this (whether using VBA or using a formula?) Intuitively, I think there's a way to do this using array formulas but am unclear. Happy to hear any...

Hey guys, I needed some help in figuring out a way to loop a certain function in excel. I have a table with 4 columns, and what I want to do is fill in all the blanks with "Not given" I was going about it by manually filtering each column for blanks, and filling them with "not given" however...

I need help modifying this code. I want to set any blank values in column A to zero. This macro works for this but I have to specify the range. I want the range to select all of the data in the column. ie. if the last cell was A563 I want the macro to be only applying this change from cells...

Good day, My situation is, I have a excel schedule that at time has employee's that are borrowed from another department. This results in many blank cells on my schedule, leaving a void between other employees. My question is. Is there away to hid these blank cells without removing the...

Hi, I have a large data to analyse from which I want to identify blank cells in column A and populate it with value in adjacent cells from column F. If column F is blank then populate the value from adjacent cell in column K and if column K is also blank then fill 'Check' as the value in cell...

Hello World, I found the following VBA code here in the forum, however, I'd like to take it one more step. Sub strip_zero_length_string() Dim c As Long With Sheets(ActiveSheet.Name).Cells(1, 1).CurrentRegion .Cells = .Cells.Value For c = 1 To .Columns.Count...

Hello :) , I want cell H15 to be blank if G15 is blank too. However, if G15 has a number in it, H15 should be the double of the number in G15. The same should count for the entire colomn: if G16 is blank so should H16 but if there is a number in G16, H16 should have double that number et...

Hello all, I am new to this form and wish I had joined awhile back. If we were to rank my Excel skills by the United States Class system, I would probably be cresting Upper-Middle class; so very good, but not an expert yet. I have been working on a project for work that my coworkers are very...

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...