Total IDs with Code 60
Total IDs with Code 345
Total IDs with Both Codes
[Code] .......
In column “A”, there are 14,000 ID Numbers. In column “B”, there is either a 60 or a 345 code beside the adjacent ID number in column “A”. There are duplicate IDs, some with same code and some that have both the 60 and 345 codes. I need to count ID numbers with code 60, code 345, and the IDs with both codes without duplication.
I have to type a an ID in column D of a worksheet called �restricted funds�, I have 13 sheets in that workbook and each sheet has in column D some IDs, I can not type a duplicate ID, in the that sheet. What is the best way to avoid no duplications. IDs are simply numbers.
On Worksheet Data 1 Column I there is a column of data with "some" duplicated text entries.
The data is sorted so that all of the duplications appear in a blocks, i.e.
This is the first This is the first This is the first This is the second This is the second This is the third This is the third This is the third This is the third This is the fourth This is the fifth
I want to - Starting in Worksheet Data1 cell I4 Copy A4 to Worksheet Data2 cell A4
Then go back to Worksheet Data1 cell I4 drop down to cell I5 and if the data is the same as the data just copied drop down a cell and keep going until it reaches a cell with different non duplicated data.
Then Copy that cell to Worksheet Data2 cell A5
So that I end up with a list of data with no duplications.
I would like to Compare Column A with Column B, if Column A contains text or numbers anywhere in Column B, then remove the corresponding rows not just in Column B, but Column C and D as well for that row.
I have a master sheet that has 3500ish names on it, and another sheet that I'll need to drop in a list of about 1000 names. What I need on the master is a way to check the dropped in data, find duplicated names, and flag them up.
Now, I believe what I did last time was have a true/false method of telling me if they're on both sheets, then use an IF formula to instead make Trues into "yes" and Falses into "no". However, I can't for the life of me figure out how I had it previously checking both sheets and confirming/denying if they're on both sheets or only appear once.
I have two workbooks (source and target) I want to copy column A in the source workbook to column A in the target workbook and remove duplication in the target workbook. If any.
[Code] .....
Found this in another forum it works for the copy but not the removal of duplication.
We have a company and need to automating workflow.
The Master sheet contains incoming mail details by customer. Each employee is assigned a set number of customers to respond to. We want the information on the Master sheet to filter to a specific employee assigned sheet. On the employee assigned sheet, once filtered, they are to provide updates in column E
Date Reference no. Name Employee ID 16-Feb-12 S/S/1
[Code] ........
We need a macro that can filter customers' details to the specific employee assigned sheet based on the employee ID in the master sheet. For example, all customers assigned to DW (i.e with the 'DW' employee ID) filters into a sheet called 'DW'. Please note that the Master sheet is a continuous log updated daily. This macro must not duplicate information previously filtered once the employee enters a status update in column E.
I cannot get various formulas (Countif, Match, Frequency, Etc) to work properly.
I am trying to arrive at a total number of matches of numbers in cell range B1:G1 with any numbers entered into the cell range of K1:P11 and have the total of matches display in cell H1. However I do not want to count duplicate numbers from the K1:P11 cells. (if the number 5 in posted in K1:P11 multiple times I only need it reported once in H1)
B1:G1 is the constant and the numbers will not change - K1:P11 cells will be populated by adding numbers until the all the numbers in B1:G1 is completed and match.
I was given this spreadsheet to count attendance by entering the entry date and exit day, however it's counting the first day and the last. I'm needing it to only count the first day and not the exit day.Book2.xls
want to count up from a certain number but rather to a certain number.
Basically I am making a spreadsheet of products which already have product ID's, however there are 1000's of these. So I am doing them by manuafactuer, so some sheets do indeed start from 1, but pretty much every other sheet starts from a number like 1300, or even 2563.
how I would go about making excel automatically fill in the ID field?
I have a spreadsheet with 3 sheets, the first sheet is to be an overview of the entire workbook used to keep track of training,
The last sheet (Called Raw_Data) contains various coloumns, the two I am interested in is the training course and the name, as someone completes a course I record what the course was, who did it and date/time of start/finish,
What I would like to do it to count on the front sheet how many times someone has completed a course
Operational Overview Joe Blogs
Work Pratices Joe Blogs
Incident Handling Processes Joe Blogs
Training Paul Smith
Incident Handling Processes Joe Blogs
From the above table Job blogs should flag in a cell for Incident Handling Processes twice, Is this something that can be done via a formula as I am trying to avoid VBA.
So I have an annoying dataset to work with. The first column contains ID#, string, string, string, ID#, string, string, string, string, ID#, string, and so on. It is basically a list of patient numbers with a list of their appointments listed underneath them. I need to find a way to count up the number of strings for each patient, like shown below:
Patient# Count
101 2
Had an appointment
Had an appointment
Deleted-Had an appointment
The format isn't too important. The data I have is basically column A, and I want to create column B.
Is there a function in Excel that will count cells that are different from one another? I.e. it would not count the same value twice. For example, in column A:
a a b a b b c a c
The result would be 3. However, if I replaced the first "a" with a "d" I would get 4 as a result. Basically I want to know how many different arguments there are in a list. I could not find a function that does this in the Excel list of functions.
How do I get cell C4 to give me a total of the times a score in column C is > than opposing score next to it in coumn D? Also, a total in cell D4 to show the number of times this team's score was less than the opposing score in column C. This would be for a running Win/Loss record.
I am now attempting to do the same type tally except I want a tally for "in conference" Wins/Losses.
I tried the same "SUMPRODUCT" formula as before except this time I held the control key down so as to use only the cells desired. I'm getting "VALUE" for my answer though.
The row I have added in for in conference tally is row 3.
All blue colored cells are for the ACC conference and the green are for the SEC.
Is there a way to get the win/loss figures for selected cells / rows only?
A quick background. I have a large dataset on radio stations in the US. The data (that I will illustrate below, and sorry if it looks like a mess, I run on a mac and don't know how to get the right structure when I paste it in) contains the following:
Column A: Owner (owners of radio stations - by their name: e.g. Clear Channel)
Column B: Owner (same owners above, but with corresponding ID-numbers instead, e.g. 83)
Column C: Market (a market which holds both owners and their radio stations, e.g. Boston)
Column D: Market (same as market above, but with the corresponding ID number instead, e.g. 21)
Column E: Number of stations - this column represents the number of stations that a particular owner has IN ONE MARKET. OBS: A owner with 4 stations in Boston, will have four cells, in which all of them say "4", so be aware of the problem with doubles, tripples, etc. ........................
i have to create a summary of the productivity of the administration staff in my office. i have a table of raw data that shows the jobs they open each day, but i need to find a way of counting the number of those jobs.
i've included an example so that its easier to understand what i'm getting at.
on the first sheet (Jobs) i have the table of raw data. each administrator opens jobs each day which can either be S (standard) or W (Warranty). the second sheet (Summary) shows the way i need the data to be summarised. effectively i need to narrow my count by 3 criteria (Date Opened, Job Type and Administrator).
i've used DCOUNT functions in the past to count data by more than 1 criteria, but as this system will be in place for every day of the year, that means i would have to produce a table for every administrator and every type of job and every day of the year. which would be 3650 different tables, and that's too many.
is there a way i can do this more effectively? or can i somehow make the DCOUNT tables relative so that the table can look up the date required, reducing the number of tables required to 10?
in cell F5 I would like to know how to count the times between 13:00 am and 14:00 so if theres 3 times it will show a 3 i havnt got a clue what formula to use.
I'm trying to display a 2-column table that tells me the number of games broadcasted by each channel. The code has to figure out the channel name itself, without me specifying the channel name in it. How can I do this in VBA?
Game1 NBC Game2 CBS Game3 CBS Game4 CBS Game5 FOX Game6 CBS Game7 FOX Game8 FOX Game9 FOX Game10 NBC Game11 ESPN Game12 NFL Network Game13 FOX Game14 CBS
I have 8 columns. The first column is a counter The 7 others contains codes for faults on 7 different channels that get theres value from manual input. The codes has a value and from all this i get a graph. Count/points. Now i need to know when criterion is met and mark the count in the graph some way.
Fault codes: A B1-B13
For example: Criterion 1 to be met: Fault B1 or fault A
Criterion 2: One individual channel >B1 or >two channels with B1 or > one channel with A
Criterion 3: One individual channel >B2 or >four B1
The criterion is judged by row. So when it find a row that match one of these i need that count to be marked in the graph and then that criterion is set and not needed to be checked no more.
I am trying to count the number of patients that were in a hospital during specific times (time and date). I want to know, by hour, how many patients are in the hospital. I am using a month of data as my "sample size".
I all the start times (e.g. 3/1/2008 12:35:00 AM) and leave times (e.g. 3/1/2008 5:52:00 AM) and I want to have the patients by hour for the month. So I want to know that during, as an example, 2:00:00 AM to 3:00:00AM there were 40 patients in the hospital.
So I will eventually combine all one hour periods (e.g. 2:00:00 AM to 3:00:00 AM) for all the days, but it's counting (patients per hour)
if i want a cell to count certain value in a range what formula o set, i know that CountA function counts cells with words in them but it counts everything, i want a certain word(s) to be counted.
for example i have...
New Old Take Over
and i want C11 to count 'New' in range of B12:B20 .
how to?
and 2nd how to Name the Columns, i mean Instead of regular A,B,C how to set a name or title for them... and how to keep them on top, i mean as i scroll down columns keeps there only sheets scrolls up and down so i can see given Column Names/heads.