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
Highlighted
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
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
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies