Excell Filter

%3CLINGO-SUB%20id%3D%22lingo-sub-2282373%22%20slang%3D%22en-US%22%3EExcell%20Filter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2282373%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%20I%20am%20trying%20to%20use%20formula%20correl%20and%20check%20correlation%20between%20two%20ranges%20in%20my%20data%20sheet%2C%20however%20this%20data%20is%20filtered%20and%20it%20has%20different%20criteria%20such%20as%3A%20Country%20region%20for%20example%3A%20CIS%2C%20Asia%2C%20Africa%2C%20also%20other%20criteria%20such%20as%3A%20Related%20and%20notrelated%2C%20and%20also%20third%20criteria%20such%20as%3A%20service%20type%20of%20voice%2C%20sms%20or%20call.%26nbsp%3B%3CBR%20%2F%3EThe%20issue%20that%20I%20am%20having%20is%20that%20when%20I%20filter%20the%20data%20by%20for%20example%20CIS%20countries%20which%20are%20related%20and%20also%20are%20in%20sms%20service%20type%20and%20select%20that%20range%20for%20correl%20function.%20It%20calculated%20all%20the%20other%20cells%20that%20are%20hidden%20because%20I%20have%20filtered%20the%20data%20but%20are%20not%20relevant%2C%20I%20mean%20it%20calculates%20other%20service%20types%20or%20regions%20also.%20I%20am%20trying%20to%20calculate%20correl%20function%20for%20specificly%20each%20region%20and%20for%20specific%20service%20type%20but%20I%20am%20not%20able%20to%20select%20specific%20range%20that%20I%20want.%20Can%20anyone%20please%20help%20me%20with%20this%20issue%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2282373%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2282387%22%20slang%3D%22en-US%22%3ERe%3A%20Excell%20Filter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2282387%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1034754%22%20target%3D%22_blank%22%3E%40Obolashvili%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20%3CA%20href%3D%22https%3A%2F%2Fwww.mrexcel.com%2Fboard%2Fthreads%2Fcorrel-function-on-filtered-data.15169%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3ECORREL%20function%20on%20filtered%20data%3C%2FA%3E%20for%20a%20custom%20VBA%20function.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello everyone, I am trying to use formula correl and check correlation between two ranges in my data sheet, however this data is filtered and it has different criteria such as: Country region for example: CIS, Asia, Africa, also other criteria such as: Related and notrelated, and also third criteria such as: service type of voice, sms or call. 
The issue that I am having is that when I filter the data by for example CIS countries which are related and also are in sms service type and select that range for correl function. It calculated all the other cells that are hidden because I have filtered the data but are not relevant, I mean it calculates other service types or regions also. I am trying to calculate correl function for specificly each region and for specific service type but I am not able to select specific range that I want. Can anyone please help me with this issue?

1 Reply

@Obolashvili 

See CORREL function on filtered data for a custom VBA function.