+ Reply to Thread
Results 1 to 15 of 15

How to find a result when you need to search a number of columns

Hybrid View

  1. 03-19-2014, 10:42 PM #1
    Beach Walker
    Beach Walker is offline
    Forum Contributor
    Join Date
    03-19-2014
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2010
    Posts
    101

    Re: How to find a result when you need to search a number of columns

    Thanks zbor

    How I am looking to set the report up is have a drop down menu on a separate tab that will search either the Area or Site, the results will only show that area or sites results(that have been selected by the user) but will show a number of different KPI's for the selected area or site as well as say the last 6 months results for the chosen Area or site.

    The pivot table looks like it could offer this but I cant seem to get my head around how.

    I have added some detail next to your pivot table to show how I am looking to set this up.

    Cheers
    Attached Files Attached Files
    Last edited by Beach Walker; 03-19-2014 at 10:57 PM.
    Reply With QuoteRegister To Reply
  2. 03-19-2014, 11:26 PM #2
    azumi
    azumi is offline
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 365
    Posts
    2,406

    Re: How to find a result when you need to search a number of columns

    Which column do you want to get result? Is that Column F? and with criteria Area, KPI, and Month?
    Reply With QuoteRegister To Reply
  3. 03-19-2014, 11:34 PM #3
    Beach Walker
    Beach Walker is offline
    Forum Contributor
    Join Date
    03-19-2014
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2010
    Posts
    101

    Re: How to find a result when you need to search a number of columns

    azumi yes I'm looking to get the result from column F in sheet 1, with the criteria searched 'Area' or 'Site'(both of these will be on the same drop down menu), this search will then populate against the 'KPI' and 'Month'.
    Reply With QuoteRegister To Reply
  4. 03-19-2014, 11:52 PM #4
    azumi
    azumi is offline
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 365
    Posts
    2,406

    Re: How to find a result when you need to search a number of columns

    Hope it helps, please see the file
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Search, find and add the result in a specific location
    By john55 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-13-2011, 10:42 AM
  2. Find column character search result
    By Lithium in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-09-2009, 12:05 PM
  3. How to use Form to Find and Display Search Result
    By xinzie in forum Excel General
    Replies: 1
    Last Post: 03-28-2009, 05:46 AM
  4. Search in Mulitple Columns and Return Corresponding Column/Row Result
    By JLRO in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-05-2008, 10:42 AM
  5. Search another Workbook to find result
    By brown_toby in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-30-2006, 04:14 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1