# geomean

1. ### GEOMEAN when I already know how many I have of each

My first post here... please be gentle So I have a very, very large data set that I have distilled down to a table of 500 lines, summarized according to some COUNTIFS statements. Now what I need is the geometric mean of the totals. For example, in the first row I have pasted below, I know I...
2. ### GEOMEAN with IF(AND statement

Hello I am having issues with getting a Geomean Array to work. I have a list of dates in column A and results in column B on one sheet. I am trying to code a formula to that looks a date 1 and date 2(cell E1 and E2) and Geomeans all the results with dates between date 1 and date 2. Here is what...
3. ### GEOMEAN IF for specific date range

<tbody> date amt 1/1/02 2 1/1/03 6 1/1/05 4 1/1/10 7 1/1/11 1 1/1/13 2 1/1/15 5 1/1/17 7 </tbody> Hello, I was wondering if it is possible to utilize a geomean function based on a specific date selection? For example, the data that is located within 1/1/10 - 1/1/13. Any...
4. ### Geomean alternative for Averageifs

Hi, I am trying to find the geometric mean of a range of values based on another range of data and if that falls into a certain bin width. So for example, finding the geometric mean of the values in column B, only if the values of column A fall within a certain bin width that I set at 1...
5. ### VBA for Geomean of Array within Array

Hello, Would appreciate any help on a small issue. I have an array of arrays [ArrOfArr(1 to 7, 1 to 2)] where each element in the array is another array containing non-negative double type numbers [ie arr1(1 to x), arr2(1 to y)]. I am trying to find the geomean of each array within the array...
6. ### Calculating the Median, Mean, and GeoMean of dynamic range

I have a spreadsheet with Data in Columns A-H. Column B is an ID value that will repeat an unknown amount of times. For each Value in Column B I need to calculate the Median, Mean, and GeoMean for the corresponding range of "G_:H_" Ex. <tbody> Column B Column G Column H 2 10...
7. ### Normalize returns

Hi all, I have 2 times series of monthly stock returns. I want to normalize the 2nd series to the first, so the cumulative return of both end up in the same spot on a chart (to show the stdev of the 2nd compared to the first). Here is my current process that does not work: 1. Calc GEOMEAN of...

### This Week's Hot Topics

• VBA (Userform)
Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
• List box that changes fill color
Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
• Remove duplicates and retain one. Cross-linked cases
Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
• VBA Copy and Paste With Duplicates
Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
• Macro
is it possible for a macro to run if the active cell value is different to the value above it
• IF DATE and TIME
I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...