Stack Overflow
Stack Overflow

Questions tagged [nonblank]

56 questions
172
votes
20 answers

count (non-blank) lines-of-code in bash

In Bash, how do I count the number of non-blank lines of code in a project?
Jonathan Hartley
  • 15,462
  • 9
  • 79
  • 80
6
votes
3 answers

Count non blank rows in a certain range/column Excel

I want to count empty (or non-blank) rows in a given column (or range). Example: I have a column which is spaning over 4 cells width, and each cell has either a single ''x'' or is empty. There is up to 100 rows under this column. Here's a picture…
L. Perreault
  • 63
  • 1
  • 1
  • 4
4
votes
3 answers

Have COUNTIFS ignore all blank cells (= empty cells and cells containing "")

I want to get a formula with COUNTIFS, like =COUNTIF(A1:A3,"<>"&"") such that when A1 = 2, A2 = "", A3 = empty, it returns 1. Notes: A2 contains an empty string, as the result of a formula. A3 is a blank cell, with no formulas in it. The formula…
sancho.s ReinstateMonicaCellio
  • 14,708
  • 20
  • 93
  • 185
3
votes
1 answer

Make Iferror and Googlefinance print "blank" cell if no value

Is there a way to make this formula print empty cells based on the "F" column having no value? I'm currently getting the cell to return "0" but I want it to be blank as I'm trying to combine this manual input with a supermetric query. The purpose is…
Filip
  • 33
  • 3
3
votes
3 answers

How do I remove zero-length strings in Excel using VBA?

I've created a tool in VBA for Excel that analyses .xlsx files we receive based on a number of criteria. One of those is the number of empty cells in the dataset. Unfortunately, though, I have noticed that a number of the files we receive contain…
Gemma Down
  • 100
  • 10
3
votes
1 answer

First blank ("") cell in column with IF formula

I have a macro that exactly copies one sheet's data into another. Sub QuickViewRegMgmt() ("Reg Management").Select Cells.Select Selection.Copy Sheets("Quick View Reg Mgmt").Select Cells.Select ActiveSheet.Paste End Sub I…
KJohn
  • 31
  • 1
3
votes
2 answers

Android: need to validate an edittext for non-blank input

If I want to enforce a maximum length of input in an EditText field, I can use the maxLength attribute. But if I want to enforce a minimum length (in my case, simply non-blank), I find no corresponding minLength attribute. I've also looked at the…
Anne Gunn
  • 2,347
  • 1
  • 28
  • 42
3
votes
2 answers

What is this "　" called?

I am trying to parse a website, and I am trying to replace all occurrence of "　" in a string. This doesn't seem to be space or tab, what is this? a more general question: how do you search for the name of some char you don't know? I tried ansi and…
muyueh
  • 1,018
  • 13
  • 16
2
votes
2 answers

How To Concatenate 1 to 13/any non blank cells groups into adjacent column skipping intermediary blank cells in a GoogleSheets Formula?

My new problem is identical to my previous question asked and kindly answered by @player0 and @TheMaster here: How To Concatenate multiple non blank cells contents into adjacent column skipping intermediary blank cells in a GoogleSheets Formula? It…
Lod
  • 657
  • 1
  • 9
  • 30
2
votes
1 answer

Google Sheets: Conditional Formatting - color all non-empty cells in a row within a range based on the value of another cell?

 Hello!  So I have different (non-numeric) values in Column B (B3:B). And I have transactions (formatted as currency) in Columns C through E (range C3:E). So I want every cell in any given row within that range to be colored, whenever that cell has…
tryingout
  • 39
  • 5
2
votes
1 answer

ISBLANK(...) = FALSE even thought the cell is blank in google sheet

Hi everyone, I have 2 tables, 3rd column for Table 1 is Value 1 and 3rd column for Table 2 is Value 2. I combined these 2 tables by expanding both tables first so that all the columns are aligned as shown in the screenshot above (Column E to Column…
weizer
  • 1,009
  • 3
  • 16
  • 39
2
votes
1 answer

I am trying to have this link open in a new tab so users dont have to leave my site but it is not working with _blank

The link opens but not in a new tab.I am trying to have this link open in a new tab so users don't have to leave my site. I am using target="_blank" but it is not working
TheChiefRocker
  • 73
  • 1
  • 1
  • 4
2
votes
3 answers

Count unique non-blank entries in a range

I have data like this in Excel: Person1 A A B A C 3 Person2 0 Person3 A B C D E F 6 Person4 A A A 1 I am trying to find a formula that…
user51819
  • 315
  • 5
  • 11
2
votes
1 answer

How to check for equality or both blank in AssertJ?

I want to assert that expected and actual are equal to each other. It is ok if both are null or blank ("") -- i.e. null means blank. .withComparator(...).isEqualTo(expected) does not work, because null is checked before by AspectJ: @Given("^data is…
towi
  • 21,587
  • 28
  • 106
  • 187
2
votes
0 answers

How to distinguish between two "stale values" and blanks in between two values in a column of data?

I recently asked a question about linear interpolation of data for missing values. Here is the link to that question What is the dynamic solution to a linear interpolation of data in a row with missing values with an indefinite number of missing…
Abhay Saini
  • 97
  • 7
1
2 3 4