Merging Cells With Similar Data

Mar 2, 2005

I am trying to merge two cells that have the exact same content in each cell. Everytime I do this, I get a pop-up warning that Im trying to merge cells with content in them and that only the upper-left content will remain. This is exactly what I want, without that pop-up, as I have to do this for multiple columns at a time.

View 2 Replies


Merging Similar Data And Amounts

Feb 22, 2013

Column A: List of document numbers
Column B: List of amounts

111 $5.00
222 $10.00
111 $5.00
222 $15.00

I need to merge all equal document numbers so that it shows the full amount on that document number. It needs look like this in the end:

111 $10.00
222 $25.00

I realize a pivot table will do this but the formatting of a pivot table will not work with what I am ultimately trying to do.

View 7 Replies View Related

Automatic Background Color In Cells With Similar Data?

Nov 29, 2012

I, daily get a list of individuals with some data against each one of them. E.g Amit would appear 7 times in the list, John would appear 10 times in the list and so on and so forth. I am required to sort the data as per names and then fill one background color. One color for one person so that it becomes easy to read data specific to an individual.Ia there a way that the color fills up automatically. note the names and number of entries are not same everyday.

View 8 Replies View Related

Merging Data Of Two Cells Together..

Jan 14, 2009

I need assistance with a formula two merge data of two cells together. For instance I have a column 'first name' and 'last name' and I want to create a column of just 'name' and concatinate the data eg: John Smith. I have roughly 175 cells to do this for.

View 5 Replies View Related

Merging Several Cells Of Data Into One

Jun 19, 2014

How would I combine the data in 30 cells into one cell.

They all 12 digit numbers and I need them separated by a comma.

View 2 Replies View Related

Data Consolidate - How To Maintain Case Sensitive Data After Merging Cells

Dec 8, 2013

I'm looking for a way of keeping case sensitive data in a range of cells, before using Data Consolidate, which when merged afterwards, Consolidate removes the case sensitivity and combines the quantities into one.

Check out this simple table as an example >




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

Cells A1-B7 and C1-D7 are two sets of original data, before consolidation.

Cells E1-F4 are the result of applying a Data Consolidate operation to the A1-B7 and C1-D7 ranges - note how the merged result ignores the case sensitive condition in the original ranges.

Cells G1-H7 is the post-consolidation result that I'm looking for, where the original text case is maintained.

View 3 Replies View Related

Merging Multiple Data Cells Into One Cell?

Oct 24, 2013

I have a spreadsheet where I am trying to add up codes and quantitys, after this I want the repeated info deleted. For example;

12.004RWHB 4 Row Wooden Handle Welders Brush
12.004RWHB 4 Row Wooden Handle Welders Brush
20.004RWHB 4 Row Wooden Handle Welders Brush
24.004RWHB 4 Row Wooden Handle Welders Brush
4.004RWHBSS4 Row Wooden Handle Welders Brush S/S
10.004RWHBSS4 Row Wooden Handle Welders Brush S/S
12.004RWHBSS4 Row Wooden Handle Welders Brush S/S

So what I want to do is add the numbers up so I can get one value. For example, 4RWHB I want to add them all up so that it totals 68 still shows the code and description but then only shows 68 4RWHB 4 Row Wooden Handle Welders Brush and not the same line repeated. I want to condense all the information down so where there is same model numbers I can add it up and it doesn't give me multiples but summarises it down into one line per model number.

View 1 Replies View Related

Finding Duplicate Data And Merging Cells

Nov 5, 2007

What I have is a massive table of data (15k+ entries), which consists of 4 different tables merged together. I have a lot of duplicate entries. However, most of these entries have information in one or another columns that its duplicate does not.

What I need to do is:

Identify the duplicate entries (by part number, which is one of the columns).

Merge the duplicate entries. In the merging process, I need to carry information over, taking data that is currently in 2 or more rows and merging it into one row.

Here's an example:

column1 column2 column3 column4
row1 a . . d
row2 . b
row3 . . c

needs to turn into:

column1 column2 column3 column4
row1 a b c d

If I'm not explaining this well, I will do my best to clarify. My main question is, is there any way to automate this process (even partially)

View 14 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

Getting Cells With Similar Criteria

Jul 19, 2007

Is it possible to get multiple cells with the criteria? it always happen to only show the first cell in a column that have that criteria. For example, I have a column1 named "projects" and a columnb named "employees". How do I get all the names that have the same projects?

View 2 Replies View Related

How To Vlookup Summing Similar Cells

Dec 18, 2013

