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
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
Copy/paste no longer working in Excel
Jon Firooz in Excel on
76 Replies
changing Date format in a pivot table
ahmad ali in Excel on
12 Replies
runtime error 1004 : Method range of object - 'Global' failed
Lorenzo Kim in Excel on
16 Replies
INDEX & MATCH interrupted by Inconsistent Dates
shade206 in Excel on
18 Replies
!SPILL error with SUMIFS formula
Dzung Vu in Excel on
18 Replies
Need to extract values from named cells (Get and Transform)
JEMagnussen in Excel on
23 Replies