-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
blank space
-
K
Filter out blank space in specific column
Hi guys, how do I write code to filter out blank cells in specific column ?- kamalm
- Thread
- blank space excel filter filter out vba
- Replies: 1
- Forum: Excel Questions
-
Z
Exclude blanks in COUNTIF referencing another cell
I have a formula that is counting everytime a referenced cell's text appears in another worksheet. It is working perfectly so far for what I need currently. But I want to continue the formula down the column in blank rows so that if I add another team member later, it will still work. When I do...- Zoelarae
- Thread
- 0.00% blank space countif formula sun
- Replies: 3
- Forum: Excel Questions
-
J
Quick Easy question
If I have a function such as F4 =F2-(D2*100), since its subtracting and If I have no data in there it will always be -100 until I put data. How can I make it show nothing until data is entered? Also Is there also an easier way to use this formula for the full column instead of dragging it down...- jmahlow7
- Thread
- blank space drag total columns subtracting
- Replies: 8
- Forum: Excel Questions
-
B
Insert blank row, then continue filling in data until next condition is met (hard to explain in short)
My problem is as such: I have a sheet of data that is very frequently updated, but needs an easy overview for some other code to work. Basically, this data-sheet needs to be able to insert a blank row every time a specific condition is met. Actually, it's easier to show: Input...- Bookender
- Thread
- add blank blank row blank space
- Replies: 6
- Forum: Excel Questions