I have attached the file, in the last sheet (Consolidated) i need to get the data from all the previous sheets, my problem is that whenever i have similar cells the data that is showing is only the first value and not the sum of all values,

View 1 Replies View Related

2003 - Merging Four Adjacent Cells With Text And/or Blank Cells

Jun 14, 2008

I am trying to merge text, in four adjacent cells in the same row (say cells A1,A2,A3 and A4), into a single cell (say cell A5).

I would like a comma or full stop and then a space between each item merged (cell A5).

The text to be merged may appear in any one of the four cells (cells A1 to A4). Those cells without text are blank.

Only where all 4 cells are blank, will I need cell 'A5' to indicate this.

The formula needs to be relative as I will need to copy the formula down the spreadsheet so that it applies to additional rows.

View 9 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

Rows Similar Data Divided By Blank Row To Delete Data If There Are 6 Or Less

Apr 2, 2014

I have a lot of rows of data all divided with an empty row and if they are 6 or less all rows need to be entirely deleted any 7 or above need to be kept.

View 2 Replies View Related

Copy Color Cells From Other Sheet Similar To Lookup

Jun 29, 2009

I have two sheets, one is "Summary" sheet and the other is "Sheet1". Both sheets has the same template. The "Summary" has color bordered cells and the "Sheet1" has no color. Whenever new color had been added to "Summary" sheet, I would like color from "Summary" sheet to be copied to "Sheet1" in same locations like if red been added to D12 cell in "Summary" sheet, D12 in "Sheet1" will automatically filled in red from "Summary" sheet. Similar to Lookup.

View 3 Replies View Related

How To Merge Similar Data

Jan 23, 2013

I have a large spreadsheet where some data are similar. for Example

Robert $1000
Louis $600
Glen $350
Doreen $2300
Robert $500
Louis $600
Glen $750
Doreen $300
Robert $3000

I want to merge all Robert together, all Louis together and show as one Robert $4500. How can I do that ? Should I use a Look up.

View 11 Replies View Related

Using Borders Where Data Is Similar

Apr 17, 2007

I have a spreadsheet that has descrptions in column D. Where the descriptions are the same ,

I need the VBA code that will do the following:

1) Sort the data by columns C (descending), G (ascending) & E (ascending)

2) Putting a border around all the data where the decriptions are the same
i.e from column A to Column I beginning from row 2

I have attached a sample file for ease of reference....

View 9 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 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:

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

View 9 Replies View Related

Gather Data Across Several Similar Sheets

Mar 3, 2014

This particular formula is used several times to gather various data points across 3 different sheets named Month-1, Month-2 and Month-3.I gather the data the following 3 formulas then sum it as needed with a helper cell.



View 2 Replies View Related

Selecting Groups Of Similar Data

Aug 5, 2009

I have ~1,000 rows of data utilizing columns A:C. The data is "grouped" by data that is in column C. Layout is as follows for example

Row01.....Column A......Column B.......Column C
Row02.....some data.....some data.....apples
Row03.....some data.....some data.....apples
Row04.....some data.....some data.....apples
Row05.....some data.....some data.....apples
Row06.....some data.....some data.....oranges
Row07.....some data.....some data.....oranges
Row08.....some data.....some data.....oranges
Row09.....some data.....some data.....oranges
Row10.....some data.....some data.....pears
Row11.....some data.....some data.....pears
Row12.....some data.....some data.....pears

I have been trying to come up with some code that will "select" groups of data and then perform an action on those cells. As an example:

View 5 Replies View Related

Comparing Two Similar Sets Of Data

Apr 30, 2014

I've got a pretty tough problem I need to solve with excel. So im comparing prices of products from 2 Different Sources, I need the best method of comparing these sets of data. Realistically I need both sets of data to compare and move automatically (or create duplicates elsewhere) to show the product ID, Price A and Price B.

Here's an example

Supplier A
Cheese Grater: 39.99
Golden Spoon: 129.99

Supplier B
Cheese Grater: 59.99
Golden Spoon: 89.99

These values will then combine to read

Supplier A Supplier B
Cheese Grater: 39.99 59.99
Golden Spoon: 59.99 89.99

Not sure if it will matter but both lists are not identical, all I want are the matches not the ones unique to different suppliers.

This comparison list is like 12,000 products long, I'll never be able to do it manually. This has stumped me for a while now I only seem to be able to find formulas which give TRUE / FALSE or Colour changes.

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

Grouping Data From Similar Fields

Jan 4, 2010

I have a set of data that looks like this:

