Merging Duplicates In A Glossary?

Aug 30, 2009

I am processing files with terms in excel and I need an easy way to manipulate them.

FIRST CASE In the first case, there are simply two columns.

In the file test-dic-edit.xls you see in Sheet 1 what the file is like at the first stage. After that is should become like Sheet 2 (left column duplicates broken in new lines) and then right column duplicates merge like Sheet 3.

A new sheet is created with the merging results.

So, if the macro does not find any duplicates in left column, it moves to stage 2, merging duplicates in right column.

SECOND CASE In the second case, there are 3 columns (term in language 1, term in language 2 and category). Sheet 1 as it is originally and Sheet 2 as it should become.

A new sheet is created with the merging results.

Some notes: No tab characters exist in the text. The delimiter used for multiple translations (within a cell) is [space];;[space] The actual terms might contain punctuation like fullstop and comma and their length might be up to 200 characters or more (i.e. one phrase in language 1 translated in language 2). The files might be 50,000+ rows big.

View 14 Replies


ADVERTISEMENT

Merging Duplicates In A Glossary

Aug 30, 2009

I am processing files with terms in excel and I need an easy way to manipulate them.

FIRST CASE
In the first case, there are simply two columns.

In the file test-dic-edit.xls you see in Sheet 1 what the file is like at the first stage. After that is should become like Sheet 2 (left column duplicates broken in new lines) and then right column duplicates merge like Sheet 3.

A new sheet is created with the merging results.

So, if the macro does not find any duplicates in left column, it moves to stage 2, merging duplicates in right column.

SECOND CASE
In the second case, there are 3 columns (term in language 1, term in language 2 and category). Sheet 1 as it is originally and Sheet 2 as it should become.

View 14 Replies View Related

Central Glossary: Feed Multiple Documents

Aug 26, 2006

a while back I posted Central Glossary to feed multiple documents to put a glossary at the end of a Word doc. Fabulous help and got it all sorted. Now I'm trying to do it at the end of an Excel w/b.

View 4 Replies View Related

Pivot Table To Not Count Duplicates - But Show Duplicates When Click Into It

Aug 24, 2011

In short, I would like a pivot table to only count unique values, but when I click into the pivot I would like to show all instances of that value. For example:

I have a table of data that I am creating a pivot table from. There are fields for Customer ID, Task Name, Age, and Notes. There will be multiple records for a single Customer ID each time it has new notes.

I would like to create a pivot table that has Task Name in the Row Labels, Age in the Column Labels, and count of Customer ID in the Values, so that, for example, I can see how many accounts have been in the Design task for 2 days. However, when I do this it counts each record, but I would like it to count each unique Customer ID. Also, when I click into the pivot, instead of pulling up one line per Customer ID, I would like it to pull up each instance of Customer IDs in that Task Name/Age combination (similar to doing a DISTINCT in SQL).

View 3 Replies View Related

Count Duplicates And Duplicates With Suffix As One Instance

Mar 23, 2014

I have a list of isometric drawing numbers ending with a [underscore]weld number e.g. 1692-SG-0040-04_05.

Some welds are repaired--in that scenario the amended weld number will be 1692-SG-0040-04_05R1, and even 1692-SG-0040-04_05R2 if repaired for a second time.

On occasion a weld may be cut out entirely and a new weld done. The weld number for that will be 6317-FG-1690-02_06C1.

And here's a wrinkle I've just verified...a cut weld may also be repaired so the weld number will look like 1698-SG-0077-01_04C1R1.

Is there a formula to count these as one weld:
1692-SG-0040-04_05
1692-SG-0040-04_05R1
1692-SG-0040-04_05R2

This as one weld:
6317-FG-1690-02_06
6317-FG-1690-02_06C1
6317-FG-1690-02_06C2

...and this as one weld:
1698-SG-0077-01_04
1698-SG-0077-01_04C1
1698-SG-0077-01_04C1R1

View 7 Replies View Related

Excel 2010 :: How To Count Duplicates Of Duplicates

Jan 24, 2012

I am having trouble creating a function to count duplicates of duplicates.

An example of the data table 1 is:

Product 1 2nd
Product 1 2nd
Product 1 New
Product 1 New
Product 1 Flt
Product 2 2nd
Product 2 New
Product 2 New
Product 2 Flt
Product 2 Flt
Product 3 2nd
Product 3 2nd
Product 3 2nd
Product 3 New
Product 3 Flt

I created a new table (table 2) and made a list of all the Products on table 1 and removed the duplicates. I now have 3 columns with titles New, 2nd and Flt as follows:

New 2nd Flt
Product 1 XX XX XX
Product 2 XX XX XX
Product 3 XX XX XX

I am trying to count the duplicates for each product (XX), but I can't seem to work it out. I've tried the MS help function, but unsure of the actual formula I need to be using.

I am using Windows 7 and MS Office 2010.

View 2 Replies View Related

Identify Duplicates On Sheet 2 And Populate Number Of Duplicates On Sheet 1?

Apr 8, 2014

I'm trying to Count duplicate text on sheet 2 and populate the number of times repeated on sheet 1.

