Forum Discussion
Matt_Rec
May 28, 2019Copper Contributor
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 c...
Twifoo
May 28, 2019Silver Contributor
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)
=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)