Questions tagged [nonblank]
56 questions
0
votes
1 answer
Counting the Number of Blank Cells in an undefined range and summing the values in the next column
I have written a VBA Script that allows the user to allow insert a new assembly and its weight into a table. The inserted assembly can be one of two levels (1 or2). If the inserted row is is a sub assembly (i.e. level 2) then its position is…
Rob Robinson
- 50
- 6
0
votes
0 answers
Excel Formula: Skip zero values in column when repeating Indexed values N times in array?
What function can I add to my G2 formula to skip names with zero values (Col E)?
A B C D E G
1 John 0 SUE
2 Sue 2:00 3:00 2 SUE
3 …
WhatData
- 49
- 6
0
votes
1 answer
vba - copy-paste the last n non-blank column in the next blank column - on multiple same-formatted sheets
I have 4 sheets that are identical in format (same number of columns with different data).
On each sheet, I would like to copy the 6 last non-blank columns and paste them in the next 6 blank columns.
that should be done on all 4 sheets at once…
0
votes
1 answer
Why is my SUMIF with NOT(ISBLANK()) not working?
Column A is price, column B is approval date. I would have thought:
=SUMIF(ColumnB,(NOT(ISBLANK(Column B))),Column A)
should work. All I get is $0.00.
Why?
Am I using ISBLANK correctly or not?
0
votes
1 answer
How do I make this VBA faster, Removes Blank Cells
This VBA array works and removes all the blanks I want. But it's extending all the way down to like the millonth row, taking up valuable computer resources. I need to either make the VBA stop if "the next 10 rows in the array are not filled with…
Trosky6708
- 83
- 3
- 10
0
votes
1 answer
Excel: Need to copy and paste cells depending on non-blank status of cell values in one row in range
Macro newbie here....
I am trying to paste certain cells within a range from one worksheet to another based on the contents of cells in a particular row. For instance, within range B5:B100, I want to copy and paste the B cells to another worksheet…
0
votes
1 answer
I need to divide the last 3 non blank cells by the first 3 non blank cells
In my EXCEL 2010 spreadsheet I am dividing the sum of the last three weeks total hours in a YTD format by the first three weeks total hours, the date of which can vary by the open date. I am having to update my formula weekly for close to 100…
Dj Dier
- 1
- 1
-1
votes
1 answer
How to find the next non blank cell and print the value in excel?
Hi everyone,
I want to find the date for the next non blank cell based on column B, and print the date in column C.
For example, the next non blank cell after B3 is B4, so the formula will copy the date in cell A4 to cell C3.
Another example, the…
weizer
- 1,009
- 3
- 16
- 39
-1
votes
1 answer
How to find the non-blank value in column I in sheet1 then copy entire row and paste to sheet2
I have data in Google sheet1 A:I, I need to copy the row from A:I if column J has value then paste to last row of sheet2. Thank for your help
Exp: I want to copy 3 rows has dog, cat and mango to last row of sheet2
datas datas datas datas …
tt3
- 31
- 1
- 9
-1
votes
5 answers
How to remove last blank from printed line in python3?
I want to remove the last blank from printed line.
example)
list=[1,2,3,4]
for i in range(2):
print(list[i], end=" ")
>>> 1 2
There is a one blank after '2' in printed line. How can I modify the code to remove the last blank?
Chloe
- 29
- 4
-1
votes
5 answers
COUNTIF of non-empty and non-blank cells
In Google Sheets I want to count the number of cells in a range (C4:U4) that are non-empty and non-blank. Counting non-empty is easy with COUNTIF. The tricky issue seems to be that I want to treat cells with one or more blank as empty. (My users…
Denis Charron
- 11
- 1
- 2