I am trying to create a VBA script to look through an automatic generated report on one of the tabs called "All". What I need it to do is look through Column "A" and find the unique Entries and how many times these unique entries appear. Then put the results in a new tab called...
I have two columns with data. Column A has names of sectors and column B has names of accounts within those sectors. The accounts will be repeated over several rows. What I need is a formula which will stack up the unique accounts per sector in different columns. It would be great if...
Hello everyone. Really struggling with something - I know this has been posted in other places, but I'm having a hard time understanding the solutions.
I'm trying to create a function (not in vba) that will count the unique IDs where it fits the criteria: Date>8/2, Date<=8/7, Hours>0...
This is my first post looking for assistance. I have found the majority of what I need by searching forums and running Google searches, but I have gotten stuck on a project, and I hope you can help. In general, I want a drop down menu of unique item names which fit multiple criteria...
Good evening all
I have some code which i have borrowed to add some new sheets to a workbook based on the contents of column a. The code is
Dim cell As Excel.Range
Dim wsWithSheetNames As Excel.Worksheet
Dim wbToAddSheetsTo As Excel.Workbook
Set wsWithSheetNames = ActiveSheet...
I have function to count how many many times name from column C (sheet M1) appear in range (sheet CSTG, column B):
Column D - only count
Now in column Q (sheet CSTG) I have different values, like...
I want a column to allow unique values only. Source data is from third parties and is an identifier. List is long and prefer to use Form for data entry but don't wish to have to do search to avoid duplicates before entering or use find duplicates after (both band-aids.)
I should be able to use...
I want to track an individual across a number of years. I have their name eg: Smith, John and I want to track this across different years databases and find how this person's qualifications changed across years. I was thinking of assigning a serial number to an individual but need...
Hello, Please advise me as I am just learning how to use these functions.
I am trying to use a formula that counts unique text values from this range:(Patient_level!C6:C15000)
while meeting certain criteria ('yes') in this range: Patient_level!I6:I1048576.
I have working formulas for both...
Hi. I was trying to create a drop down list, where the user could select multiple options from the list, but still the options selected must be unique within a Cell. For Instance: if a Dropdown has A, B, C as values, selecting A and C is a valid selection, but selecting A, C and A is not.
im new here. i found here many aswers but now i have problem where i cant find way out :/
I have data:
I would like to take info in a column and get a list of unique values
NOTE: the data is contained on SHEET1 and i will have the formula on SHEET2
I would like to sum up the values in column B for...
Here is a sample (simplified) scenario that I am trying to resolve.
<COLGROUP><COL style="WIDTH: 54pt" span=5 width=72><TBODY>
Trying to make it into this by removing all the...
i'm having trouble trying to count the unique values/entries on column B (name) that has the ff conditions the date should be from july 1-5 for week one, week two ..etc, and team (red, etc..) as seen below.
if i need the count of unique names for the first week on red team it should return...
Thank you for this amazing Forum!
Im having some sort of trouble in excel
Here's the situation
I ve got a really long column (3000 entries) with product codes and corresponding quantities.Since each product can be found in different locations there are multiple entries of the same...
I have a list of names on one tab which is constantly updated; I need to extract the unique values and paste them into a seperate tab.
I know I could use an advanced filter and paste into the relevant sheet but as the spreadsheet gets updated several times a day, it would be much easier if...
I hope I have posted this in the correct section. I am not Excel savvy, i can do the basic formula but I am struggling with a pivot table.
I am using Excel 2007 and the main table is the following:
Customer/Project ID / Engineer ID / Start date / End date / Hours / Average hours...
I have a column of numbers which contains numerous repeated entries and blank cells. The list is free to expand as people can continually add to the list. The list can only expand to a finite number of rows, say 150.
Is it possible to use a bit of VB code to extract only unique entries and...
I am not sure that this is possible to do without creating a Helper column of sorts, But here goes I would like to define a range in the Name manager that only uses the unique entries, and this this will be used in data validation.
so the range is looking at the whole range of data...