unique values

Hello mrexcel family, I'm new one for this forum and I want to need your help. I want to find dublicate value's last rows and unique values then I want to write "use this row" second row with macro code. After that I will use this code in some userform design. For Example Data is ...

hi, I am trying to populate a drop down box with a column of dates and only want to populate unique values. I have tried the following code but it doesn't work. Can anyone please assist? Sub FilterUniqueData() Dim Lrow As Long, test As New Collection Dim Value As Variant, temp() As...

Excel 2013 64 bit <tbody> A B C D E F G H I J K 1 ID FCM FP FCLMS SD AED LAD WAEM ABP Note Formula Script Formula 2 ABC FT014 FT014 1 3 DEF FT014 FT015 FT016 FT016 FT016 FT016 FT014, FT015, FT016 1, 2, 3 4 ZYX FT028 FT016 FT016 FT016 FT016...

I have data as below Currency Location CAD 00002 CAD 00004 CAD 00005 CAD 00002 USD 00001 USD 00002 CAD 00006 CAD 00004 CAD 00005 USD 00001 I want to filter for CAD, then select the Location...

Hello All, I've written some VBA which turns an array into a stacked bar chart where series with the same name are coloured the same. However, having multiple series with the same name has led to a rather pointless legend with multiple duplicates. My main two questions are: 1) Is there a way...

Hi, I'm not very educated in VBA. My co-worker has created a Function Macro and I wanted to modify it to pull only unique values that have .pdf at the end. Would this be possible? Any info or help would be much appreciated! <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font...

Hi all, I'd like to extract a list of unique values from a 2D range. So, text values from A1 to D10, some repeat. And in another column vector are listed just the uniques. I browsed here, but they cover uniques from just one column, not a range: 3 Ways to extract unique values from a range in...

Hi All! I need to sum up a person's allocations across multiple worksheets, 6 in total. Any Suggestions? For instance, How many hours is Jane Doe Allocated across each book.

I'm trying to create an array formula based on data in 2 separate tables. The formula should evaluate the data in table 2 and look for exact matches based on the data in table 1. When it finds an exact match, it will return the value in the "Order #" column in table 2 to the "Order #" column...

Hi Please help. Not sure if this is possible or not! I have a list of similar phrases in column A. For example: tomato soup tomato soup heinz soup heinz heinz soup tomato soup heinz 57 Is there a way of Excel pulling a list of unique keywords from all those cells? So it would end up with...

Hello. I am attempting to count the number of instances of partial text matches for records that correspond with a specific month. For example, in the month of July 2015, I had eight accounts place 39 orders. I need a formula that will count the number of accounts active that month. I'm familiar...

Hello Mr.Excel Gurus! I am currently attempting to copy data from a column that has a mix of cell values; some are numbers, some are words, and some are blank. I am trying to create a list that will copy over only those cells with unique number values, ignoring the blank and word-filled cells...

Guys, I was busy with some project and found bits and pieces VBA codes by which I made below code more useful and thought of sharing. Add below code in UserForm_Initialize Private Sub UserForm_Initialize() Dim LastRow1 As Long, LastRow2 As Long Dim Ws1 As Worksheet, Ws2 As Worksheet Dim v1...

I am attempting to create a list from the unique data of 2 row. I have tried VLOOKUP, MATCH, and PivotTables and couldn't find what I'm looking for, I am still new to Excel and its various functions. An example of what I'm trying to accomplish is: In A1 to A5 we have: a,b,c,d,e and in B1 to...

Hi, I have about 1,500 rows of data as mentioned below. Everyday I would need to prepare a report for the previous 3 days. (That file contains only previous 3 days data). For each date, for each of the dealer, i need to count the product and generate a report as shown at the bottom... <tbody>...

Hey, I'm trying to populate a ActiveX ListBox through VBA with unique values from a two dimensional range, but I can't seem to find a way to both only get unique, sorted values and populate two columns with those values. That is to say, I have no issues with populating a single column in the...

In excel worksheet tab 1 I have a list of duplicate values. In excel worksheet tab 2, I want it to draw from tab 1 ONLY the unique values. Is there a way to do this WITHOUT having to do a copy and paste and filter for unique values? I want the unique values in tab 2 to update every month...

I have a large dataset and I need to count the number of unique entries in one column, if it belongs to one group or another (it is indicated in another column, e.g. it may give group ID of 23 or 34 or 193 etc). Ideally, it would be a formula which I can use across many entries (need to do this...

Hi, Thanks in advance. This site has always been so helpful and I expect to get an answer for this problem as well. I have given below table to show you example, what I want is set of strings in column B (sheet 1) should match its words with sheet 2 column a and sheet 3 column a if any word...

hi I am trying to find the first occurrence of a value within a set of values within bigger series and mark others as repeat values. The table below might help understand better. ID Unique/Repeat Supervisor Remark Count Expected Output A 1 MO NC 7 MO NC A 0 MO NC REPEAT REPEAT A 0...