Combine Cell Entries Based On Criteria

Mar 12, 2014

I need to first merge cell entries of column 2 if cell entries of column 1 are the same; following columns always retain their corresponding first row (see cells highlighted in yellow in attachment).

View 14 Replies


ADVERTISEMENT

How To Combine Duplicate Entries

Apr 23, 2013

excel.jpg

Basically I've made this up myself because what ill be working with has 100s if not 1000s of rows with many different product numbers that's quantities are different. What I've been able to do up to now is sort the spreadsheet by the product number so all the same rows are next to each other. My problem is however I need a speedy way of making these duplicate rows become one but add the total quantity basically everything in the left screenshot into the one on the right. What I've tried up to now is sorting them so there together and manually adding them up and putting them into one of the rows quantity, then delete the rest. takes to long. Another was to make a row underneath the rows I need into one but that takes more time than manually adding and deleting the rest.

View 9 Replies View Related

VBA Combine Cell Based On Condition

Jan 1, 2010

I have so data I am trying to combine based on count value of investment on Col A. If it appears more than once on col A then I want the col B values on col D. I have macro that works but I need make sure if Col B have any TRAC and TRL1 then I want to add that on Col D. For example so Col D1 would be EURX, TRL1 at 83.50, FTID and Col D5 would be TRAC at 87.88, Markit. Below is the macro.

View 9 Replies View Related

Expand A Cell Formula Based On The Entry Of Several Other Cell Entries

Jul 6, 2014

=IF(E14<=0,0,IF(N9="yes",MAX(E15*C15,30),30))

I am currently using the above formula and need to make an addition to it.

If D8 is greater than 9000 and less than 9999 then the entry will be 35 rather than 30. Any other entry in D8 would leave it at 30

View 5 Replies View Related

Restrict Time Entries Based On Another Cell

Jan 23, 2008

The 'gist' of what I need is for events scheduled (top of spreadsheet), no school can be placed into an event within 29 minutes (because one-half hour apart IS ok). The time increments are on the left side of the spreadsheet (rows). I'm trying to "automate" somehow so that if we try to plug a school into an event too soon from their last event, the spreadsheet won't allow it.

View 2 Replies View Related

Apply Conditional Formats To Cell Based On Entries In Another?

Jan 27, 2012

apply conditional formats to a cell, based on the entries in another, different cell?

View 2 Replies View Related

Count Values In One List And Then Narrow / Combine Values Based On Criteria And Count Those

Jan 20, 2014

I need a way to find a value in a column which has one or more corresponding values in an adjacent column. Then take all of the corresponding values found and count all occurrences of the found values in another column. But I only want to count the entries if an adjacent column is not blank.

Not the easiest thing to describe. Starting to wonder if I need to think in reverse. I hope the attached example makes more sense.

Book1.xlsx

View 2 Replies View Related

How Many Different Entries For A Certain Criteria

Aug 26, 2008

I have been searching a bit in a lot of the already posted threads but without any luck on my problem.

Normaly in excel you always want to count how many entries for a certain criteria.

Now I just want to know how many different entries for a certain criteria.

Example:

in column A1:A10 I have the value "S" -> group

in column B1:B4 I have the value "40" -> material number
in column B5:B8 I have the value "60" -> material number
in column B9:B10 I have the value "70" -> material number
....
....
etc.

So for the group "S" it is listet with total 3 different "material number" (40,60,70)

So my result should be = 3

how should the formula be on counting for the group "S" how many different values are in a defined area (e.g. B1:B10)

I have tried with sumproduct,

View 9 Replies View Related

Multiple Criteria: Combine All The Calculations

Mar 21, 2007

Is there any way to combine all the following calculations? Using the first as an example - If the word Resigned does not appear in P28 and if S28 = Q then the sum is 6 - 6*O28

=SUMPRODUCT((P28<>"Resigned")*(S28="Q")*(6)-(6*O28))
=SUMPRODUCT((P28<>"Resigned")*(S28="H")*(12)-(12*O28))
=SUMPRODUCT((P28<>"Resigned")*(S28="F")*(24)-(24*O28))

View 4 Replies View Related

Identifying Unique Entries Based On Unique Entries In Another Column?

May 29, 2014

I have a list of data and I want to identify the unique entries for both columns but the second column has to unique to the unique values in the first column.

Example List

Fruit
Color
Apple

[Code]....

View 9 Replies View Related

Retrieve Last X Entries By Criteria

Jul 27, 2007

I have a spreadsheet with columns A:AH. I need to be able to retrieve the last 50 entries based on a number from column M (Area). For example, I need a message box asking me what Area I want. (The choices are 1 to 7). When I select the Area number I need to retrieve columns G:J for the last 50 entries for that Area. In selecting the entries, it needs to ignore any rows where there is either a blank cell or a period in column I. This is a dynamis spreadsheet with rows added almost daily.
Zipped spreadsheet attached.

