Combine Similar Products And Put Into Correct Columns

Jun 21, 2007

Try this on for size...

On the MSP sheet is a list of products with a weeknumber and quantity.

I need to combine products that match in the same week and add their quantities.

Then I need to put the quantities into the VOLUME worksheet.

Any products that arent listed need to be added on the bottom.

View 14 Replies


Filter Data Between Two Dates With Customer ID And Sum Similar Products

Apr 1, 2013

I have problems with my project. I want to filter data between two dates with customer ID and when click Export Report button , result will copy on next sheet ( sheet's name is report in my file attachment ) and auto sum similar products.


View 1 Replies View Related

Match Products With Correct Image File?

Aug 4, 2014

So I have a spreadsheet of several thousand products (spare parts) and we received a folder of image files to go with these parts, however the file names aren't all uniform; some of the image files have the Part Number, while others use the SKU number. I have cells with the part # and SKU number for each product, and I could probably copy and paste the list of all image file names from the folder into the same spreadsheet. Is there a macro that could search the image file list for either the SKU or Part Number, and whichever is listed for each row, insert that file name into a cell? So I have this:

Item name SKU # Part #
Spare Part 1 123456 P0459381B
Spare Part 2 340934 P2394093A

And then I have the list of image files in its own Sheet or whatever's easiest

So after the macro is complete, I'd have:

Item name SKU # Part # Image file
Spare Part 1 123456 P0459381B P0459381B.jpg
Spare Part 2 340934 P2394093A 340934.jpg

View 3 Replies View Related

How To Combine Cells With Similar Value

Jan 11, 2012

How to combine cells with a similar value inside them into a single cell. Here is what my data looks like.



For example, I need to have every cell with SNM9012 to combine into the same cell. If I could figure this out it would save me hours vs pasting the similar lines into textmate and removing the enters.

View 1 Replies View Related

Combine Rows With Similar Info In Dropdown Menu Or Selection For User

Nov 29, 2012

I have a spreadsheet that has a long list of charges... some of those charges have multiple codes attached to them... when this happens I am wanting to group them together and let the user pick which one they want to view at one time.

Here is a very small example of what exactly I am referring to... with charge #14 I am wanting it to combine and let the user pick between 2565 and 2566. The problem is that the values can range and will not always be 2565 & 2566 and there is 10,000 + records similar to this.


View 1 Replies View Related

Two Columns Have Data Is Not Similar Then Return The Value

Jun 13, 2007

I need a formula that looks at 2 columns and if the data is not similar to return the value.
For example
Column A
joe Bloggs

Column B
Bloggs, joe

Column C
if value in column B is not similar to column A to return value of column B

View 9 Replies View Related

Formula To Find Similar Data In Columns

Feb 17, 2007

I need help creating a formula to find data in one column that starts with different letters and counts them up.

For example one column would contain the words amoung others:

In the other column I want to count up the amount of times a word starts with the letter D or E or Y. The count comes from another spreadsheet, which the CMRF Tool (See attachment) is pasted at the bottom of.

The Monthly case report file is the file I want to get the count from. These would come from Column O once the data is there. The count would end up in column D of the CMRF tool which is pasted at the bottom of the monthly case report file.

View 9 Replies View Related

Find Similar Words Between 2 Columns & Move To Same Row

Mar 19, 2008

I have two different lists that have some similar text and some irrelevant text. What I need to do is move the matching words from column B to the same row in column a and leave blank the rows that have no similar words. Column A will not move ...

View 7 Replies View Related

Excel 2003 :: Multiple Columns With Similar Calculation?

Jun 27, 2014

I have Excel 2003 and use the following code for 50 consecutive columns, using each column's Row 1 as the multiplier. Each column has over 20,000 rows. It works, but I'd like to know if there's a quicker and / or neater way to do it.

Range("bo2", Range("bo" & Rows.Count).End(xlUp)).Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlMultiply
Range("bp2", Range("bp" & Rows.Count).End(xlUp)).Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlMultiply

View 5 Replies View Related

How To Combine Multiple Columns Into Long List Of Results In 2 Final Columns

Oct 15, 2013

I have a need to combine multiple columns into a long list of results in 2 final columns. Here is my example...

Current layout with varying number of data points per row...

ColumnA | ColumnB | ColumnC | ColumnD | etc...
example1 | Test1 | Test2 | Test3 | Test4
example2 | Option1 | Option2
example3 | Number1 | Number2 | Number3 | Number4 | Number5

Desired Result

ColumnA | ColumnB
example1 | Test1
example1 | Test2
example1 | Test3
example1 | Test4
example2 | Option1
example2 | Option2
example3 | Number1
example3 | Number2

and so on and on and on until all rows have been filled in down the file...

Is this possible?

View 4 Replies View Related

Excel 2010 :: Comparison For Similar Email Addresses Separate Columns

Jun 21, 2014

Have an Excel 2010 spreadsheet with 902 email addresses in one column, and 927 email addresses in other column, sorted in alphabetical order.

Overview: Organization database has 902 Members (some have 2 email addresses subscribed to listserv) and Organizational Listserv which has all 927 (Difference is numbers are some members have 2 email addresses subscribed) BUT 902 of emails should be the same

Objective to compare Listserv Members 927 with Database Members 902. I am trying to isolate the email addresses which do NOT exist in Listserv Column, or who do not exist in Database Column for Audit purposes. All Members from the Database column should be subscribed or entered into the Listserv column.

If it's a perfect world the 902 email addresses will all be exactly the same as 902 out of the 927 Listserv email addresses.
Trying to highlight or sort and put identical email addresses on same line or using Conditionally formatting? Highlight Cell Rules/Duplicate cell rules Even when same email addresses are on the same row conditional formatting does not recognize them.

View 4 Replies View Related

Finding Duplicate And Or Similar Info Across Columns And Highlight (names And Addresses)

Jan 29, 2014

Magazine subscription list. How to highlight the customers that are already in the sheet if enter them again (renewal). Our list is like so....

ColA ColB ColC ColD ColE ColF
First Last 123 Ave City State Zip

Is there a way to highlight the row if the info on ColA, ColB, ColE, and ColF all match? Sometimes the Street info is abbreviated or entered PO Box instread of P.O. Box and they wind up on the list a second time.

View 5 Replies View Related

How To Change Auto Correct Words In Certain Columns

Jul 21, 2013

For example, on column X, if I type 20, bob or bobafett it type 2.0 instead but on column I if I type bob, it will type 3.0

they would all be edited manually

or even better, no matter where I type it on excel, it would go in the right column, like bob X, then it would change to 2.0 and go directly in the X column

View 4 Replies View Related

Keep Comments Column Correct After Refreshing Data Columns?

Dec 16, 2012

I have an worksheet that refreshes every day from a .csv report. I would like to be able to have a comments column at the end that users type in. The problem is how to keep the comment next to the row it was on before the refresh.

When it refreshes there will be new rows, rows that are no longer there and all in a different order.

There is an Order Number column that can be used as an ID column.

View 3 Replies View Related

Get A Correct Average Of Each Supervisor From The Data Breakdown In Columns

Dec 26, 2006

How do I get a correct average of each supervisor from the data breakdown in columns f:g?

I was thinking an if statement like =if(a2:a10,"x" --then I am not sure how to say average of f:2:f10). Would that be on the right track?


View 9 Replies View Related

Countif Formula: Added The Correct Amount In The Correct Cells

Feb 15, 2010

I'm trying to create a formula that will added the correct amount in the correct cells, I have create a dunny sheet in trying to achieve this. If Cell B8:B11 = ABS or Dum that any points won should be added to Cell L8:L11 right now its adding it into K8:K11. If Cell B8:B11 = is Blank any player points should be added to cells K8:K11. I'm using this formula throughout cells K8:K28 =IF(J8>J25,1,IF(AND(J8<>0,J8=J25),0.5,0)) Any thing in red is incorrect anything in blue is what I'm trying to achieve.

View 4 Replies View Related

Check Cells Are Correct Format And Contain Correct Data

Jan 26, 2014

We receive about 20 sales files of several hundred lines of data each day from various agencies. I want to create a macro / VBA code which checks that the data submitted is correct so that we can upload it into our database without import errors and / or having to manually check each line of data.

I envisage something like an output report:

149 entries
Column A - Date - OK
Column B - Customer_Phone - Errors (Should be 11 digits)
Row 21 - Customer_Phone - Error (Not 11 digits)
Row 108 - Customer_Phone - Error (Contains letters)
Column C - Outcome - OK
Please correct and re-check.

View 4 Replies View Related

Sumproduct- Counts The Correct Amount But Not With The Correct Dates

Jul 3, 2008

I have a table with 3 columns of dates and then a column with Set # that I
feel in the box #.

I need to see how many items processed for each set per day.


The problem is that it counts the correct amount but not with the correct
The formula that I use is:

View 14 Replies View Related

Combine Many Columns To One

Nov 17, 2009

Essentially need a macro to combine the columns into 1 column.

Need a Macro to put everything in each "box" into one column, for example CU is the end of the first box, CV to GP is the second box ect. Essentially a box is the row where the yellow line is to the column where the yellow column is.

The problem is the setup of these colums change, sometimes they are bigger sometimes smaller and the spaces beneth it change. Sometimes I might have a column which goes to row 18 followed by 3 blank rows then the yellow box

I first design the first colum then select that and drag across to complete the rest ( my real file has links ect )

So I need a macro in which it can scan the first column up to the yellow line then put everthing within a "box " into 1 column, each )

