How To Get Unique Value From Two Columns In A Third Colum

Dec 18, 2008

I have two columns in excel A and B. Now I need to create third column based on unique values from these two columns.

View 9 Replies


ADVERTISEMENT

Find All Data In A Colum With Same Value

Apr 18, 2009

I want to be able to find all data of same value under divcode (column A ) in worksheet1 and have it put into like columns in worksheet2. I would even settle for it selecting all the cells so i can copy and paste if i have to go that route.
Example below: find all data under divcode (column A ) that is equal to mpo and put.........

View 4 Replies View Related

Autofilling A Colum That Has Different #'s And Spaces

Oct 23, 2008

I am currently trying to autofill a column or use a formula to try and autofill. I know how to do the dragging thing but that is too time consuming as I have about 30,000 rows and this needs to be done weekly. I know there's a way to do it but I forgot. Basically if you look at the first number below (ends in 0612), I want it to fill all the cells that are underneath it until it reaches the next number (which ends in 0856 below), then I want to fill all the blank cells(that end in 0856) with the 0856 number and continue down.

Is there maybe a formula that I can create in the column next to this and have it do it that way, or is there an option that will let me do this by highlighting the column.

View 4 Replies View Related

Get The Status Colum To Update Automatically

Oct 10, 2008

I have a spreadsheet reports on tasks that is updated daily.
At the end of the columns is a due date column and a status colour column where 4 options are possible:
Red = out of target, yellow = on target, brown = still on target but at risk, and green = on target.

I have been asked to see if there is some way of making the status colour column automated so that as task pass their due date and are not complete or are complete, the status field changes automatically.

I have added the feature in =today() in cell A1 and another column next to due date date completed. I think these will help but not sure how to get the status colum to update automatically. I've tried using the IF function but that only returns text...

View 9 Replies View Related

Lookfunction (type In A Referance So It Will Give Me The Value In The Same Colum In The Row Below)

Nov 19, 2008

i would like a look up function that I can type in a referance so it will give me the value in the same colum in the row below.
so if the referance was sample 2 it would give me sample 3

sample1
sample2
sample3
sample4
sample5
sample6

View 5 Replies View Related

Calculate Colum Total Based On Formula

Dec 8, 2009

I would like to have something that looks like a running total, but isn't.

I have in a colomn 'rate' and after that a column for each month in a year.
I would like to have at the bottom a total cost, so rate x hours.
have a look at the picture.

is there a formula for this?
ratemayjunejuli
$10 2,02,01,0
$12 2,03,00,0
$10 3,02,05,0
$15 4,02,53,0

total cost $134,0 $113,5 $105

View 3 Replies View Related

Formula In A Colum That Will Apply To The Entire Column

Jan 29, 2007

way to put a simple formula in a colum that will apply to the entire column, no matter how many rows without having to physically copy it to the number of rows required?

View 11 Replies View Related

Number A Colum For Sorting As Data Base

Jun 11, 2008

totaly new to Excel (just using two weeks) as a database

I need to number a colum, 1 to what ever, so that I can use that colum to re-sort the data base back into original order.

View 9 Replies View Related

Displaying Colum Where Data Exists In A Different Worksheet.

Jun 4, 2006

how do I automatically add beside the name the colum title where it previously existed. see the attached.

View 2 Replies View Related

Leave Planner & Box In Colum A To Reduce The Number Of Days

Mar 18, 2009

I was created an annual leave planner and I would like the box in Colum A to reduce the number of days they have left every time they book leave. I would like it to start off as 25 days leave including UK bank holidays.

View 4 Replies View Related

Formula To Check Two Times And Count The Colum Figures

Nov 28, 2006

I need a formula to check two times and count the colum figures.

example only:

countif(=>4:30:00 PM <=5:30:00 PM)*(11/12/06)

So, I need to count all cells with time between 4:30 and 5:30 with the date of 11/12/06.

View 14 Replies View Related

Find SUM Of Parts Of A Colum That Relate To The Info In The Column Beside...

Nov 26, 2008

I am using Excel 2008 for Mac. I have a spreadsheet that I am essentially using as a simple cheque ledger so that I can keep track of who I have written cheques to, for what amount, and what has already cleared. I have a the following columns:

Name
Date Written
Cheque Amount
Cleared?

In the 'Cleared?' column I mark an X when it has cleared the bank. I'm trying to find a way to get the SUM of the whole 'Cheque Amount' column that hasn't cleared (ie: has nothing in the 'cleared' column).

View 3 Replies View Related

Copying Rows With Multiple Colum Values To New Sheet

May 21, 2008

I need to copy specific rows that have a specific value in colum B and Colum M to new worksheets.

So from below attached screenshot , say for an example macro shud filter rows that have "BigPond" in coloum B ,"RG2" in column M & "INT" in column W and i dont want all cells in these rows , i only want copy cells under column C,AK,AL,AM (in this order) to my other excel sheet that is named "BigPond" and it should paste it starting from Row5.

I want to avoid recording a macro as it selects a range and i am expecting more new rows every week so if a record a macro the cell range for selection changes and i get incorrect result.

View 9 Replies View Related

Unique Values In 2 Columns

Jul 30, 2013

I have 2 columns of data from which i want to summarize all unique values:

A1
A2
A2
B1
B2
B1
B2
C1
C2

So in my report, i need to see a count of of unique A with unique 1 or 2, Unique B with unique 1 or 2, etc.

View 6 Replies View Related

Unique List From Two Columns?

Mar 20, 2013

I have a huge list of part numbers that has component part numbers listed as well. I am trying to take the list and make a list of Parent part number and identify the component part numbers that are used in all the parent part numbers. For example from the table below of the three parent part numbers there are only two parent part numbers have a component part in common 0011 and 0015 .I am looking for a fast way to create a list that looks like the example table two below.Parent Part Number

component Part Number

1000123
0011

1000123
0012

1000123
0013

[code]....

View 9 Replies View Related

Getting Unique List From Combination Of 2 Columns?

Apr 18, 2014

how can I retrieve a unique list coming from a combination of 2 columns. Using VBA would be much better.

e.g.
Col1Col2
RED 1
RED 2
BLUE 1
BLUE 1
RED 1
BLUE 3
BLUE 2
BLUE 1
RED 1

Result will be

RED 1
RED 2
BLUE 1
BLUE 3
BLUE 2

View 3 Replies View Related

Unique Names From Multiple Columns?

Jan 22, 2013

I have multiple columns with names (lets say columns A, B, and C). I want to place only the unique names in column E. Is there a formula to do this? Each column does not contain all the names and each has names that are not in any of the other columns.

View 4 Replies View Related

Finding Unique Combinations Of 2 Columns

May 30, 2008

I have a spreadsheet with two columns:
The first one will always have a 'W' or a 'E'.
The second one will have a three digit code. Like this:

W 507
W 507
W 507
E 504
E 504
W 505
W 505
W 504
W 504

Is it possible to have output that show how many of each combination there is? Like this(for the example above):
W 504 2
W 505 2
W 507 3
E 504 2

View 14 Replies View Related

Show Unique Values From Two Or More Columns

Dec 21, 2008

For input I have 2 columns:
A---B
1---5
3---4
-----
2----
I need for output column C:
C
1
2
3
4
5
It's possible to do that using one or more function ?

View 2 Replies View Related

Counting Unique Across Multiple Columns?

Nov 23, 2011

=SUM(IF(FREQUENCY(IF(B2:B20="Temp",MATCH(A2:A20,A2:A20,0)),ROW(A2:A20)-ROW(A2)+1),1))

The works when referencing two columns. I need a total count of unique across three columns.

Sample Data

A | B |C
Jason | Temp | 1
Jason | Temp | 1
Jason | Final | 1
Kim | Temp | 1
Mary | Temp | 2

My summary table has the unique values of C in first column and the unique values of B as headers. I want the unique counts as the data.

Temp | Final
1 | 2 | 1
2 | 1 | 0

View 5 Replies View Related

Unique Entries In Each Column Of 620 Columns?

Jun 18, 2012

I have 620 columns of data with each column consisting of 17 rows. I need to be able to count the number of unique entries in each column. I recorded a macro that would do what I wanted, but it just used absolute references for each column, which would make the process rather tedious. Is there a way to make the macro less restrictive?