View 2 Replies View Related

Combine Rows From Matching Certain Criteria In Two Tables

Jun 9, 2013

I have a spreadsheet that contains two input tables: Parallel and Perpendicular. Next, the user can select a group which a certain entry belongs to. Now what I want is a "summary" of these entries in a table that has no blank rows and combines both Parallel and Perpendicular entries by the Group. Please note that there is no fixed number of inputs for any one group i-e the solution has to be dynamic.The groups are numbered from 1 to 6 and number of groups is fixed i-e 6.

A sample file illustrating the inputs and required output is attached.

I also posted this on: [URL] ....

Sample_file_summary.xlsx

View 2 Replies View Related

Count Unique Entries With Criteria?

Dec 3, 2012

Count unique entries in a column according to two specified criteria.Specifically, I am trying to count the number of days in a month a supplier has a visited.Below is an example taken from the excel:

COLUMN A COLUMN B
Date Supplier
01-ago-12 Mr X
01-ago-12 Mr X
01-ago-12 Mr X

I want a formula that allows me to see how different dates Mr X has visited in each month. So in August he has visited 8 times BUT only on 5 different dates.

In the case of Mr Y I want the formula to give the answer 5 (even though he has visited 6 times in total, he has visited on only 5 different dates).

In the case of Mr X in September, the answer to the formula would be 2, since has visited on 2 different dates in September.

View 9 Replies View Related

Counting Entries Using Time Criteria

Jun 6, 2006

I need to generate a report that indicates how long it took a vendor to respond, and indicate if the time was less than 2 hours.

I'm having trouble with a formula that will indicate how long it took for the vendor to respond during business hours (8-5 monday through friday). I can easily calculate the total elapsed time, but I'm at a loss on how to account for the after hours time period.

Would this be better handled with VBA?

View 3 Replies View Related

Combine Rows From Two Tables In Certain Order And Matching Certain Criteria

Jun 9, 2013

I have a spreadsheet that contains two input tables: Parallel and Perpendicular. Next, the user can select a group (from a drop down) which a certain entry belongs to. Now what I want is a "summary" of these entries in a table that has no blank rows and combines both Parallel and Perpendicular entries by the Group. There is no fixed number of inputs for any one group i-e the solution has to be dynamic.

Attached is a file illustrating the inputs and the required output. I would prefer a formula based approach but not against VBA based suggestions either.

Sample_file_summary.xlsx

Also posted at: [URL] ....

View 2 Replies View Related

Counting Unique Entries That Meet Certain Criteria

Oct 7, 2009

Every other line is the planned production and the others are filled in after as the actual production
I have a sumproduct formula right now that looks if the line is considered planned production and then if there is a number greater than 0 planned on that day. The idea is to tell me the number of Stations scheduled to run that day.

Here is my problem- if a station is running two different products it gets counted twice.
I am trying to find a way that once a station is counted it only gets counted once even though they are on seperate lines.
Attached is an example of what I have with the formula and below that is what I am looking for

View 2 Replies View Related

Populate Listbox That Will Display Only Those Entries That Fit Certain Criteria

Aug 30, 2012

I have a worksheet called 'Letters' with data stretching from A2:W5000. I need a Listbox that will display only those entries that fit the following criteria;

Columns A and O have data in them, Column V does not. The other columns can be disregarded for the purposes of this project. Additionally, is it possible for the Listbox entry to show any formatting that appears on the sheet? What I mean is, I have a conditional formatting set up on the sheet to show any duplicate entries, for example if the entry appears twice the cell fill colour is yellow - I need that to be shown in the Listbox too if it is possible.

View 9 Replies View Related

How To Show All Entries That Meet A Certain Criteria In A Seperate Worksheet

Jan 7, 2010

I have been working with personal record data in multiple workbooks, using sumif, index, vlookup etc to show various required info.

What I now need to do is take all the records of people aged between 16-18 and list this in a new worksheet.

I can get all the records I need in a pivot table but it needs to be something I can add columns to in order to gather further info.

View 7 Replies View Related

Count Number Of Entries Meeting Condition/Criteria

Oct 24, 2006

I have a spreadsheet that has 35000 entries and i am trying to count how many material are assigned to a particular group but cannot get it to work. I have included a test spreadsheet to explain what i am trying to achieve

View 3 Replies View Related

Excel 2013 :: Count Unique Entries In A Table That Match A Criteria?

Jul 11, 2013

2013

Current Year

Q1-13
Q2-13
Q3-13
Q4-13

Totals

Awarded
£19,000.00
£4,000.00
£3,250.00
£0.00
£26,250.00

[code].....

I need to count the number of unique companies that receive money within a specific QTR. I have made this simple example, I have a Table called Awards, with Headings for DATE, QTR, Company, Awarded, on one worksheet, that I need to feed the data into a summary on another worksheet. What formula using table heading can I use to achieve the answer 3 unique companies for Q1-13.

