I am creating a master occupancy list and daily census for a retirement community. I'm sorry but I cannot attach the file due to confidentiality of our residents.
My question involves the first 3 columns, column A is suite #(all 3 digit numbers), column B is suite type (studio, 1br, 2br), column C is the resident's last name.
Is the there a formula I can use to count and identify empty suites? I want excel to find any blank cells in column C, and then take the corresponding number(s) from column A (same row), and put them in another cell.
To count the number of empty suites, you can use this formula: =COUNTIF(C2:C100,””) To identify the suite numbers, you can use this formula in Column D, starting in D2, copied down rows: =IF(C2=“”,””,A2)