then repeat the same process for other boxes with each box being put in its own column ( preferablly leaving an empty column in between )

THe file itself will help clarify any problem, if this request is not possible if it could combine every column into 1 column ( along with the spaces to the yellow line ) that would help also, i could manually cut each box into another column then.

View 10 Replies View Related

Combine The Columns

Dec 3, 2006

I need to find a way i can easily combine a1, b1, c1, d1, and so on, about a 100 of the, i need to combine, each one has different text that needs to become together. I know one forumula =a1&" " &b1&" " &c1, but doing that for about 100 colums, would take for ever, is there a easier way?

View 12 Replies View Related

Comparing 2 Columns Have Similar Data - Extract Matching Data

Apr 18, 2013

So I have this problem in excel with comparing 2 columns.

Basically, I have 2 columns(a &B) that I need to compare with one another and find out the matching data. I am trying to use that matching data to enter in our reports.

Both columns might have duplicate items because I am dealing with premium numbers.

Formula to compare these 2 columns and find the matching data and extract it to a separate column. Keep in mind, i am dealing with almost 20,000 lines of data.

View 2 Replies View Related

Combine Two Lists (All Columns)

Mar 29, 2013

excel help.xlsx

I would like to combine these two lists (all of the columns).

View 4 Replies View Related

Combine Multiple Columns Into One Row