On sheet 1 I have A3:A128 and would like the number of times these respective cost centers are repeated in Sheet 2 to populate Column B of Sheet 1.

File attached.

Not sure which formula to use. I tried CountIF but didn't work with 2 sheets.

View 7 Replies View Related

Merging Two IF Formulas

Mar 7, 2014

I am merging the following two IF formulas together.

=IF(ISBLANK(M4),"NOT RECEIVED",0)

and the second formula I want to merge is

=IF(A2+5>=M2,0,"LATE")

View 4 Replies View Related

Merging First And Last Names

Jul 8, 2008

I have an excel sheet with first and last name and I have another column called username.

The username will be "firstnamelastname" all lower case and no spaces.

I know I can use C1=lower(&A1""&B1)

View 13 Replies View Related

Merging The Data

Aug 2, 2009

I'm compiling data to be transfered into a report program but the programe can't deal with any Excel Formulas so the data has to appear 'as is' so to speak. I have 2 columns of data (roughly 1200 rows) and I need to merge the two together but i can't have the formula in the merged cell......

View 4 Replies View Related

Merging 2 Sheets

Sep 10, 2009

I have 2 sheets

1st sheet data

Job_idHost_NameOutcome STEP_INDEX
742762Blank success Null
742762QCTCRMBLD07success 0
742762QCTCRMBLD02success 1
742762Blank skipped 2

2ND sheet data

Job id RunTime QueueTime

742762 52 .4562 0.12365

Now i have to insert the 2nd sheet data into the first sheet whereever the step index is NULL

So Basically my output should be like below:

Job_idHost_NameOutcome STEP_INDEX RunTime QueueTime
742762BLANK success Null 52 .4562 0.12365 742762QCTCRMBLD07success 0
742762QCTCRMBLD02success 1
742762BLANK skipped 2

View 7 Replies View Related

Merging Rows

Dec 3, 2009

I am looking for some tips to merge the 2 rows into 1 row with all data transferred. I have tried the following:-

=IF(MOD(ROW()/2,1)=0,INDEX($B$1:$B$100,ROW()/2),INDEX($A$1:$A$100,INT(ROW()/2)+1))
However, it returns "0" when cell is empty. Your help is greatly appreciated. Attached a file for better understanding.

View 10 Replies View Related

Merging Worksheets Into One

Jul 26, 2013

I have 29 inventory sheets that are identical. I need to merge them in to one master work sheet.

View 2 Replies View Related

Merging 3 Worksheets

Jul 17, 2014

I have 3 Worksheets in Excel I would like to merge into a new worksheet. Worksheet A, B, C. I have 133 rows of information on each sheet.

I would like to merge them in a particular order. I would like to take Row1 of Worksheet A, then merge Row1 of Worksheet B, and then merge Row 1 of Worksheet C.

So on the new Worksheet I have 3 rows of combined 3 worksheets. The would like to repeat this for all rows 2, 3, 4 etc. till will get to row 133 or end.

View 1 Replies View Related

Merging Cells ....

Jan 19, 2009

I have a column with data, the cells go data, blank cell, data, blank cell, data etc.

The row count will vary.

What I need to do is go through the non blank cells in the column and merge the them with the blank cells beneth them.

ie A2 = Apple
A3 = blank
A4 = Pear
A5 = blank

run the code to get

A2 and A3 = Apple
A4 and A5 = Pear

View 9 Replies View Related

Merging Row Data

Feb 10, 2009

I collect data from a number of tools for our server and switch info. I don't have a problem merging that data. My problem is trying to get that data into a working format.

-- I have a server that has dual network connections.

-- This data resides in different rows, and each has slightly different data that I need to preserve.

-- I want to merge these two rows into one pre-defined output layout on a separate sheet without loosing any of the data.

Some other things of note. Not all of the servers have duplicate entries, but still want that data on the output sheet as well.

I have attached an example of what I have to work with and what the output sheet that I'm trying to get to looks like.

View 8 Replies View Related

Merging Two Worksheets..

Oct 15, 2009

I have two worksheets in the same workbook that need to be merged into a third worksheet. I need to take all the data in worksheet "On Hand" and bring in from the worksheet "Transactions" the data in columns E & F (into the new worksheet "Excess Inventory"). There will be item numbers (Column B in both sheets) that will only be in the "On Hand" sheet. I have entered data in the sheet "Excess Inventory" to show what I am trying to do.

View 3 Replies View Related

Merging By ID Numbers

Jul 4, 2007