Sub Macro1()
Columns("B:B").Select
ActiveSheet.Range("$B$1:$B$17").RemoveDuplicates Columns:=1, Header:=xlNo
End Sub

View 1 Replies View Related

Delete Entire Row If It Has Unique Value In Two Columns?

Aug 22, 2013

I have worksheet, whose snapshot is given under (in reality, there are over 2000+ rows in worksheets)

I want a Macro which can perform following function in entire worksheet used range

Only retain the rows where the cell value in current row is identical BOTH in Column B, as well as column D in its immediate previous row

i.e. B14=B13 and ALSO D14=D13 (both condition should be valid, if not Delete entire ROW, i.e. having unique value)

Normally, ppl wish to delete the duplicates, but i want to retain the duplicate as identical data is of two different dates, control in Column O

My Worksheet looks like - [URL]

View 8 Replies View Related

Count Unique Duplicates In Two Columns

Jan 25, 2010

I need a one formula solution to compare two columns for duplicates and count the number of matched pairs. Need to ingore blanks. Can have matched numbers or letters. Asterik denotes a blank (empty) cell. Also only consider the first matched pair if there are more than one matched pairs.

Col A Col B
a
b a
* b
c c
d y
x f
f z
f z

In this case I only want to consider a:a, b:b, c:c and f:f, resulting in the count of 4.

View 9 Replies View Related

Getting Unique Values In Multiple Columns Using Formulas

May 13, 2014

I need to list only the unique values in a range found in multiple columns. Some cells are blank. I need to list all the unique values in numeric and/or alphanumeric order in another column within the same worksheet. I would prefer non-array formulas, if possible. See the attached file.

In the attached table, I have 5 columns and 5 rows of values in the range B2:F6. The unique values, in order, are 0, 1, 2, 3, 4, 5. This looks simple and can be done manually if the file is small but I have 150 columns and 150 rows, thus the need for automation.

List of unique values in multiple columns 2.xlsx

View 4 Replies View Related

Counting Occurrences Of Unique Text Between Two Columns

Dec 5, 2013

I have data like so

A B
water juice
water water
juice soda
water juice
juice juice

I need to count the number of occurrences when the answers between column A and B are not matching.

View 3 Replies View Related

Finding Unique Groups Of Values In Columns?

Dec 17, 2013

I have a file with immunophenotypic markers and their relationship to certain blood cells.

What I need to do is search the list and pull out the groups of defining markers for each blood cell. Some of the cells have many markers, some only have one but I need to find which combinations of markers identify each cell if possible.

I have attached the file (I think!)

View 14 Replies View Related

Make A List Of Unique Values Using 3 Different Columns?

Feb 26, 2014

See attached file with a smaller sample of the 1667 row table of data I am working with. What I am looking to do is make a list on another sheet of each every line with a county and have the corresponding Township and range with it. So if I have a cell and I select Audubon county, I would like a list to populate that has the 12 lines of Audubon county in column A, and the Township in column B and the Range in column C.

Excel Rate Example.xlsx

View 5 Replies View Related

Unique Row Headers / Values To Subsequent Columns

Mar 9, 2014

I have a table similar to the table on the left, and I need to convert it to something like what is on the right. Ultimately I will concatenate the numbers in the table on the right too with commas between, so if for some reason it's easier to go straight to that, that's an option.

So in the example below, states will be listed multiple times with a unique number next to it each time. The state may be listed up to say ten times or as little as one. Each time it is listed, it will have a different number next to it. I need to reformat this into one where each state is only listed once, and each possible number is next to it in one row.

20z3fwk.jpg

View 4 Replies View Related

Create Distinct Unique List For 2 Columns

Aug 6, 2014

So far I created code that creates a Distinct Unique item's list for one column. It works as it should but I want to modify the code to create a Distinct Unique item's list for two columns that are related to another i.e. a person's name to their license #.

Here is the code below that works for one column only:

[Code] ......

View 9 Replies View Related

Compare The Two Columns And Pull Out The Unique Entries

Jun 1, 2007

I have two columns in Excel.

I want to compare the two columns and pull out the unique entries.

So any entries that are in both column 1 and column 2 I don't want anymore.

I just want all the entries that are NOT IN BOTH columns.

View 11 Replies View Related







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