uniqu values

I have a following table. Name Value X 10 Y 20 Z 30 X 40 Y 50 Z 60 X 10 Y 60 I wish to extract all the unique values corresponding to the name in separate columns. The output shall come out like this. Since X has 10 as a value twice, I want it to be considered only once...

Please can someone tell me how I can amend this formula so that it returns all numbers in column F up to the last row, i.e. so that I can use it repeatedly on workbooks which have different rows of data. Sheets("Lists").Select Range("A2").Select ActiveCell.Formula2R1C1 = _...

Hi, I have the sample table below and what I need to count: the total unique EEID that their type is R ABCDEFGH1EEIDTypeQuestionsStatusResults2611RQ1Completedis to count how many EEID that their Type is R and Completed the Q463611RQ2Completedtotal of unique EEID that their type is...

Hi, Required a formula help to as per data available in working sheet, return a sum values in column C as based on task ID and Ledger by ignoring duplicates whatever available in column A and B (task ID and Ledger) in the summary sheet. Expected results are available in summary sheet column E...

I have a sheet similar to the below data. Can we list out the unique names for each location? as shown in the below "desired output" section? Location Names Location 1 Name 1, Name 2, Name 4 Location 1 Name 1, Name 4 Location 1 Name 2, Name 3, Name 5 Location 1 Name 1 Location 1...

Hello everybody, I want to count unique value with following formula, which usually works, but does not for this task. The extra add on is Data'!$AA:$AA;"*Dahl*" (I believe this is the reason it's not working) =SUM(--(FREQUENCY(IF(('Visit Data'!$AD:$AD="Distributor")*(ISNUMBER(SEARCH('Visit...

I am looking for a way to count unique values in column E based on column M = "Installer/contractor" AND column O = {"A1";"A2";"A3";"B1"B2"} Currently my formula is: (it only includes column M) =SUM(--(FREQUENCY(IF('Visit Data'!$M:$M="Installer/Contractor";MATCH('Visit Data'!$E:$E;'Visit...

Hello All I am trying to create a macro that will Compare data in two columns (on two sheets (sheet1 Column B, sheet2 Column A) and add any missing unique values from sheet 1 to sheet 2 Sheet1 column B Items#s Item 1 Item 2 Item 1 Item 4 Item 1 Item 2 Item 3 Item 4 Item 5 Item 6 Sheet2...