unique list

Column A on Sheet1 has many different remarks. I need to make a unique list on Sheet2 with values from Column A on Sheet1 but post it in one row. This is the idea: Sheet1: Column A 1 1 2 2 2 3 3 3 Sheet2: Column A------------Column B------------Column C...

Hello, Been searching high and low for an answer to my question with little luck (hoping i didn't blindly miss it). I have a set of data which changes each week and need to extract a unique list from it, i currently have a formula which works for me, but i now need to adapt it to include...

Does anyone have a formula for extracting unique values from a single column of a large (>10k records) list that doesn't bog down Excel? Formulas are desired, as replacing duplicates and using macros/custom functions are beyond most of my end users. The formula I usually use is similar to...

Hi all!! you can se on the top table the data base on the bottom table i need to extract unique names based on the fruit criteria let me know tahnk you in advance!Excel...

How would you get the list of unique characters from a column? Az Bbbn Zui Answer is A, z, b, n, u, I. For the answer the character can have its own cell. So A Z

If anyone can help me I would be very gratefull. I am looking to create a formula that will create a unique list of names, in a different location that considers 6 columns worth of data as well as the how frequent each name occurs. Here is an example of what Im working with...

I have two lists. I want to get a unique distinct list by comparing the sums of the unique values in list 1 that don't match the sums of the unique values in list 2. Is that possible? Sheet1 <colgroup><col style="WIDTH: 30px; FONT-WEIGHT: bold"><col style="WIDTH: 64px"><col style="WIDTH...

Hello, I've on my best to read through al the other rank posts but I'm till not seeing what I need. Basically I have a complex list of criteria that I need to rank within itself. For example: (CHANNEL) (SPORT) (GENDER) (RETAILER) (STYLE NAME) (UNITS BOUGHT) SG...

Dear all i have a following data, <colgroup><col><col><col><col><col><col><col><col span="2"><col></colgroup><tbody> S No Date Supplier Debit / Credit BILL NO Description Folio Debit Credit each bill balance 1 25-Jun-14 Asif Traders Credit 33 received bill 11 50000 2 25-Jun-14 Asif...

I hope I can explain this clearly, as I've had trouble searching for results online. My work computer seems to be preventing me from installing the HTMLmaker, so I'll try to explain as best I can. I have a database of employees and their clocked hours worked. I'm trying to create a tool that...

Hi guys, it;s Friday and i've already switched off, so I need a bit help :)) From below table, A1:B8 are data, I would need to get into G2 and below a list of unique entries those match criteria - entered D2. So in this case i put results - this should return list of unique control acc nrs those...

Hello, I am working in excel 2010 and I would like to create a combobox (list) using the developper ribbon that leverages a list of dates from another tab. I created the combo box and used a named range as the source of dates but I cannot see a way to select unique values only. Is there a...

I am having a huge amount of trouble with calculated columns, and errors with them when adding new rows to a table. I am trying to maintain a list of sales while dynamically maintaining a list of unique customers who make purchases. I am using a helper column that counts new customers are they...

Hello again, i have a range named MATS (F9:F58) and this formula in C9 and dragged down 20 rows =IFERROR(INDEX(MATS, MATCH(MIN(IF(COUNTIF($C$8:C8, MATS)=0, 1, MAX((COUNTIF(MATS, "<"&MATS)+1)*2))*(COUNTIF(MATS, "<"&MATS)+1)), COUNTIF(MATS, "<"&MATS)+1, 0)), "") this is a typical contents...

My problem is that i have a column of (1 to 6) letter words. I would like to create a unique list showing all 5 letter words in that list sorted or unsorted. I would like this done by using an excel formula only. Is this possible? Thanks in advance for anybodys help.

I have checked that the array is populated but the following code is failing to tranfer the array values to column A of the 'Category' sheet. Any advice welcome. For Each x In tmpArray Cells(Sheets("Category").Range("A2").End(xlDown).Row, 1).Value = x Next x thanks mark

Hi All, I've been struggling a bit with a way to solve this issue; I hope that I can explain it well enough. I have multiple lookup sheets (approx. 12) in a workbook that are similar to below (which go down for thousands of rows of data) with Col. D actually being the most unique value. Each...

I am wondering if there is a formula that will create a unique list of numbers from a set of numbers. I don't want to do a filter as I need the formula to update dynamically. For example In column C a set of numbers will appear (from a formula that depends on a changing cell in cell A1), I...

I have worksheet 1 which contains three columns (shown below with some sample inputs) Wireframe. Test Type. Sub TestType 01.01 BVR Generic Validation 01.01 BVR Generic Validation 01.01 BVR Generic Validation 01.01 BVR...

I have question which have been driving me mad lately. I know it has to be hard to solve it, but I need to know if it´s possible (or not). I have in a column a list of values with duplicates. Is it possible to create a dynamic unique list with formulas from this list without using a helpcolumn...