Hi there,
I'm trying to add a formula into each blank row of my data set in column C. (see cell C5 on image, as an example of where the formula has populated, and cell C11 where it hasn't)
The formula in column C is a weighted sum product formula i.e. =($B3*C3)+($B4*C4)+($B5*C5), so this...
Hello!
I am trying to use conditional formatting to highlight the blank cells in a database, only if there is data in other parts of the row.
For example: if a cell in Column B has data then highlight the blank cells in that row from A to R. Here is an example of my data:
In this...
Can anyone help me please,
I'm trying to find blank cells in a range (O2142:O2206) and the get reference to those cells.
And is there a way to only get reference to the row.
see image below:
I want it to look for the blank cells in column O (Date Job Delivered) because if there is cells...
Hello everybody,
I am currently facing an issue. I would like to create a code that colors my cells with a complete white background and no borders if they contain no data (numbers, letters, signs or anything else).
Please see the following snip:
For the blank cells from Cell A135-D135 and...
Hello everybody,
I am currently having some problems with my excel spreadsheet. In short, I have a list of materials in my "Order form" sheet 1 and I have all the hard data in a hidden sheet called "Products" (sheet 2).
Currently, I have just set the fields in my "Order form" sheet = the...
Hello everybody,
I am currently having some problems with my excel spreadsheet. In short, I have a list of materials in my "Order form" sheet 1 and I have all the hard data in a hidden sheet called "Products" (sheet 2).
Currently, I have just set the fields in my "Order form" sheet = the...
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...
Hey there, i am trying to highlight if a cell is blank, but don't want " " (a space) to be considered a blank cell.
I tried adding a ' before the space, and this doesn't work.
Any ideas?
isblank and not " "
I am working on creating a list of students who have not turned in an assignment by staff adviser. I want a list that says Beth, here are your students who have not turned in the assignment. I can get a formula to return the students name by owner, HOWEVER, when a line of data doesn't return a...
Hi... it's been 8 years but maybe someone will see this.
I also want to write in VBA, if cell is not blank, then do this.
And then stop. Acting only if the cell is not blank...
This is based on a column of numbers, updated monthly. So when the month is updated, I want the macro to run.
But I...
All,
I have been working on this formula for a bit and am struggling it to finish it of.
I have 3 cells that consist of Date/Time stamp H, I, J: My formula below:
=IF(AND(ISNUMBER(J2),ISNUMBER(H2)),(J2-H2)*1440,IF(AND(ISNUMBER(J2),ISBLANK(H2)),(J2-I2)*1440))
But I want to included that if...
I am looking for assistance in revising code for one of my worksheets (Sheet3). In essence, I want to look at a specific cell within a range and if that cell is blank, then hide the entire range. Sheet3 has 5 ranges to gauge whether to hide the blank rows and thought a Union would be the best...
#VALUE! Error
I have an Excel spreadsheet in which a random number and a blank is generated for a Numerator for a Fraction in Column F and a Denominator is generated in Column G using a formula based on the number which is generated in Column F.
When I attempt to generate the resulting value...
Hi :) I have a question concerning due dates and finished dates. How would I format the two columns to where if it is complete, the red format I have set up for "expiring soon" goes away? If the order is complete, I'd like for the conditional formatting to correspond.
Due date is column D, and...
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...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.