|Here's what I'd like to offer:|
I have not worked with FREQUENCY very often, but I'm pretty sure I can figure out a solution if you'll do me a favor.
Post a short table of example data, along with the desired results, so that I can fully understand what you are looking for. Obviously I don't 994 rows of data. Maybe 5 - 10 rows so I that can see what your formula does with your actual data and then I can work on a solution.
Please read the How To referenced in my signature line so that the example data you post will line up correctly.
Feel free to simplify things to make it easier to post, e.g. shorter ranges, shorter strings.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.