Forum Discussion

Matt_Rec's avatar
Matt_Rec
Copper Contributor
May 28, 2019

Can excel do what I'm asking?

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. 

 

excel

1 Reply

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    May 28, 2019
    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)