unique data

I am trying to create an array that references a range to fill the array. The problem I am running into is that the reference range contains a lot of duplicate values and I only need unique values added into the array. Does anyone have a good sample code that can either remove duplicates from...

<tbody> Invoice # Order # Customer # Item # Item QTY 100001 1001 10 XB33 2 100335 1021 10 XB33 6 103009 1103 10 XB33 3 </tbody> Very small sample table. But let's say I wanted to add 2 columns to this. The first one would be labeled: Reorder? What I'm looking to...

I've seen posts about copying and pasting data filtered for uniques before. I found one that does almost exactly what I need it to do. Current code searches all my sheets through column A for all unique values and presents them to me on the sheet with my command button. What I need it tweaked...

I am working on a project in Excel 2013 in which I have data on two separate tabs. I am looking at the time stamp that a call was placed in one of our systems and am trying to use a lookup to find the closest corresponding time stamp on the orders data (on the other sheet) and return a unique...

Okay ! I got a two huge separate excel sheets. One has values upto 90k (Sheet 1) and other has 7k (Sheet 2) Now I want to find the duplicate value in sheet 2 present in sheet 1 and have a all unique values to be present in sheet three It be some what like this <TBODY> Sheet 1</SPAN> Sheet...

in column C5:C9999, i have values appearing as 40, 50, 60, 50, 60, 40, 40 I want total of 'unique appearance' no. How to accomplish? Answer for above is: 40+50+60=150

Good afternoon, all. I have what I thought would be an easy thing to do, but I am having some troubles. I've researched and read many threads here to see if I could find it before posting here, but I've not had any luck. I'm on Excel 2010, too. In my spreadsheet all records are unique rows...

My workbook has two workseets that I need to split by an area and then save each new workbook under the areas name. Before anyone says combine the two sheets to make it easier we can't; we have to have 2 separate sheets for this particualr report Start File: This is the file that contains all...

Hello all, I've been charged at work with speeding up some spreadsheet creation via using data validation lists. I've been trying different things for the past few days and have hit a wall. Lets say we have 3 lists; Plant Classification, Name, Sub Species. Some mockup data would look like...

Hi, I am tearing my hair out on this one. I'm not very familiar with macros or complicated formulas in excel. I can run a v-look up or a basic sum formula, but that is about it and I need help with cleaning up a spreadsheet. I have 4 columns: Turn-In Product # Product Name Color Turn-In...

Hello, I have a spreadsheet that contains a number of rows: some with a column heading of unique ID# and some rows with duplicate ID#'s. For those rows that contain the duplicate ID #'s, I need to be able to transpose a number of columns data to row data (within a group/ subtotal/ data sort...