If Column B Has Anything Entered In It - Leave Column A Blank
Jun 13, 2013How can I leave Column "A" blank if any data what so ever is entered in Column "B"?
View 3 Replies
ADVERTISEMENT
Subtracting Column B From A, And Leave Third Column Blank If No Value In Column B?
Oct 6, 2008I have a spreadsheet with three columns (A,B,C). I want the third column C to be column A - B (A minus B) for each row, but only if there is a value in column B.
If there is no value in column B, then I want that row in Column C to just stay blank.
Sum If Values Entered If Not Leave Blank
Feb 12, 2010I need a formula that will do the following:
Sum K4 (unit price) and M4 (shipping) and return the answer in N4 (total), if K4 and M4 are empty then leave cell N4 blank
All responses will be welcome as this has been driving me mad for over an hour, and the answer is probably so simple!
Leave Fields Blank Until Number Is Entered In Other Field?
Jan 15, 2014I created this formula =G2*2.9%+.3
what I am trying to do is take the number in the G column multiply it by 2.9% and add 0.30. For instance if 20.00 is in the G2 cell, the number I want the formula to produce is .88
the formula works for me but what happens is the rest of my sheet that does not have any numbers in the G column gets filled with .30
How do I prevent the formula from calculating if the G column is blank?
Excel 2003 :: Write Formula That Will Leave Cell Blank If Nothing Is Entered?
Sep 28, 2011how to write a formula that will leave a cell blank if nothing is entered. I do not want it to show a 0 unless the cell entered is a 0.
In cell G16 - I am adding U46 and U58 together.
I do not have a problem when it is 1 cell - my formula works fine. When I have 2 cells added together, the formula does not work.
Count Number Of Cells In Column That Contain Specific Value But Leave Blank If None?
Mar 6, 2014I have a spreadsheet that contains given answers to a multiple choice test. I want to count the number of times each possible answer has been chosen at the bottom of the column. I have tried to use COUNTIF and that works fine to give me the number times each answer has been chosen but there is just one annoying thing. If the given answer hasn't been chosed by anyone, a "0" is automatically entered into the cell. This tends to really clutter up the spreadsheet and I would prefer for the cell to be left blank if the answer hasn't been chosen by anyone.
The closest I can come up with is: {=IF(D1:D10="","",COUNTIF(D1:D10,"A"))} but unless the answer "A" is chosed in D1, the cell remains blank.
If "A" is chosed in D1, then the formula works and counts all the rest of the cells that have "A" as an answer.
Formula To Sort And Leave Spaces Blank Where One Column Doenst Have The Same Value
Aug 15, 2008Every AM I run a report that has ALL of our company order numbers from the 2 systems we use. I get those reports and put them into 2 columns. instead of manually inserting so they all match up, is there a way to do this automatically? ....
View 9 Replies View RelatedEnter Sth In Column A Then The Date And Time Automaticaly Entered In Column B E.g
Jan 20, 2009I want to enter any thing in column (A) and then the date & time automaticaly put in column (B)
enter any thing in (A1), the date & time entered in (B1) automaticaly
enter any thing in (A2), the date & time entered in (B2) automaticaly
and so on ...
VBA To Enter Text In Column After Date Entered In Other Column
Sep 23, 2008I have the following code that fills a range of cells (starting at the active cell) with the date a user selects from a calendar control.
Private Sub Calendar1_Click()
ActiveCell.Value = Calendar1.Value
Selection.Copy Destination:=Sheets("Audit_Results_Data_Collection").Cells(Rows.Count, "A").End(xlUp).Offset(1, 0)
Selection.Copy Destination:=Sheets("Audit_Results_Data_Collection").Cells(Rows.Count, "A").End(xlUp).Offset(1, 0)
Selection.Copy Destination:=Sheets("Audit_Results_Data_Collection").Cells(Rows.Count, "A").End(xlUp).Offset(1, 0)....................
If Column Contains Data Then Insert A Blank Column And Shift Specific Column To The Right
Apr 22, 2009What I'd like to do is; If column C contains data then insert a blank column and shift column C to the right.
View 4 Replies View RelatedClean A Column To Leave Only Certain Text And Numbers
Apr 20, 2009I have data listed in column A. The data appears in text, blanks, and phone numbers....all in different rows.
I need to capture only the phone number and 3 rows above it no matter what the text says or how many rows inbetween each phone number. Then proceed to copy and paste it to a new sheet into one column.
This needs to continue until i reach the end of column a.
Eg. row 1: the fox
row 2: the pig
row 3: animals
row 4: water
row 5: land
row 6: (780) 111-2222
i need to copy rows 3-6, paste to new column and then continue down column A looking for the next chunk of data to copy and paste.
So it would turn out to look like:
row 1: animals
row 2: water
row 3: land
row 4: (780) 111-2222
All in column B
IF Statement To Leave Cell Blank If Multiple Cells Are All Blank?
Mar 12, 2014I am looking for an IF statement that would leave a balance cell blank if both the revenue and expense cells are blank, otherwise a formula would be calculated.
View 8 Replies View RelatedHighlight Blank Cells Red In Column G If Not Blank In Column C (same Row)
Feb 17, 2010I would like a macro to do this...If a cell in column G is blank and the cell in the same row in column C is NOT blank, highlight the blank cell in column G Red.
I need the search to stop ONLY when it gets down to the bottom-most row of data in column A.
Note: Any row headers will always be in row 1 only
Current...
Sort Column To Match Pair In Other Column, Skip Blank Spaces
Mar 28, 2007Here's what I have.. (on a much smaller scale)
http://www.jmetenterprises.com/produ...pics/excel.jpg
(notice how the lines that match are now even.)
[Edited by admin~ *Link* to large images, don't display them]
Find The Column Name Purple & Delete The Whole Column If There Are No Blank Cells
Mar 18, 2009I'd like a macro that does 3 things..
1. Find the last row (cell) of data in the "Customer Number" column. This search should be by the name "Customer Number" rather than by column letter because the column that "Customer Number" will be in can change.
2. Find the column named "Purple" (also by name for same reason)
3. If the "Purple" column has no blank cells in those same number of rows as the "Customer Number" column, delete the whole "Purple" column.
How To Copy Value From Column A After Blank Line And Insert Text In Column B
Mar 21, 2014I have a workbook that usually looks something like this
Category Product No description Price
Balloons 12345 Red Disney balloon .50
Balloons 12567 Blue Princess balloon .86
Balloons 76521 Angry Birds Balloon .80
Kites 23456 A Big red Kite .27
Kites 22222 A small blue kite .06
Banners 10000 Party banner .33
etc..
I need to find a way to copy the category below an empty row from column A and paste it in the blank row in column B . If possible to bolden the text but I could probably work that bit out myself. I'm new to this but have used VBA before to run macros.
Macro - If Cell In Column Is Blank Then Input Text Into Same Row In Another Column
Sep 19, 2008I am looking for a Macro that will search a column for blank cells, and when one is found will add text to the same row in another column. For example: The below is a spreadsheet. I am trying to find something that will search through column "C" in this case and add text (of my choice) to Column "A" if the cell is Blank. So Since cell C1 is Blank then Type "ERROR" is cell A1.
A B C D E
1 X X X X
2 X X X X
3 X X X X X
4 X X X X
5 X X X X
Repeating Macro Column By Column Until It Hits Blank?
Feb 21, 2014This is for a template for teachers to analyze student testing data. On sheet4, wrong answers in each column are noted by a lack of a + in the corresponding cell. I want to paste the names of the students who missed each question into sheet 5.
I've done it by repeating a filter macro, but I manually copied the following separately for the 75 columns in the template.
Problem #1 - there must be a more efficient code, something that automatically loops to the next column
Problem #2 - the template has 75 columns, but many tests have fewer questions. I'm trying to find a way to stop the loop whenever it hits a blank cell in Row 10 on sheet 4. I've done it with an if/then in the last section on the above code, but where I'm at now, i would have to add that to the code section for each column. Which isn't that big a deal, but I figure there must be a better way.
The relevant portions of the workbook are attached here.
repeating macro until hits blank cell sample.xlsm
Formula To Find A Value In Column A Corresponding To First Blank Cell In Column B?
Aug 7, 2013A
B
1
Name
Action
2
Joe
Created
3
Bob
Approved
4
Cindy
5
Jane
6
Dave
7
VBA To Copy Non-blank Cells From Column And Paste Into Another Column
Oct 4, 2013In sheet "diary" I have data in certain rows in column A8:C10000 that contains values if a certain condition is met. I need a vba to copy and past only non blank cells in column D8:F10000. I first wrote a formula with index but it takes too long to caculate.
View 9 Replies View RelatedLookup (display The Value In Column B If Column C Is Not Blank)
Oct 31, 2009What i am looking to do is have column D display the value in column B...if column C is not blank. Here is an example.
View 4 Replies View RelatedCount The Number Of 'YES' In Column B ONLY When Column A Is Blank
Jul 27, 2006I have 2 columns - Column A and Column B. I want to count the number of
'YES' in column B ONLY when Column A is blank.............
Copy Non Blank Cells In Column Up 1 Row To Another Column
Mar 20, 2008I need a macro to copy and paste data from Col A to Col B. But I need it pasted 1 row up. In other words if A6 has data I need it pasted in B5 and Bolded. I got a start but don't know how to finish.
Dim ii As Long
For ii = lastrow To 6 Step -1
If Not IsEmpty(. Range("A" & ii).Value) Then ****.Range("A" & ii).Copy*****
Next ii
Get Value Of Same Row From Column Of Last Entered Value From Other Column?
Aug 12, 2014I have attached an worksheet for better concept. I want to figure out G column data of same row of last entered L column. suppose last entered value of L column is L5. i want to figure out G5 cell value which should entered in G2. I tried formula to get cell number of same row but dont know how to find value of that cell number.
View 2 Replies View RelatedReturn The Last Value Entered In A Column
Mar 7, 2007I have a spreadsheet with two colums were new values are entered every day. On the bottom of theese colums I want to be able to see the sum of the last to values entered. How can I make this go automaticly? My teori is to make the last sum entered in each column appear in two cells, and then sum theese to cells. But I can't seem to find a function that works for this. I've tried the "IF" function, but I can only make it work on two cells on a row (=IF(A9;A9;A8)) (I want it to go all the way up to A1)
Find Last Entered Value In Column
Mar 29, 2014I have a two columns that I would like to use to calculate/identify the value of the most recent entry.
Column A has dates in ascending order, historical, current and future (say, A3:A300. Column B has sporadic entries (many blank cells) from B3:B300.
I would like a formula in B1 to display the value of the most recent entry in Column B (highest row number), and a bonus would be if cell A1 was able to identify the date of that most recent entry.
If Column A Is Blank Then Column C To G Must Be Blank Even With Formula
Apr 29, 2006I have a value in A1 and I have a constant formula from Column C to G. what I want to do is if column A has no value then Column C to G should not have values. If column A has values then Column C to G should calculate the values. I have a sample excel attached. I can't figure out what to do! I've tried conditional formating but dosn't seem to work
View 6 Replies View RelatedGetting Value To Change When Value Entered In New Cell Of Column
Jan 11, 2010Not sure if I can do this with a formula or not. looking to change the value of a cell when using a column. Im looking to have the cell to change each time after there is a new value entered in the column but only when a value is entered in new cell of the column.
View 5 Replies View RelatedHiding Rows That If N Is Entered In To Column
Feb 1, 2010Is there a macro that I can use, that if N is entered in to column A then the whole row will be hidden and if Y is entered in, it will reappear.
Can this be done automatically without having to click a button.....