How To Get Unique Value From Two Columns In A Third Colum
Dec 18, 2008I 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, 2009I 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.........
Autofilling A Colum That Has Different #'s And Spaces
Oct 23, 2008I 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.
Get The Status Colum To Update Automatically
Oct 10, 2008I 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...
Lookfunction (type In A Referance So It Will Give Me The Value In The Same Colum In The Row Below)
Nov 19, 2008i 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
Calculate Colum Total Based On Formula
Dec 8, 2009I 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
Formula In A Colum That Will Apply To The Entire Column
Jan 29, 2007way 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 RelatedNumber A Colum For Sorting As Data Base
Jun 11, 2008totaly 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.
Displaying Colum Where Data Exists In A Different Worksheet.
Jun 4, 2006how do I automatically add beside the name the colum title where it previously existed. see the attached.
View 2 Replies View RelatedLeave Planner & Box In Colum A To Reduce The Number Of Days
Mar 18, 2009I 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 RelatedFormula To Check Two Times And Count The Colum Figures
Nov 28, 2006I 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.
Find SUM Of Parts Of A Colum That Relate To The Info In The Column Beside...
Nov 26, 2008I 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).
Copying Rows With Multiple Colum Values To New Sheet
May 21, 2008I 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.
Unique Values In 2 Columns
Jul 30, 2013I 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.
Unique List From Two Columns?
Mar 20, 2013I 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]....
Getting Unique List From Combination Of 2 Columns?
Apr 18, 2014how 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
Unique Names From Multiple Columns?
Jan 22, 2013I 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 RelatedFinding Unique Combinations Of 2 Columns
May 30, 2008I 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
Show Unique Values From Two Or More Columns
Dec 21, 2008For 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 ?
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
Unique Entries In Each Column Of 620 Columns?
Jun 18, 2012I 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
Delete Entire Row If It Has Unique Value In Two Columns?
Aug 22, 2013I 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]
Count Unique Duplicates In Two Columns
Jan 25, 2010I 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.
Getting Unique Values In Multiple Columns Using Formulas
May 13, 2014I 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
Counting Occurrences Of Unique Text Between Two Columns
Dec 5, 2013I 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.
Finding Unique Groups Of Values In Columns?
Dec 17, 2013I 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!)
Make A List Of Unique Values Using 3 Different Columns?
Feb 26, 2014See 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
Unique Row Headers / Values To Subsequent Columns
Mar 9, 2014I 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
Create Distinct Unique List For 2 Columns
Aug 6, 2014So 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] ......
Compare The Two Columns And Pull Out The Unique Entries
Jun 1, 2007I 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.
