Home

Can excel do what I'm asking?

%3CLINGO-SUB%20id%3D%22lingo-sub-652451%22%20slang%3D%22en-US%22%3ECan%20excel%20do%20what%20I'm%20asking%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-652451%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20creating%20a%20master%20occupancy%20list%20and%20daily%20census%20for%20a%20retirement%20community.%20I'm%20sorry%20but%20I%20cannot%20attach%20the%20file%20due%20to%20confidentiality%20of%20our%20residents.%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20question%20involves%20the%20first%203%20columns%2C%20column%20A%20is%20suite%20%23(all%203%20digit%20numbers)%2C%20column%20B%20is%20suite%20type%20(studio%2C%201br%2C%202br)%2C%20column%20C%20is%20the%20resident's%20last%20name.%3C%2FP%3E%3CP%3EIs%20the%20there%20a%20formula%20I%20can%20use%20to%20count%20and%20identify%20empty%20suites%3F%20I%20want%20excel%20to%20find%20any%20blank%20cells%20in%20column%20C%2C%20and%20then%20take%20the%20corresponding%20number(s)%20from%20column%20A%20(same%20row)%2C%20and%20put%20them%20in%20another%20cell.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-652451%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-652591%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20excel%20do%20what%20I'm%20asking%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-652591%22%20slang%3D%22en-US%22%3ETo%20count%20the%20number%20of%20empty%20suites%2C%20you%20can%20use%20this%20formula%3A%3CBR%20%2F%3E%3DCOUNTIF(C2%3AC100%2C%E2%80%9D%E2%80%9D)%3CBR%20%2F%3ETo%20identify%20the%20suite%20numbers%2C%20you%20can%20use%20this%20formula%20in%20Column%20D%2C%20starting%20in%20D2%2C%20copied%20down%20rows%3A%3CBR%20%2F%3E%3DIF(C2%3D%E2%80%9C%E2%80%9D%2C%E2%80%9D%E2%80%9D%2CA2)%3C%2FLINGO-BODY%3E
Matt_Rec
Occasional Visitor

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. 

 

1 Reply
Highlighted
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)
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies