count blanks

  1. L

    Find a way to count the number of days worked via a pivot table?

    I've got a dataset that lists records of resolved tickets by date and agent name (as well as a few other criteria). I created a pivot table that has the agent names in the row field and the resolution dates in the column field so I have a daily count of number of resolved calls by agent as well...
  2. M

    If Cell H is blank then return value

    I am trying to get a formula so that if cell H is blank then return the information from cell B. For Example H2 is blank I would like Credit One to be the returned value in Cell B35. I was thinking a count if formula but I am having trouble getting it to pull the correct data.
  3. J

    Count of 0 in Pivot table

    Hi guys, I want to create a pivot chart that shows the number of entries opened per month. So i'm trying to graph count of values per month using a month column. Pivot table gives Oct 1 Nov 7 Jan 9 Feb 1 I want it to show that there were no entries opened in Dec. Any ideas how i can do this?
  4. A

    Count blanks, in a range defined by criteria outside range

    Hello I am trying to create a sheet to calculate available resources week by week based on a gant chart, I have simplified the sheet below- <colgroup><col style="width: 37px"><col width="101"><col width="58"><col width="58"><col width="58"><col width="58"><col width="58"><col width="58"><col...
  5. J

    Use number of gaps between cells in a column to perform calculation

    Hi, This is my first time posting to mrexcel so please bear with me! I've been tearing my hair out over what is probably an easily solvable question which is why I've come here! I basically have a table like the one below- in the left hand column are numbers (representing amounts of money), and...
  6. J

    VBA Run time error when counting blank cells

    Dim tbl As Range Set tbl = ws.Range("Table1") Dim archive As Worksheet Set archive = ThisWorkbook.Sheets("Sheet1") Dim rng As Range Set rng = tbl.SpecialCells(xlCellTypeBlanks)If rng.Cells.Count <> tbl.Cells.Count Then 'do stuff End If I'm not sure why, but I...
  7. B

    Counting blank cells in row before previous date occurred using index-match.

    Hey guys, I'm working on an NBA spreadsheet involving some various index-match formulas where a reference is being made for a team from the main page to match up with a date (y-axis - current date is always column E) and team (x-axis - varies based on the team the player is on). Basically what...
  8. B

    Count the number of blank cells until next filled cell is found

    Okay, so. I have a sheet with data in all sorts of random cells. However, I only need the information from a few specific ones, so, when I import those columns, I get data that's all over the place. <TBODY> 1 Fish 2 Spoon 3 4 Drink 5 6 Tree 7 Shoe Four...
  9. J

    Count the number of blank cells in a range, starting and ending will cells that match string values

    Greetings MrExcel forum! First time poster here, reaching out because I'm getting desperate to determine if there is a solution to my problem. I'm trying to develop a new daily timesheet for my production workers, where non-production items are recorded in 15 minute intervals. The user would...
  10. psi

    Count blank cells to avoid run-time error 1004

    I got a macro connected to a button that select empty cells within a range and fill them with the value above. The code looks like this: Range("A1:A10").SpecialCells(xlCellTypeConstants, 23).Select Selection.Resize(, 4).Select Selection.SpecialCells(xlCellTypeBlanks).Select...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top