# Sum Of Unique Product In Excel?

Nov 29, 2012

Have a data in given format:-

Name
No

abc
1

err
2

sd
8

[code].....

But i want sum of the no with same name, as given below:-

Name
No

abc
31

err
81

sd
8

Is there any function / macro to find the sum of the given product in column?

## Number Of Unique Customers For Every Possible Product Combination

Jan 15, 2010

I am looking for an efficient solution to the following problem. I have a sales table with two columns, titled C1 and C2. The first column lists the product sold, and the second column lists the associated customer.

Here's what I mean (though I can't figure out how to create neat columns in this post):

[C1] [C2]

Prod1 CharlieCo
Prod3 AlphaCorp
Prod2 BetaInc
Prod3 BetaInc
Prod1 AlphaCopr......................

## Conditional PRODUCT Function Formula (return The Product Of A List Of Numbers In A Column)

Sep 30, 2009

I am trying to use a PRODUCT formula to return the product of a list of numbers in a column, between 2 specified dates. The spreadsheet is arranged as follows:

Column BA list of dates
Column C & DNumerical data not used in any calculations
Column EThe numbers to multiply together
Cell A1Start date to be used in the PRODUCTformula
Cell A2End date to be used in the PRODUCT formula

The formula I have to multiply the data in column E, subject to the start and end dates in Column A is:

{=PRODUCT(IF(B15:B1000>A1,IF(B15:B1000<=A2,INDEX(B15:E1000,0,4))))}

This returns zero though works appropriately if I replace “PRODUCT” with a “SUM”.

## Dynamic Named Range For The Product Name On The Product Details Sheet

Dec 24, 2008

I'm working on a order spreadsheet system, and I have one sheet called Product Details, where the product name, list price and product code are found, these link to the Sales order page, and I need them so that they can be added to.

So far, I have created a dynamic named range for the Product name on the Product details sheet, and linked the the range via a list validation on the Sales order sheet.

The drop down list displays the products and can be added to by typing new product names on the other sheet.

What I need now is that when a product on the sales order page is selected, it draws the the list price and product code data automatically from the sheet, I tried using a normal vlookup, but I couldn't get it to work. I also need the list price and product code columns to be 'dynamic' so new values can be added further along.

## Macro For Name Generation From Product To Product With Sizes And Filenames

Jan 30, 2014

I would like to have a Macro to go from the first tab called "Start" and end up with the second tab "End" automatically. BAsically I need to take the product on each line under Tab Start and reproduce it for sizes 35-41 always ending with "-(size)". Then this new Product with Size needs to be multiplied one below the other for as many times as I have pictures (number shown under column B of the tab Start). Next to this value in column B of tab End I'd like the same name listed again but with the number 1, then 2, then 3, etc. as needed and the extension .jpg.

## Insert Product Images To Excel Workbook?

Sep 19, 2013

I have a stocklist that is currently in excel with product codes in column B. (eg 60080U-090)

I want to insert product images into column A. The product images are labelled as the style code (eg 60080U-090)

Now this is where you will chuckle, previously we have spent hours manually adding each image into the relevant cell and resizing.

Images are saved on a folder in the desktop labelled "Imagery" The excel workbook is saved in the same folder and labelled "Stock"

## Product Look Up: Look Up A Product Based On The Number And The Qty

Feb 20, 2009

i need to look up a product based on the number and the qty. see the example attached.

On tab "Printer - S" 1 need to lokup the costs based on the product code 8 and the qty 100. How do i do this and make it adjustable for any range of priduct codes and qtys. Again, becuase this will be used on a Mac Office, i cannot use macros.

## Type The Product Id In The A Column Of The Orders Sheet(Sheet2) To Auto Insert The Product Name In The B Column

Jul 16, 2006

In the first sheet I have two columns, one for the product_id and one for the name of the product. So the Sheet1 is like a small database. The second sheet is for the orders.What I want is when I type the product id in the A column of the orders sheet(Sheet2) to auto insert the product name in the B column so i dont have to write it every time.

## Cell Referencing: Enter A Product Name In One Cell And Have The Price For That Product Automatically Appear In Another Cell

Feb 3, 2009

I'm trying to create a supply order form. Is it possible to enter a product name in one cell and have the price for that product automatically appear in another cell? Is there a formula that I can use to make this happen?

## Excel Count By Unique Dates

Nov 28, 2012

I have an excel file with 1723 entries. One of the fields is DATE. I have it sorted by DATE. I need to count the number of entries per unique DATE.

## Merging In Excel Using Unique Identifier

Jun 7, 2014

I thought this would be very easy to achieve in Excel but is proving difficult. Basically I have a number of excel worksheets with the headers as below. What I would like to do is to use the staff number from each worksheet to populate and sum a master worksheet. Some staff numbers will be in each of the workbooks while some are only in one. While the employee name should also be the same in each of the workbooks there are some differences in spelling etc.

Mon - Fri Mon - Sat Saturday Sunday/Public Hols OVERTIME
Staff NoEmployee Name6 am - 11 am5pm - 12 Midnight12 Midnight - 8am8am - 12 Midnight8am Sun - 8am Mon

