no duplicates

Hi Everyone I seem to be having problems and I just can't figure it out. Been googling a few days now without any clear answer. I have this sheet: ABCD1Primary ColorPrimary HEXSecondary ColorSecondary...

Hi all, I'm brand new to writing VBA code so need all the help I can get. I have got 'N' number of files located within a folder (for sake of argument use C:\Users\wthomas\Desktop\Data), with the files I need all following the same naming convention "MAL1234567 Data.csv". This folder will...

Hi Excel friends, Looking to solve this problem without using an array formula: name value Conditional Rank (formula required to solve for this column) a 2 1 a 2 1 a 7 3 a 5 2 a 5 2 a 15 4 b 15 3 b 15 3 b 17 4 b 2 1 b 11 2 Basically I want a formula to give me...

1 workbook, 2 Tabs. tab 1 is raw data with multiple rows and columns. tab 2 is where I want to simplify the data, 1 Row per account with dataspreading out in columns instead of rows of partial duplicates. tab 1 A B 1. 1234 Follow up 2. 1233...

Hello! I have the following set up Column A - Date of Transaction Column B - Transaction Number Column C - Transaction Category ("Purchases", "20% Off Sale", "Employee 10% Off Discount", "Comp") Column D - Item For example: <tbody> A B C D 11/15/18 19816 Purchase Candle 11/15/18 19816...

Hi, I'm sorry if this has been answered before, I'm new to excel. My problem: Im trying to build a list of specific values to find in column A (The Actual Sheet has text not number in columnA), Thus Column B has the Criteria to find in Text form, and Column C is the output with no repeats. No...

I am using the below code (provided by Tigeravitar) to randomly select statements to be audited and it is working perfectly with one exception: There is nothing in the code to keep from selecting the same statement twice. I need to randomly select X number of statements without any duplicates...

Hi Everyone I have a sheet contain some product numbers (No duplicate) with blank 9 values needed to be filled as screenshot. Another sheet is the values of each product number but its contain more than 1 value as screen shot. The question is "Can I use VLOOKUP or other function to fill...

Please, help me modify the function to get instead of an array a string of items separated by semicolons. Now by pressing F9 I get ={"item1","item2",...."itemX"} but I need just item1;item2;....;itemX Function NoDups(rng As Range) Dim arr(), i&, s$, x arr = Intersect(rng.Parent.UsedRange...

So I have an issue I've been trying to resolve on a spreadsheet I created. I'm using the index/match/iferror function in order to populate information on a separate tab in my workbook. The formula I'm using is pulling the pertinent information, however, when it comes across a field name that is...

I have a large batch of data, below is just a short sampling of it, that I am trying to report on. If the same store, on the same date, had the same style I only want it to be counted 1 time when I pull the data into my pivot table. I've tried concatenating those 3 elements; Store Name, Show...

Hi I have a table with multiple columns and I want to calculate the number of SKUs using their codes without counting the duplicates with the condition of this sku being small griller, regular sku and in june my table looks like this month sku code sku type family 2 jan 1234...

This should be easy...I've been playing with it for days but can't find a formula that works? Can you help with a formula that gives the result below in a column of random letters? I want to find the letter(but only once) in the result... <colgroup><col style="width:48pt" width="64">...

I'm trying to make a collection out of a list of items in cells. Each cell may or may not have a few items separated by ","'s... I've got that part down...At least I think... but then I get to line 9, my DontDupe collection is empty... I expected it to possibly just hold the last added...

Hi Everyone, I need a little assistance with the VBA code for sending emails from Excel via outlook. I am still learning VBA coding and I would like to filter or sort values before sending out the automated email without duplicating the values. For example:- The email should go out when...

***I'm using Excel 2003*** I'm working on a spreadsheet to track my stock trading activities for one year. I used the following formula to give me a list of all the stocks traded without duplicates: =INDEX(D$5:D$4244,MATCH(0,COUNTIF(J$4:J4,D$5:D$4244),-1)) However, I'm having difficulty doing...

I have a workbook that tracks stock transactions. There are 53 sheets in the workbook labeled "1" through "53", each one being one week of transactions and each sheet is identical. I have one additional summary sheet that compiles the weekly data into yearly stats. I would like to take the...

Hi all, I am looking to pull together a spreadsheet that counts up the number of products that I have if they have sales e.g. PRODUCT Year 1 Sales Year 2 Sales A 50 A 0 B 20 C 12 D 0 D 16 E...

I am trying to use INDEX/MATCH to locate data, but I do not want duplicate results. Could you take a look at my example below and let me know if you come up with anything. I need to net the Doc IDs with a negative amount with Doc IDs that have a positive amount equal to or greater than the...

Hi Guys, Need some help with Staff Sales and Random Picks (horizontal) Everything I've seen so far for this kind of thing has been vertical. List of items available for staff sale and percentage off (usually 70%) Range: L8 to XXX8 (rightmost column, whatever letter it turns out to be) Names of...