View 5 Replies View Related

Copy Cell Value To Cell On Other Sheet Based On Two Criteria

May 8, 2014

I used this vba code before:

[Code] ......

And it worked perfectly, but now i wanted to use it in an other file but just change the sheets and I keep getting an Error 13.

It should copy the data from sheet insertmeasurements c23 till end of data in the column next to it (is dynamic) and based on cell B1 and the matching category code in column B, put that data in the matching cell in column C to the matching cell (based on the criteria in column B and C) on the sheet storedata.

Attached File : Profitibility Database v1.4.xlsm‎

View 1 Replies View Related

Copy Cell To New Location Based On Criteria In Another Cell?

Jun 25, 2014

I've sent out a survey asking people to sign up for one of two groups, A or B. I have a table with a long string of responses, with the name in column A, and in columns B or C there is an X that shows whether they have chosen Group A (column B) or Group B (column C)

I am trying to write a bit of code where it would paste the names into a new table with the headers Group A and Group B. Here is what I have pieced together so far:

Sub Create_Groups()
For i = 2 To Range("B2").End(xlDown).Column()
If Range("B" & i).Value = x Then

[Code].....

View 5 Replies View Related

SUM Based On A Criteria And Another Cell Being Blank

Apr 23, 2009

I need to create a formula that counts up the number of times a specific word is put into a cell lets say 'Carpet' only when another cell is left blank.

Count the number of times between C1:10 the word 'Carpet' is input only when D1:10 is left BLANK?

If looked into DCOUNTA formulas and SUMPRODUCT formulas but seem to be clutching at straws.

My problem seems to be at referring the formula to the BLANK cell?

View 5 Replies View Related

If Statement Based On Various Cell Criteria

Aug 11, 2009

G5 - can contain True or false
G6 - contains text but the if is on the basis of this cell being "Hand Delivered" or not

I have tried the following to illustrate what I after:

View 2 Replies View Related

Populate Cell Based On Two Criteria?

Aug 2, 2013

I have a list of teams, and beside them I need a calculation to be filled.

The criteria is based on a cell reference (a month which can be changed from a drop-down in BM2) and also the name of the team.

dummy 16.xls

View 5 Replies View Related

Penalty Based On Criteria In Another Cell?

Sep 28, 2013

In my country, students are penalized when they fail Mathematics subject. That is when a student gets "F" in Maths. The penalty is only for those scoring Division I and II. The divisions change into Division III for those penalized but points remain the same. For example if a student ie Juma gets Division I of points 17 and he fails Maths, he should be penalized and get Division III of points 17. NB: Those who score Division III,IV and 0 are not penalized even though they fail maths.

View 5 Replies View Related

Clear Cell Based On Criteria

Apr 18, 2005

I'm trying to write a macro that clears the cell in the range V10:X14 if the value of that cell equals 99.

Sub MyDeleteCell()
For i = 10 To 14 Step 1
For j = 22 To 25 Step 1
If Cells(i, j) = 99 Then Cells(i, j).Clear
Next i
Next j
End Sub

It's giving me a "Invalid Next Control Variable reference" I've tried defining i and j as Integers but that didn't work.

View 3 Replies View Related

Add Cell Note Based On Criteria

May 28, 2013

I have a range of cells containing text values in BS15:DS50000.

What I want to do is look at each cell in the range BS15:DS50000 and if the cell contains the "" character, then populate text from column BH (if any) as a cell note.

For example, if cell DB42 contains the "" character somewhere within its text, then populate the text in BH42 as a cell note within DB42.

If BH42 is blank, then no cell note. (Also, if DB42 does NOT contain a "", then no cell note either.)

View 2 Replies View Related

Change Cell Value Based On Criteria

Dec 7, 2006

I have a series of data that I am trying to process based on various criteria and though this site I have solved most of the (simple) problems I had. I have one last problem to solve.

I need to add the previous cell to the next one based on a cell value in a different column.

Example: I want to add F2 to F3 if H3=3 but I need it to work so that if H4=3 it will add F3 to F4 and F3 now equal the new value i.e. (F2+F3). If H5 doesn't = 3 then F5=F5. I need the output to be a value not just an equation as I plan on going back and deleting all rows with H=3 in them.

P.S. I don't mind if the output of the calculation of the F column is to a new column or overwrites F. Overwriting would be easier for when I go back through and delete rows based on H=3.

View 9 Replies View Related

Parse A Cell Based On Criteria

Jan 19, 2007

I want to parse a cell if a date is present for example I have 03/26/1985 AL in one cell and want to parse to two different cells however in between those cells I have other cells with different data that I dont want to parse. Basically I need to parse the cells only if a date is present.

View 7 Replies View Related







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