## Excel 2007 :: Counting Unique Values

Dec 9, 2013

I am using Excel 2007

I have 50 000+ rows that covers fiscal years from 2006 to 2014 and I want to calculate how many unique clients are there per asset type per fiscal year. In addition, the results table needs to adjust to filters i would use on the raw data..

As:

2007
2008
2008

Commodity
45
FX

Other
other

Here is a sample file: SampleData.xls

## Comparing Two Excel Sheets With Unique Keys

Aug 18, 2009

I need to compare the 2 sheets with respect to a unique key. Once the unique key matches , I need to compare 5 other columns of the two excel sheet.

Note : There could be missing rows in either of the excel , so its necessary that we look up 2nd sheet completely to find the unique key.

For Example : In sheet 1 : The unique key is preent in column B and in Sheet 2: The unique key is present in column I. Once we locate the rows in both the sheets with the unque key matching, we would need to comapre , columns A, C, E AND F of the sheet 1 with columns A,B,C AND D of sheet 2.

We need to report if all the data matches when the unique key is same.

## Excel 2007 :: Count Of Unique Values

Nov 18, 2011

I would like to get the count of unique values in my 2nd column using my values in 1st column as the criteria. Below is my example of my data set.

EFGH5DeptHC

6A304794A17B86122B38B86179C39B90050D1310C82705

11C94955

12C308165

[Code] .........

Excel 2007

I would like to see the count on column H (highlighted in yellow).

## Excel 2007 :: New File From Unique Listings

Feb 22, 2012

I'm having some trouble with a spreadsheet copy.

I have a spreadsheet listed out with 2-3 pieces of data per row like:

Mark - abc
John - def
John - ghi
Abby - xyz

etc.

What I need to do is create a new file for each unique string in column A. So for my brief example above, the "Mark" file would have 1 row, the "John" file would have 2 rows, etc. I also need to save the new file by the name in the first column (so "mark.xls"). (Conveniently, the table is sorted by the first column already.)

What I did was create a new worksheet for each row and then save that as my file. However I'm having problems getting my file to contain more than one row (I can get either the first or last row, but not all of them). I have about 30 spreadsheets to do this for, and each will create 80+ files... I'd really rather not do them by hand.

I'm on Excel 2007 if that matters.

I cobbled together some code I found in various places and this is what I have so far:

Code:

Sub CreateWorkbooks()
Dim newSheet As Worksheet, regionSheet As Worksheet, CurSheet As Worksheet
Dim cell As Object
Dim regionRange As String
Dim lngRows As Long
Dim CurRow As Long

[Code]...

(note that the comments are what it is supposed to be doing, not necessarily what it is doing)

## Count Unique Strings In Excel Column

Apr 3, 2012

I have a long list of products in an Excel column. I want to count the number of unique items in the list (the cells contain strings, not values).

I know I can use the "Remove Duplicates" tool in the Data menu, and then use a Count function on the resulting list. I wondered if there was an Excel function or formula that would do it, similar to the Frequency function that does the same thing with a list of values.

## Excel 2007 :: Extracting Unique Into Another Column

Feb 1, 2013

Column A has following names: A5 Peter A6 Sally A7 Andre A8 John A9 Wayne Column B has following names: A5 Andre A6 Wayne

I need Column C to show names that are in Column A but not in column B ...

Column C should show following: C5 Peter C6 Sally C7 John

I am struggling with this in excel 2007

## Excel 2007 :: VBA To Find Unique Rows

Jul 29, 2013

I am wanting to find rows that with unique values in the first column, and then take those rows and display them in a more readable format. The section titled input is an example of information that would be pulled from a query into Excel. The Desired Output section is how I would like the info to be displayed. If this is possible without VBA then that is even better.

Excel 2007
A
B
C
D

[Code].....

## Excel 2007 :: VBA Get Unique Values Set In Filter

Nov 29, 2013

[Excel 2007]. I'm trying to get the list of unique values from a Filter on a column in VBA.

I've given the column a Range Name

Code:
Dim rClient As Range
Set rClient = ws.Range("CLIENT_NAME")

Dim aClients() As Variant
aClients = rClient.???

There's nothing in the range method dropdown that obviously relates to the Filter on the range.

Is it something to do with the Table method?

## Combining 2 Excel Sheets With Unique Data Into One?

Mar 12, 2014

I have 2 separate excel sheets. Both contain different data about the same account. I need to combine the 2 into one spreadsheet without duplicating records. The accounts do have a unique account number that appears on both data sheets.

## Excel 2013 :: Unique Count In Group SubTotal

Apr 16, 2014

Using Excel 2013.

Is it possible to get a unique count in a group subtotal though the elements in the group may not be unique using Pivot Tables w/o resorting to Power Pivot?

Ex

Group 123
Group 456

Are both members of NorthDivision

If someone is in Group 123 for 9 months, then Group 456 for 3 months, that membership should be reflected in the correct group accordingly.However, that person should only be counted once in the NorthDivision, not twice.

