Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 97
  • Last Modified:

Filter and Create a Column of Data

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
dbbishop
Asked:
dbbishop
  • 2
  • 2
1 Solution
 
Randy PooleCommented:
Any reason your just not using a filter then trying to use macros and formulas?
0
 
dbbishopAuthor Commented:
Because I'm not. I want user to see ALL data, and also specific data in a separate column.
0
 
Randy PooleCommented:
Give this a try.  Just click on a color in column B to run the routine
Lookup.xlsm
0
 
dbbishopAuthor Commented:
Thanks. Works great.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now