occurring

I know if Excel there is the MODE.MULT function to return the most occurring value, but that display in separate cells. Does somebody know of a UDF that can return the most occurring separated by a comma? Results in column G Excel 2016 (Windows) 64 bit <colgroup><col style="width...

I'm trying to evaluate a formula through VBA Code, but the actual evaluation isn't occurring. When entered as just a formula via VBA, I get the expected results. It's when I try adding the Evaluate method, I get #Value errors. Here is the code that I have tried using: If iALR > 1 Then On...

Hi, I can calculate the probability of the mean occurring using the NORM.DIST function, ie 50% probability of being the mean, 28% probability of being the mean +1,etc. What I need to get though is what mean value (mean +1, mean +1.1 etc) is for a given probability %. For example at...

Hi, I would like to see what the most frequently occurring text occurs in the whole range, not just line by line. How do i combine all? i.e. A1:F8? And ignore blank cells? I see there are a multiple threads and posts on this topic already, but all focus in on 1 row or column at a time. Any...

Hi! I am trying to figure out how to make a top n list of the most common text based og 2 criterias (date between and text) Assuming i have a list as shown below, in columnD i want to be able to list the top n colors from columnA based on the criteria that it is an Bmw (columnB) and sold date...

Hi, <tbody> userid email phone domain 1 a@abc.com 123-123-4425 abc.com 2 b@abc.com 012-123-1232 abc.com 3 c@abc.com 382-228-2383 abc.com 4 d@abc.com 456-744-7821 abc.com 5 1@example.com 123-123-3453 example.com 6 2@example.com 354-751-6526 example.com 7 3@example.com...