A | B | C | D
100 | 2 | 0 | 0
100 | 0 | 0 | 7
100 | 6 | 0 | 0
101 | 8 | 0 | 0
101 | 0 | 5 | 0
101 | 0 | 0 | 1

Column A is a 'User Number' and columns B-D contain values.

I was hoping to use this data to create a new range where each 'User Number' only has one row, and the values in the other columns are summed for each user.

This would ideally look like this:

A | B | C | D
100 | 8 | 0 | 7
101 | 8 | 5 | 1

View 9 Replies View Related

Macro To Set Current Time In A Cell Without Changing Similar Values In Other Cells

Mar 4, 2012

I have a Macro 'Timenow' to give current time in a Cell of MS Excel, but then it changes all Cell values of sheet where the macro was used.

Sub Timenow()
' Timenow Macro
' Keyboard Shortcut: Ctrl+b
ActiveCell.FormulaR1C1 = "=NOW()"
Selection.NumberFormat = "h:mm"
End Sub

Even assigning value to variable does not work:

Sub Timenow()
' Timenow Macro
' Keyboard Shortcut: Ctrl+b
Dim TN As String
TN = Format("=now()", "h:mm")
ActiveCell.Value = TN
End Sub

how to restrict the macro to change the value of current/active cell only without effecting other cell values?

View 4 Replies View Related

Merging Cells In Row That Have Same Values?

Nov 23, 2013

I'm trying to merge cells in a row (row 1, in the example below) that contain the same values. For example:




I've used the following code, and it actually seems to work, but it gives me a runtime error and I can't figure out why.

Sub MergeCells()Dim r As Range, c As Range
Dim i As Long, j As Long
Set r = Range("A1", Cells("1", Columns.Count).End(xlToRight))


View 5 Replies View Related

Merging Cells Where Row Is Variable In VBA

May 27, 2012

Merging cells where the row is a variable. The code has two loops that consolidate date from two other sheets, it works fine but as you can see it puts the data into columns A,B and C,D respectively. My goal is to combine both into the A,B columns, which I can do very easily. My problem is that between the loops, marked by "HERE" i want to skip a line, merge cells A and B on whatever row that maybe and set an header.

Workbooks("Discovery Errors.xls").Sheets("Totals").Range("A3:U60000").EntireRow.Delete
Workbooks("Discovery Errors.xls").Sheets("Totals").Range("A3:U60000").EntireRow.Font.Bold = False

ActiveWorkbook.Sheets("Disc_Nodes").Range("A1:U60000").Sort Key1:=Range("J1"), Order1:=xlAscending, Header:= _
xlYes, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
LastRow = Cells(Rows.Count, 1).End(xlUp).Row

[Code] ........

View 1 Replies View Related

Merging Duplicate Cells ..

Mar 25, 2008

how would i run a macro to merge duplicate cells in a column

For example, i have lots of data in columns A, B and C

however some of the data in columns A and B is the same. Column C data never changes. so to make it easier to read, i would like to merge these cells (which are the same) together?


would become.... (with all the other data the same)




I dont want to lose any of the rows, as the data in column C is always different. I just want to merge the similar ones, so its easier to read.

Its a bit like this, but i cant even come close to getting this to work:

View 9 Replies View Related

Merging Multiple Cells

Feb 8, 2007

Is it possible to write a macro whereby the data in numerous cells in a row, say A1:K1 are copied into one cell, L1 then the cells from the next row, A2:K2are copied into the same cell, L1 but on the line below in the cell. I know the above doesn't make much sense so i've attached an example.

View 5 Replies View Related

Combining And Expanding Workbooks With Similar Data?

Jul 13, 2012

I have to compare and combine data from multiple files and combine it into 1 master spreadsheet. I have attached a sample file. It is in bulgarian, but the language is of no importance. An example of the file: it contains data about repair maid on a truck. First column is just the number of the repair type and shall be filled upon completion of the table. the second column is the name of the repair itself. the 3rd column is the date the repair was made. the 4th column - the total work hours the repair was made. Some repairs were made more than once and thus the merged cells 3 to 9 in column B. I have 30 trucks which have more or less the same repairs, just a different number of each repair. A sample file of 1 truck is attached, called 1truck.

The master spreadsheet should be of the same type as the example, however showing data for all trucks (from different files) next to each other. (the attached "alltrucks") As you can see there are repairs done only on some trucks, and others are done multiple times. The master sheet should have all possible repairs from all trucks. So far I've been doing it manually, but takes way too much time...

View 1 Replies View Related

Copyrights 2005-15, All rights reserved