I have an excel file with the same columns of data for different years (each year's data is in a different sheet). Each of the columns corresponds to a different survey question asked to the same farmers year after year. These farmers have been identified by ID number in the first column and I would like to consolidate the information from all the years into a single sheet.

The problem is that there are many farmers who dropped out of the survey or were added to the survey over the years. So, for example, in year one you may have data for the following ID numbers: 1, 2, 3, 5, 7, 8, 9 And by year 4 you may have data for the following ID number: 2, 3, 4, 5, 9.

View 12 Replies View Related

Merging Two Files

Dec 16, 2008

merging two Excel files. 2009 Item List.xls file has two columns Part number and Description. Price.xls file has two colums: part number and price. I need to merge them into a file that whould have three colums: part number, description, price. There 6712 rows in 2009 Item List.xls and 4743 rows in Price.xls file. So I need them matched based on the part number, and have the cells blank for the part numbers for which the price was not assigned.

View 9 Replies View Related

Merging Two VBA Subs?

Mar 21, 2012

I'd like to combine two VBA subs existing on a single sheet. Since they can't duplicate I need some sort of a switch statement...?

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Dim VRange As Range, cell As Range
Dim Msg As String
Dim ValidateCode As Variant
Set VRange = Range("E4:E100")
For Each cell In Target

[Code]....

View 5 Replies View Related

Merging Two Columns

Dec 20, 2006

i would like to merge two columns as explained below

for ex

the 1st column is:
1
2
3
4
5

the 2ed column is:
1
2
3
4
5

the merged columns should be:
1
1
2
2
3
3
4
4
5
5

View 9 Replies View Related

Merging Cells ...?

May 25, 2007

I have data in two separate cells as follows:

Cell A1 = 7890
Cell A3 = 1

In Cell A4 I want to merge the figures as following figure:
789.01

What type of formula would I need to create for this to work for me?

View 9 Replies View Related

Merging Outocme After Looking Up

Oct 1, 2007

I have given an example of below of what i am trying to achieve. I am seeking to match up the region name with the project id and to have the outocme put into expected output. i have done two examples below. The problem that i am facing is that "Asia" as you will see has more than one project info. (the list is quite long)

ProjectInfoProjectIdRegionRegionNameExpected Output:
CW28915NL - Netherlands
CW28915HK - Hong KongNL - Netherlands ; HK - Hong Kong
CW30695Asia
CW30695America
CW30695Middle East / Africa
CW30695EuropeAsia ; America ; Middle East / Africa ; Europe
CW32739Middle East / Africa
CW32739Europe
CW32739Asia
CW32739America

View 9 Replies View Related

Merging The Sheets

Jul 17, 2008

I need help in merging sheets in 4 workbooks, meaning bringing the sheets in all 4 workbooks into 1 workbook.

View 9 Replies View Related

Merging Macros

Nov 13, 2009

I've created a time sheet that we fill out daily. I currently have two macro buttons on the sheet. One "submits" the sheet by creating a .pdf, saving a copy and then emailing it to the boss. The other closes the time sheet without saving so that it doesn't carry over today's data to tomorrow. My question is, can I assign one macro to do both?

View 9 Replies View Related

Datasheets Merging

Aug 18, 2005

I need to merge two spreadsheets....

1 spread sheet has 1500 filenames store in Column A and the another spreadsheet has all filenames(Near 3500) in column A and their properties in the next three columns.

Can anyone teach me how to automatically match the same filename and merge together the data and put to sheet 3?

so in sheet 3 I can have the following
Column A = Filename | Column B = Property 1 | Column C = Property 2 | Column D= Property 3

View 4 Replies View Related

Merging To Different Tables Into One

May 17, 2006

I have 2 tables in excel that i need to merge into one, Table 1 has 10 colmns and Table 2 has 7. Both tables have as column 1 a heading of Material, this is the column i need to compare as table 1 does not contain a material description field, but table 2 does, the bold headings are the key ones, but other column information is required. I have attached a sample ss to show what i am trying to do.

Table 1 Col Headings
Material
MTyp
MS
R
Clt
L/O
Created on
Created by

View 2 Replies View Related

Merging Two Graphs

Jun 15, 2006

I have two seperate graphs in two different workbooks. Both graph's are identical in the setup, they have the same X axis and Y axis value. They are identical in every way except for the varying in percentages. This graph was originally setup in that it would calculate the results for a period of a week at a time. Is there a way to merge the two graphs thereby showing the results for a two week period?

View 4 Replies View Related

Merging Two Worksheets

Jul 20, 2006

There is no unique common key to relate records in two work sheets of same workbook. Therefore, the first step in generating this report is to create a common key that can be used to match records in worksheet 1 to worksheet 2 records. Common key is generated by concatenating few of the columns common in both the data sets (say something like brand + Site + End Date + Last name + First name)
The matching run should match the pseudo keys in the two datasets, and merge the records into one file using the following criteria
Event.key1 = ECB.key2 and Event.act_psrv_amt = ECB.folio_amt

Used Vlook up function but it takes really long time to return matching record (note that I want to return whole of the matching record) as we are dealing with huge data.
attached is the sample data

View 9 Replies View Related

Merging Two IF Functions Into One Function

May 23, 2013

I have this current IF function in this worksheet I am working in:

F7 =IF(E7=0, " ", E7*0.17)

Then what I need to do is if I type the letter "N" into G7, then the value which is labeled as "E7*0.17" in the first function needs to appear as a blank, in otherwords as: " "

Is there any way to do this? I have tried nesting an OR function within the IF function, but the result always appears as #NAME? with an error sign.

Here is the function I have tried:

=IF(OR(G7=N,E7=0), " ", E7*0.17)

Then I also have a function for H7 where H7=E7+F7 which needs to stay true at all times as well. When I put in the nested function above, the value in H7 changed to #NAME? as well.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved