Forum Discussion
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...
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)