Solved

Filter and Create a Column of Data

Posted on 2014-09-04
4
89 Views
Last Modified: 2014-09-08
I have a workbook that has data in several columns. I want to create a new column that consists of the values in one colum,n when another column meets a certain criteria. As an example, given the list below, it contains 2 columns. I want to create another column that has a formula that will contain a list of venhicles that are blue. Thus, it would contain '2012 Caravan' in row 1 and '2011 Chrysler 300' in row 2. I want the rows contiguous rather than having something in row 1 and another value in row 4:

'2012 Caravan'   'blue'
'2008 Mustang'  'red'
'2010 Corvette'  'yellow'
'2011 Chrysler 300'  'blue'

I am using Excel 2010.
0
Comment
Question by:dbbishop
  • 2
  • 2
4 Comments
 
LVL 21

Expert Comment

by:Randy Poole
ID: 40303779
Any reason your just not using a filter then trying to use macros and formulas?
0
 
LVL 15

Author Comment

by:dbbishop
ID: 40303915
Because I'm not. I want user to see ALL data, and also specific data in a separate column.
0
 
LVL 21

Accepted Solution

by:
Randy Poole earned 500 total points
ID: 40304005
Give this a try.  Just click on a color in column B to run the routine
Lookup.xlsm
0
 
LVL 15

Author Closing Comment

by:dbbishop
ID: 40309961
Thanks. Works great.
0

Featured Post

ScreenConnect 6.0 Free Trial

Explore all the enhancements in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question