unique data

Hi, I have to copy rows from one sheet to other in a same excel file. It's a repetitive task to be conducted on weekly basis. Consider following example. Name Devices code A Desktop 234 B Laptop 2345 C Television 3456 D Smartphone 7654 E Printer NA F Desktop 098 G Scanner NA...

Hi, I have a database in Excel, where Column A have 100 specific values, that are updated each month, and column B have a price, and Column C have the date which the values have been updated. But some month not all values are updated may only 60 or so. I need a way to get the values closest...

Need Help from excell expart, please.... In my below data, I want to find out according to column "B" - [Date], column "D" - [CustomerName] how many uniques time visited to certain period of date. My data is in a table and its filtered through column "B" - [Date] and I want my result to show in...

Hi. I have the following sample data, I want to do Sum the Value in Column E if the following conditions are met The date is within the month of July 2018 The Person is Adviser The Type is Initial or Ad-Hoc The reference is Unique. Where all 4 conditions are met, I only want it to...

Hi, I have a very large data set, 10,000 rows and 150 columns. I need to extract and display unique values from the rows. My data is arranged as follows. <tbody> A B C D E F G H I J 1 Boston 3 5 3 7 3 2 NYC 1 2 2 4 8 </tbody> Desired Result Display: <tbody> Boston 3 5 7...

Dear All, I have the the table as shown in below which contain column Date, Name, Doc1, Doc2 and i have to make resume as shown in next table. In that Resume, the data sorted by date 7 May 2017 and should be shorted ascending and unique (no duplication). Just wondering how to solve this...

I am having trouble finding a formula or VB macro to Count a Unique value in Column A and put the count in column C count them down until it finds another unique value in column A and starts the count over again etc... Windows 7 Office 2013 Columns A B C 2003 243 1...

I have an existing spreadsheet which has product information along with sales information. The sales information is grouped by manufacturer number. My end users want to also see the corresponding sku (i.e. product ID); however there are some manufacturer numbers which have more than 1 sku, so...

Dear, I have a data set among which there are many duplicate data and I want to find the unique data in separate sheet. <tbody> 1122 1133 1144 1155 1133 1122 1199 1133 1144 1100 </tbody> Now I want the data to be like below: <colgroup><col width="72" style="width:54pt">...

I have a dropdown that gets its reference indirectly from another cell. The referenced list is a table column that will contain any digit from 1 to 9 but not necessarily all of them and some will appear more than once. I can find lots of way to extract those unique values but This would mean...

Hi Folks, So today I was thrown a curve ball on a project I'm working on. I Have 3 sheets of contacts from 3 different vendors which are all different sizes. These Sheets have very little overlap besides a few columns..."FULL NAME", "COMPANY NAME","ADDRESS LINE 1" and maybe a few other columns...

Hello All - I am looking for a formula that would be in column B and marks the first unique text in column A as 1, and all duplicates as 0. I had a this formula work in a previous document, but I no longer have the document to reference the formula. An example below: Col A Col B Shelly...

Hi all, I have a list in column C (in sheet "Test"). I have a unique column A (in sheet "Articles") iam looking for a macro thats adding unique values to column A. So it has to campare both colums and add the unique values of column C (that arent in column A already). Anyone got an idea. A...

I have 6 worksheets: Aug (2015) Sept (2015) Oct (2015) Nov (2015) Dec (2015) Jan (2016) Each is formatted EXACTLY the same. The data contains individuals and their specific performance information for the respective period. There may be someone who appears on 1 or more sheets and their maybe...

Hi! This is my first question on this forum so I will try to be clear and specific as possible. I know it can get frustrating when you guys have to give solutions of unclear questions.:p - My purpose · I have a database of patients, and a userform allows me to manage this database...

Greetings all, I was hoping someone could offer their input and/or guide me in the right direction for an experimental data validation macro which could (potentially) either automate or streamline data input for my engagement team. In essence, I created a data validation scheme which seeks to...

Good day everyone. I have a task to randomly pick 3 random values from column A and store them in column B in cells B1,B2,B3. Column A contain string values. Column A has X number of available items. Sample: COLUMN A name_tag1 name_tag2 . . . name_tagX COLUMN B randompick1 randompick2...

I have a large excel spreadsheet where I need to merge rows on a unique identifier. I'm trying to develop an Excel VBA macro but still lack the proficiency to tackle this. Here is a picture of an example of what I'm trying to do. The data including the headers are all made up for the example...

I have a table with three columns: Style, Color, Size. What I want to be able to do is hit a "Next" button, and it will change the filter on the table to whatever the next unique Style is within this table. My Example: Full table: <tbody> Style Color Size Ardvarkian Red Small Ardvarkian...

Hi Guys, I have about 600 rego numbers for which I need to figure out below. 1) Difference between minimum & maximum odo reading for unique rego numbers 2) Days between minimum & maximum odo reading for unique rego numbers Below is an example of my data with 4 rego numbers I thought Pivot...