count blanks

Hello All, I have a workbook that non-Excel people use. It records the progress of the elevator car we're installing. It's a free-form table where users can enter their car IDs anywhere in the "Car" column (see the example). I want to count cars "not started" as a data point. Unfortunately...

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...

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.

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?

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...

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...

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...

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...

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...

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...

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...