Results 1 to 4 of 4

How to aggregate data?

Threaded View

  1. #1
    Registered User
    Join Date
    02-21-2012
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    2

    How to aggregate data?

    Hi all,

    I have seven columns of mutually exclusive data. I just want one column to pick the data that is true and return that category

    A B C D E F Not Listed Category
    FALSE FALSE FALSE FALSE FALSE FALSE Not Listed Not Listed
    FALSE FALSE FALSE FALSE FALSE FALSE Not Listed Not Listed
    FALSE FALSE FALSE FALSE E FALSE FALSE E
    A FALSE FALSE FALSE FALSE FALSE FALSE A
    FALSE FALSE FALSE FALSE FALSE F FALSE F
    FALSE FALSE FALSE D FALSE FALSE FALSE D
    FALSE FALSE FALSE FALSE E FALSE FALSE E
    FALSE FALSE FALSE D FALSE FALSE FALSE D

    I'm trying to get the data in the "Category" Column to populate (what's in there now is just manual for illustration purposes).

    =IF(AK5="A"),"A",IF(AL5="B"),"B",IF(AM5="C"),"C",IF(AN5="D"),"D",IF(AO5="E"),"E",IF(AP5="F"),"F","Not Listed") This formula is not working, any suggestions?

    Thx
    Last edited by bumblebee88; 02-21-2012 at 04:20 PM.

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1