Help with formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2099560%22%20slang%3D%22en-US%22%3EHelp%20with%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2099560%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20sheet%20I%20am%20trying%20to%20extract%20data%20from%2C%20it%20is%20a%20list%20of%20audits-%20one%20column%20has%20the%20employee%20type%20and%20the%20the%20next%20two%20columns%20are%20y%2Fn.%20I%20want%20to%20have%20a%20table%20that%20breaks%20down%20which%20employees%20are%20getting%20no's%20(%25).%20I%20can't%20figure%20out%20how%20to%20make%20it%20work%2C%20any%20suggestions%3F%20I%20am%20a%20novice%20at%20VBA%20so%20if%20I%20can%20just%20do%20an%20excel%20formula%20that%20would%20be%20my%20preference.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2099560%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2099640%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2099640%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F943768%22%20target%3D%22_blank%22%3E%40NickieS0303%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI'd%20create%20a%20pivot%20table%20based%20on%20the%20data.%3C%2FP%3E%0A%3CP%3ESee%20%3CA%20href%3D%22https%3A%2F%2Fwww.contextures.com%2Fcreatepivottable.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3ECreate%20a%20Pivot%20Table%20in%20Excel%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a sheet I am trying to extract data from, it is a list of audits- one column has the employee type and the the next two columns are y/n. I want to have a table that breaks down which employees are getting no's (%). I can't figure out how to make it work, any suggestions? I am a novice at VBA so if I can just do an excel formula that would be my preference. 

1 Reply

@NickieS0303 

I'd create a pivot table based on the data.

See Create a Pivot Table in Excel