frankendoc
New Member
- Joined
- Apr 2, 2021
- Messages
- 1
- Office Version
- 365
- 2016
- Platform
- Windows
- MacOS
HI,
I'm trying to do the Median equivalent of AVERAGEIF(A1:A10,"*"&C12"&*",B1:B10) where Column C has text some of which is contained within a longer string in Column A and Column B has numerical values that I want to find the median of.
I found other threads where this was possible with the wildcards if the search term was typed in but not if the search term is in another cell (C12 in this case).
Any help would be greatly appreciated.
I'm trying to do the Median equivalent of AVERAGEIF(A1:A10,"*"&C12"&*",B1:B10) where Column C has text some of which is contained within a longer string in Column A and Column B has numerical values that I want to find the median of.
I found other threads where this was possible with the wildcards if the search term was typed in but not if the search term is in another cell (C12 in this case).
Any help would be greatly appreciated.