kewiopex
09-26-2017, 08:54 AM
Dear Experts and Specialists
I have been trying to perfect calculations for a Median based on a selection of text (names) that differ only by their ending number.But my searches and my limited experience have proved pointless.
As per the attached spreadsheet, I wish to be able to determine the Median of a subgrouping of texts such as Brue 1 to Brue 4 within the group of text names that goes from Brue 1 to Brue 9. I have tried various versions of the median and if fomula but have failed to get any subgroup determinations. Wildcards and ">" do not work! This formula was the latest version but again I could not find a way to do a election such as <Brue 5.
=MEDIAN(IF(NOT(ISERR(SEARCH("Brue",All!$C$3:$C$70,1))),All!$E$3:$E$70,"x"))
The attached file contains a version using search as part of the median formula but again it offers no capability to derive a median based on a subgrouping that has specifications that differ only by the ending digit.
Are there any methods that will be able to do what I need, calculate a Median for a selection of names ( texts) that only differ by the ending number?
Your support and assistance is greatly appreciated once again!
I have been trying to perfect calculations for a Median based on a selection of text (names) that differ only by their ending number.But my searches and my limited experience have proved pointless.
As per the attached spreadsheet, I wish to be able to determine the Median of a subgrouping of texts such as Brue 1 to Brue 4 within the group of text names that goes from Brue 1 to Brue 9. I have tried various versions of the median and if fomula but have failed to get any subgroup determinations. Wildcards and ">" do not work! This formula was the latest version but again I could not find a way to do a election such as <Brue 5.
=MEDIAN(IF(NOT(ISERR(SEARCH("Brue",All!$C$3:$C$70,1))),All!$E$3:$E$70,"x"))
The attached file contains a version using search as part of the median formula but again it offers no capability to derive a median based on a subgrouping that has specifications that differ only by the ending digit.
Are there any methods that will be able to do what I need, calculate a Median for a selection of names ( texts) that only differ by the ending number?
Your support and assistance is greatly appreciated once again!