mode

Hi all, I am trying to create a formula which finds the most frequently occurring text value (all entries all text) in an areay I am using INDEX(D4:D7,MODE.SNGL(MATCH(D4:D7,D4:D7,0))) but this only works for single columns or single rows not a 3x3 or ZxZ array for example Can someone please...

Hi there! I made a spreadsheet and I'm trying to have it autocalculate data, but I'm looking to find the most often recurring text values. This spreadsheet is broken down by month and I'm trying to have one box give a "running total" for the year as the user fills in the data, but obviously we...

Hello All, I've been trying to figure out a clean way to determine and show how frequently a cell value occurred based on another cell. Here is my example below: For automotive spark plugs, I want to know where spark plug AC_104017 was stocked the majority of the time. The answer is warehouse...

Hi all, new to this site. I'm hoping to find an answer to this. I have been looking to figure this out for some time, and have tried a couple of methods that don't work quite right. I want to find the median in a frequency distribution table in excel. I only have one sample group to work from. I...

Afternoon, In the below example I am trying to work out in what week the credit can be taken, based on the total invoice value (by customer) exceeding the credit value. I have tried variations of MODE, MAX and INDEX but no success. any suggestions would be greatly received. :)

Hi all, i have the below piece of code that i run every 200 milliseconds. It works fine however i am looking for a better, more efficient way of producing the same result. I use AutoHotKey to get information from Excel and quite often i will get a Callee error, i assume this is because Excel is...

Hi there, I have several survey question responses. Many of them are paragraphs in single cells. I am wondering if there is a way for excel to look at every word (not just the cell as a whole) and return the most common words. The problem I am running into is that I want to look at each...

Hi there, I am somewhat new to macros but getting better each day, much thanks to this forum. I have been fighting a macro for a while so I thought I should ask. I would like a macro that autosaves the current workbook every 5 minutes without opening a dialog box or whatnot. Just as if they...

Trying to use mode on data with negatives times. <colgroup><col span="2"></colgroup><tbody> -0:11 #value ! -0:06 #value ! -0:03 #value ! -0:05 #value ! 0.01 0:08 0.00 0:00 0.00 0:01 The #value is removing the seconds if present formula INT(CJ15*1440)/1440 I'm removing seconds...

Hi I want to understand Developer-->Design mode and what is used for. I read this post https://www.mrexcel.com/forum/excel-questions/32669-design-mode-vba.html and Parry said: ""If you select the Control Toolbox to draw a control etc, you will notice that design mode automatically comes on.""...

Good Afternoon Mates! I want to make an excel sheet which will not allow the user to take print until the the latest changes are saved. Actually I have created a file which requires "password to modify". Without entering the password, one can access the file with "Read Only" mode. But, in read...

In edit mode, when one letter is highlighted and left or right arrow key is pressed, usually, no letter is highlighted anymore. However, recently, I highlighted a letter, pressed an arrow key, and the next letter was highlighted. This is quite handy if I need to replace several letters in a...

Sub Create() Dim i As Long Dim xNumber As Integer Dim xName As String Dim xActiveSheet As Worksheet On Error Resume Next Application.ScreenUpdating = False Set xActiveSheet = ActiveSheet xNumber = InputBox("ENTER NUMBER OF TIMES TO COPY THE CURRENT SHEET") For...

To see the evaluation of an array formula, one can highlight the array formula and hit F9. Hitting ESC should exit the evaluation mode and go back to display the array formula. It has happened to me a few times that ESC doesn't show the array formula. I was stuck in the evaluation mode. Any way out?

I want to enter a formula in cell B1 This formula will show the MODE of the values in a range that follows a specified number in C1 E.g. If C1=10 Then B1 will show the mode of numbers that follow 10 in a range B2:B10. Which would be 5. If C1=5 then B1 would equal 4 eg B2=10 B3=5 B4=4...

I want to enter a formula in cell B1 This formula will show the MODE of the proceeding values that I specify in cell AI E.g. If A1=10 Then B1 will show the mode each number in a range B2:B100 that proceed a 10

I have Office 365. Whenever I start Excel or open a new file with Excel, it opens (or goes to) full screen mode. I can find no way to stop this from happening. Any ideas?

Hi All, Just curious is there a difference in saving in Developer mode to saving in Workbook mode? The reason I ask is I was working on a (for me) complex VBA script and would meticulously click the "Save" button in Developer EVERY single time I made a change. I had to run an OS update (on my...

When running a macro in "Step Into" mode it performs correctly. When running the same macro in "Run Sub" mode it fails every time. In the "Run Sub" mode I receive an "Exception occurred." error message followed by "Run-time error '1004': Method 'Range' of object'_Global' failed" message. I am...

This is probably simple for you experts out there. I've tried so many ways, and in so many locations w/in the code, but none are working for me. Please help! All I’m trying to do is get data from CELL RANGE B4:B4000 to copy automatically to CELL RANGE J4:J4000 should CELL RANGE J4:J4000 be...