unique values

Hi everyone, I'm working on a VBA which will scroll down column K of a data page selecting the unique values and pasting them to different worksheet templates. e.g. the first unique value will be pasted into cell A2 of the first pre formatted worksheet ("Template1"), and the second unique...

I have a worksheet full of data. Col A shows co_code. Each Co_code can have 1 or more rows of data. I would like to create a macro that adds and names a sheet in the same file, for each unique co_code, and then copy the applicable rows/information to the respective worksheet. Hope that makes...

I am really stuggling here guys so any help much appreciated. I need to count the amount of unique values in a range, but only count unique values that also have a seperate condition. To help illustrate with the 2 column dataset below.... Colour Letter Yellow A Yellow A Green B...

Hi all, In the sample data below, I need to find the number of unique codes in column A coresponding to "M" in column B. Is there a simple formula I can use? I'm using Excel 2010 if that changes anything. A B 1 1233 M 2 4562 M 3 1233 M 4 7625 S 5 7352 S 6 4562 M 7 2447 S Thanks!

Extract unique values with multiple criteria</SPAN> I have approx 20,000 record in an excel sheet, wanted to pull the unique values of D column based on the three different criteria. </SPAN>Date= B Column Color= C Column Values= D Column 1st criteria = From Date = Cell F4 2nd criteria = To Date...

Hi. I have a list of colours, most of which are repeated. I'm using the following formula to return the unique list of which colours are contained but I need to specifically exclude black and white. =INDEX($A$1:$A$29, MATCH(0, COUNTIF($A$30:A30, $A$1:$A$29), 0)) This is the range: <TABLE...

Hi, I would really appreciate if you could help me. I am trying to count the unique values in a column based on possible duplicate entries in another column. I apologize for not being able to attach a file/picture of the data but it look like this. A1 = "Customer" A2:A9 has values...

I have a spreadsheet(Detail) with thousands of rows. Column(A) has the Date of the Invoice, Column(B) Invoice number, Column(C) Client Name, Column(D) Product number, Column(E) Quantities of each product, Column(F) Total Amount. There are multiple entries for some invoices, sometimes as few as...

I have a large data set with many complex formulas, and I started running out of resources getting errors. I've created a VBA procedure that will import a new data file, set up the appropriate formatting, named ranges, etc. The rest of the spreadsheet updates automatically using many VLOOKUP...

I'm trying to sum cells in column B, if their value in column A is the same. Unfortunately the values in column A will be different everyday. The way I do it currently is to use the advance filter to copy unique values of column A to column C. After I know the unique values in Column C I run...

I have a set of data 12 columns wide and up to 2,000 rows. I need to display the unique values of column 11, based on column 8. I have already used in column 16 {=INDEX($H$233:$H$10055,MATCH(0,COUNTIF($P$233:P233,$H$233:$H$10055),0))} to show me the unique values in column 8. Now, I need...

I have a scenario where I would like to get a count of the number of unique values in a column A, but only where the value in column B is "Y". So in the example below, the count should be 7, because there are 7 unique values in column A, that have a value in column B of "Y". I've found...

Hello, I have this formula to give me the number of unique locations and it works fine for cell J1: =SUM(IF(FREQUENCY(MATCH($B$3:$B$22,$B$3:$B$22,0),MATCH($B$3:$B$22,$B$3:$B$22,0))>0,1)) What I am trying to figure out is how to populate cells N4:N5 and N8:N9 for unique locations by Fruit &...

Hi all, I've managed to modify some code I've found on the site (Thanks RoyUK!), that I would like to perform an advanced filter on my data and create a sheet for each unique value, then copy and paste the data for the unique value. The code below, currently works if I use the file I...

I am using Excel 2010 and need to display a unique value, based on another unique value. In my data I have a "Program #", which I was able to narrow down the "Unique Program #" values by using the formula: {=INDEX($H$178:$H$10005,MATCH(0,COUNTIF($N$178:N178,$H$178:$H$10005),0))} I found the...

Hi, I have a spreadsheet set up similar to this: <TABLE style="WIDTH: 148pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=197 border=0 x:str><COLGROUP><COL style="WIDTH: 17pt; mso-width-source: userset; mso-width-alt: 841" width=23><COL style="WIDTH: 43pt; mso-width-source...

Does any on know of a formula that will only return the values in Column B only if it has an "X" in column A (without skipping a row). Reference List A B x Item 1 Item 2 Item 3 Item 4 Item 5 x Item 6 x Item 7 x Item 8 Item 9 x Item 10 Returned values: Item...

Hello. I would like to know how many times a value is listed. e.g. a a a b b c c d d d d result to show as: a 3 b 2 c 2 d 4 I've seen postings on how to do this if your values are numerical (using FREQUENCY array), but not with generic data. I appreciate the help!

Hello everybody, my 1st post. I have checked for similiar posts here but not quite what I need. I need assistance with a formula to return all unique values pertaining to just one criteria from an ever expanding data base. It is to be non VBA and not using filters. The data is Horse Racing...

Ok, I came up with the need of modifing something already solved here is the case. In Column A you can see the serial, Column C states the ammount of times that serial is in the column and only displays this number the first time it appears in the column; formula [...