Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 2 of 2

Thread: Pulling Cell values into Pivot table

  1. #1
    Join Date
    4th November 2011
    Posts
    12

    Pulling Cell values into Pivot table

    I have a set of data in 3 columns:

    A. Date (Number in Date format)
    B. Project Name (Text)
    C. Status (Text)

    If there a way to set up a pivot table to return Project Names in the Rows / Month in Column / Status Value in the Value area.

    eg. like this

    Date, Jan, Feb, Mar, Apr
    Project name 1, Red, Green, Amber, Red
    Project name 2, Green, Green, Amber, Red
    Project name 3, Red, Amber, Green, Red

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    25th November 2006
    Posts
    1,616

    Re: Pulling Cell values into Pivot table

    Hello,

    It seems you are looking for a Text-based Pivot table ...

    Robert Mundigl has created a very interesting technique ...

    see link http://www.clearlyandsimply.com/clea...using-vba.html

    Hope this will help you ...

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Set Values of Pivot Table on Itself
    By Bioxide in forum Excel General
    Replies: 1
    Last Post: June 19th, 2013, 23:04
  2. Replies: 9
    Last Post: May 1st, 2013, 13:03
  3. Replies: 1
    Last Post: July 2nd, 2008, 10:12
  4. Pivot Table Values
    By Sheri1234 in forum Excel General
    Replies: 2
    Last Post: June 15th, 2005, 07:26
  5. Replies: 3
    Last Post: March 20th, 2003, 23:38

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
  •  
porno