I am looking to try and create a formula that counts occurances from a given date range >=20
So in month one the result would be 2 in month 2 the result =1
Your help is greatly appreciated
Hello, I'm looking for some help re-organizing some data and am hoping to use VBA to do it. The current macro gets us to this point, but now I'm stuck. What we want to do is change this:
Looking for a macro that can count the occurrences of the decimal values in column O2-O20 and count and write them from highest to lowest in Q2-Q20 .Any help much appreciated
P.S Your upload picture dont work on this website
I have 2 columns of ID's, both of which may contain duplicates or blanks. What I need to do is if an ID in column A has textlonger than 3 characters in the same row in column B then *every occurance* of that Id in column A should be coloured red. I am basically flagging up that if an Id in...
I'm trying to count the number of cells in column B (B1:B8) that contain one of a couple of words from a list (C1:C3), not occurances. Also, I only want the cells counted if the dates next to them in column A are older than Today()-60. The cells in column B sometimes contain more than one word...
I'm working with a database full of records. Most of them are duplicated.
The code is importing a excel file.
Arrange the data by column A. Replace data in column C. Converts time format. Add a new sheet.
Also, it counts the records in column A and put the occurances in Sheet2...
I have [income]- (REVENUE) table of accounts, each account can have multiple instances for one month. how can I find the last occurrence of all the accounts in a month (and then summarize all of these latest occurrences)?
account revenue revenue_date
1 100 2010-01-01
I have a spreadsheet with adverse event data. Column A has the adverse event term exactly as the staff member entered it into the database. I am working on creating a report that counts the number of instances that an AE term appears in column A. The issues that I am having trouble...
Hi - I am trying to figure out a formula in Excel 2007 that will count how many meetings take place in any given full 7 day week ongoing (but always Sunday-Saturday). Column A has the meeting start date, column B has the meeting end date. The formula should highlight those meetings that fall...
I have a range B2 to F35 but this range size can change.
In the headings I have shooting range numbers and down column A, I have times in sequential order from the earlies to latest time. In the range I enter squad numbers so each squad gets to shoot. The number of ranges can vary as can the...
I am needing to count the number of calls in a call center between certain hours by date. Column A is the date, Column B is the time of the call. I am needing to know how many calls occurred on X date between the hours of y and z. I have tried various forms of the countif and sumproduct but...
I have a list of items in column A. I need to replace all the occurances of the word tor1 with the value in b1. The value in B1 changes frequently.
Could someone help me write a macro that would accomplish this?