Aug 26, 2013

I have a spreadsheet that has identical data in column A throughout the worksheet and want to take data in columns F and G and combine them all onto one row. An example of the data is attached.

test example.xlsx

View 1 Replies View Related

Combine Two Columns From Different Worksheets

Nov 22, 2008

I have two worksheets with a column of part numbers. I am trying to combine them in a new worksheet and remove duplicates.

View 7 Replies View Related

Combine Two Columns Which Both Contain A Lot Of Characters

Dec 19, 2009

I have content in two columns side by side. A total of 1650 rows. I am trying to merge the content of both rows using =A1 & " " & B1 however, it is truncating the content I guess because the cells contain too many characters. How do I merge the contents of the two columns successfully?

View 3 Replies View Related

Combine Data From Two Columns

Feb 16, 2007

I am trying to do something that would look at column B and for each value that is the same in any row in column B, it would look to column A and add that value into a text string of all those values in column C separated by commas.

example, If A1=37294 A2=37295 A3 = 37296 A4=37297 A5 = 37298 and B1 = abc B2=ABC B3=ABC B4=XYZ and B5=XYZ I want C1 to result in 37294,37295,37296. And I want C2 to result in 37294,37295,37296 and C3 to result in 37294,37295,37296 and C4 to result in 37297,37298 and C5 to result in 37297,37298.

View 4 Replies View Related

Combine Columns, Intercalate

Jul 12, 2007

I have data in two columns (A and B), which I need to combine into one column (C) in intercalating order: C1 = A1, C2 = B1, C3 = A2, C4 = B2 and so on.....
Is there a simple way to do it ?

View 4 Replies View Related

Combine 2 Columns With 3 Choices Into 1 Column?

Feb 18, 2014

I have 2 columns "H" and "I" from line 6 to 409. Each cell may start with AR , MA or a number. If cell H6 starts with AR I would like to put that cell into B6. If H6 does not have AR then I would like to check I6 for AR, and put that into B6 if it's found. If I don't find AR in either I would check them both for MA, and write the cell that finds MA into B6. If the AR or MA are not found then I would want it left blank. I did try

IF(FIND("AR",$H7,1),$H7,IF(FIND("AR",$I7,1),$I7,IF(FIND("MA",$H7,1),$H7,IF(FIND("MA",$I7,1),$I7," ")))) in B7.

View 6 Replies View Related

Combine Data From Multiple Columns

Jan 8, 2014

My workbook contains information about investigations. Each investigation gets a number and a line in the workbook. Many infos are stored: dates, subject, ...

A dynamic table contains all those informations, which allows me to manipulate data pretty easily.

Issue: For one of the characteristics of the investigation (let's say names), several results might have to be entered. For example, one investigation can have 3 different names, the next one only 2 and another one can have 6.

This causes a problem regarding the manipulation of the data.

Right now I have 10 columns "name 1" "name 2" .... and only those who need to be filled are filled. I can't however efficiently manipulate the data. For example, George could have been entered in "name 1" for the investigation 1 and in "name 2" for another investigation. Using a pivottable, to track George I'd have to select him in all 10 columns.

It seems to me the best choice would be to somehow index the names into a single column with each name linked to its investigation number..

With the index function I have 2 issues:

- It starts by going down the 1st column, then goes to 2nd, ... where I'd want all names of 1 row then names of 2nd row.

Solved this with this formula:

I turned my "names" columns in a ranged name "Names"

but - When fields are empty I get 0s. When I try to remove them with an if statement, it'll just give me empty cells. I'd prefer to skip the empty cells.

Also, I don't know how to 'link' them to my investigation number...

I have this (dynamic) table:

investigation number name 1 name 2 name 3
001 George Paul
002 Chris George Suzy

And I want something like this:

Investigation number Names
001 George
001 Paul
002 Chris
002 George
002 Suzy

View 14 Replies View Related

Combine Two Dynamic Columns Into One Column

Nov 13, 2008

i need to take all cells in column A with values and all cells in column B with values and combine them into column C so i can sort and subtotal. Columns A and B may have 2 values or 2000 values.

View 10 Replies View Related

Copyrights 2005-15, All rights reserved