Andreas Hermle
asked on
frequency array formula with specific data array
In the attached sample file I employ the array frequency formula.
The 'data array' is a column with thousands of sorted dates (format dd.mm.yyyy) which can occur multiple times
Everything works fine, but as a matter of fact I have to hard code the 'data_array argument' but I would like to tweak the formula so that the 'data array' automatically detects the numbers that fall within the different months.
Example:
I have also attached the sample file with all the necessary data.
Help is much appreciated. Thank you very much in advance.
Regards, Andreas
Frequency-EE.xlsx
The 'data array' is a column with thousands of sorted dates (format dd.mm.yyyy) which can occur multiple times
Everything works fine, but as a matter of fact I have to hard code the 'data_array argument' but I would like to tweak the formula so that the 'data array' automatically detects the numbers that fall within the different months.
Example:
I have also attached the sample file with all the necessary data.
Help is much appreciated. Thank you very much in advance.
Regards, Andreas
Frequency-EE.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks for appreciation..You are welcome and sure let me know if you need any further help on this...
Saurabh...
Saurabh...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Barry,
thank you very much, I will do some testing and then let you two know of the outcome
Again, thank you very much to both of you. I really appreciate it. Regards, Andreas
thank you very much, I will do some testing and then let you two know of the outcome
Again, thank you very much to both of you. I really appreciate it. Regards, Andreas
ASKER
Hi Barry,
just checked your solution. I am very, very impressed, I just can't believe how somebody can come up with such a superb solution. Awesome, wonderful etc.
I'll do some testing on Saurabh's approach as well and then award the points, regrettably I am not able to award thousands of points ;-)
just checked your solution. I am very, very impressed, I just can't believe how somebody can come up with such a superb solution. Awesome, wonderful etc.
I'll do some testing on Saurabh's approach as well and then award the points, regrettably I am not able to award thousands of points ;-)
ASKER
Hi Saurabh,
your solution also works just fine. Thank you very much for your superb and professional support. You both merit a 500 points award, regrettably I won't be able to do this.
Therefore I suggest splitting the points. What do you think?
To both of you: Saurabh and Barry:
I am deeply impressed by your professionalism in handling Excel Problems. This is really awesome !!! It is just fantastic to have such an expert forum at hand.
your solution also works just fine. Thank you very much for your superb and professional support. You both merit a 500 points award, regrettably I won't be able to do this.
Therefore I suggest splitting the points. What do you think?
To both of you: Saurabh and Barry:
I am deeply impressed by your professionalism in handling Excel Problems. This is really awesome !!! It is just fantastic to have such an expert forum at hand.
ASKER
It is a pity I can only award 500 points, you both would deserve 500 points. Again, thank you very much for your professional and extraordinary support. I really appreciate it.
Regards, Andreas
Regards, Andreas
ASKER
I am deeply impressed, wow what a formula! I will do some testing and then let you know but as things stand now, everything works to my liking. Really, this is a very professional job, great :-)
Till later, Regards, Andreas