Output:

Group 123 0.75
Group 456 0.25
NorthDivision 1

At first glance, it appears easy, however, what if membership is only total 3 months?Then Group would increment 0.25, but I need NorthDivision to increment 1

## List Unique Values In Excel And Count Occurrences Of Each?

May 25, 2014

I realise this is beyond me and wonder if it is possible to list uniqure values in excel and place a count occurrences of each. I have a hugh list of over 400 alpha code i.e ABCD, ABCD, ABCE, BDCE, BDCF ZXYE etc etc. What I'd like to do is pick out all the unique values so I can see what alpha codes are on the list. But then I would also like to count the occurrences of each value/name so I know how many times they appeared on the list.

Col A
ABCD
ABCD
ABCE
BDCE
BDCF
ZXYE
ZXYE
YEZY
CDEF

Col B is where i would like to list all the unquie vaules with a count e.g.
ABCD 2
ABCE 1
BDCE 1
BDCF 1
ZXYE 2
YEZY 1
CDEF 1

## Excel To Generate Unique Number On Click Of A Button

Jun 26, 2012

I'm trying to set up a system of sorts to track "services"

At the top of my 'new service" page, I need a button, which I then need to have a macro run on.

Sheet 1 is basically where I'd be entering the info, and sheet 2 where it would be stored. The button at the top is called Generate New "service' Number. This then needs to generate a new number on sheet 2 in A2 (then once 2 is populated, generate new in 3, then 4, then 5 etc...

I have a macro on Save Service Button at the bottom, which transposes the data into what would be used as a database to store all the services. That Macro then also needs to only transpose and paste data into the row corresponding with the "service number".

## Excel 2010 :: Count Unique Values In Pivot Table

Jun 20, 2014

I have data set up like the example but then for 1797 lines.

D39BKYes
D39BKYes
D39BKYes
D39BKYes
GHFLBNo
R80FANo
R80FANo

[code].....

What I need to get in a pivot table is: two columns or rows (Yes / No) and the unique count of the code.In this case is should show Yes: 2 and No: 3

## Excel 2010 :: How To Find All Unique Values Then Combine In A New Column

Jul 9, 2013

I have a wookbook with serial numbers in column A and barcodes in column B. There are 51940 rows in total.

Is there a way I can search through column A, and for each unique value found , concatenate all of the barcodes that relate to that serial number in column C?

Serial Numbers | Barcodes | Combined Values
-------------------------------------------------------
abc123 abc12300 abc12300,abc12301, etc etc
abc123 abc12301
def456 def45600 def45600, def45601, etc etc
ghi789 def45600

i am using Excel 2010.

## Excel 2003 :: Get Give Each Row Inputted Unique Number For Later Editing?

Mar 14, 2014

I have created a workbook to input, store and part edit defects on plants and machinery by userforms. I have everything working except either picking up a number I have pre-loaded into a column or auto generating a number onto the inputting userform. I need a number in the userform to be either generated in the next empty row in column I or taken from the numbers in the next empty row I have loaded into column I. Password is snatch.

Input 2003 test1.xls

## Excel 2007 :: Extracting All Unique Items From Pivot Table

Feb 20, 2012

I am looking for a way to extract all of the unique items in a Pivot Table. For example, I have a Pivot Table that has category A items and category B items. There may be several B items to one A. For example:

A0
B1
B2
B3A1
B3
B4
B5

Now, what I need is a list that looks like this:

A0 - B1
A0 - B2
A0 - B3
A1 - B3
A1 - B4
A1 - B5

Formatted so that those are two columns. However, in Excel 2007, I cannot set the option to have it repeat the A series items in the Pivot table. Is there some easier way to do this?

## Excel 2007 :: How To Make Unique List From Repeated Items

May 22, 2012

Using excel 2007. I have a column with multiple items, a lot repeated.....how do I make a to show just one of each item? I want a unique list of my column of repeated items.

## Excel 2010 :: Code To Extract Unique List Of Dependents?

May 31, 2012

6AliAsbert7RosalineSam8TimothyAsbert9TimothySam10ReginaldAsbert11PascualJackson12MichaelSam13ReginaldJackson
14MeganJackson15ShellySam16CandiceSam171819Sheet1

Here's my problem... Column A contains employee name & column B contains Team Leader name of the respective employee. Range D1:G1 should contain names of team leaders from column B. After that, depending on the name populated in D1, cells going downwards from cell D2 should contain name of employees of that team leader. Similar thing should be repeated for columns E, F, & G. If an employee shows up under two team leaders then it should be displayed under both lists.

Is there any formula/VBA code which can do this? Been after this for last 3-4 hours and now just lost in a maze of various Index Match combinations and array formulas..

## Excel 2010 :: Count Unique Values On Pivot Table

Jun 21, 2013

How do count unique values in category in pivot table. (my table, im taking data from ms query). I am using excel 2010

Pivot table example: the result i want is the "no of types" as my data only show "category" and "types".

Category
Types
No of Types

Fruits
Apple
Pear
Orange
3

Vegetable
Cabbage
1