occurs

Hello, This is the first time where I got an error that I cannot find anything online about. I don't know when this issue occurs but sometimes randomly I get messages "Error in Activate Procedure" or "Error in Deactivate Procedure". Can anyone help me on this?

Hey Folks, I am trying to go through a lot of data values and I need a formula to identify the following: 1. How many times a value occurs after another - e.g in column A row 15 the value 5 occurs, I need to know what is the next value that occurs in row 14 after the value in row 15 and so...

Hi, I have catalogued my record collection and wondered if there is any way to find out which Artist's name occurs most in the Artists column, I don't require a count as such I just want to put the name that occurs most in another cell for stats purposes, any ideas?

Column A keeps a running total of certain events, day by day (row by row). When an event occurs on a day, the total is incremented. Whether an event will occur or not on a given day is unpredictable. Therefore some rows retain the same value as earlier rows. A 4 5 6 6 7 7 7 8 9 9 9 10 11 12...

In B2, I have a date. In AV2, I need to know how many times the day of the week (in the date) occurs in the month. Any help will be greatly appreciated. DJ

I use auto refresh connections, set to every minute. It seems to clear my clipboard so if I copy something and a refresh occurs I can't then paste. Is there a way around this?

Hi all, I am trying to work out some data analysis on a currency pair. I wanted to get the date for the same value that occurs 2 times or more. I have counted in my files value that occurs 2 times: 78 times and value that occurs 3 times: 12 times. But I cannot work out a formula that show...

Can someone help put together the proper code for the following? IF an error occurs upon the following ... Windows("CORPORPF.xlsx").Activate Then open file "CORPORPF.xlsx" (Full file path is V:VAI:CORPORPF.xlsx") If no error occurs then ... Windows("CORPORPF.xlsx").Activate Thank you for...

Hi, I am looking for a solution to rank using multiple criteria. I can provide a sample set if needed but wanted to try without having to do that first. Column B contains my first identifier. There are multiple different values here. Column L contains the value I want to rank for each unique...

Hi Can anyone help me work out the following? I have 9 sheets in the same workbook with cells variously populated with 0 or 1. In a separate sheet I want to fill a cell with "1" if 1 occurs in the same cell in any of the 9 sheets, or "0" if it doesn't occur at all. I have tried using the...

Hi, I format a table row-wise with the following code: Code: Selection.FormatConditions.Add Type:=xlExpression, Formula1:="=MIN($T2:$DZ2)=T2" Selection.FormatConditions(1).Interior.ColorIndex = 37 and this, if an "x" occurs in a cell: Code: If InStr(1, rngCell.Value, "x") > 0 Then...