+ Reply to Thread
Results 1 to 3 of 3

Help with a formula to give multiple answers

  1. #1
    Registered User
    Join Date
    11-01-2011
    Location
    australia
    MS-Off Ver
    Excel 2010
    Posts
    13

    Help with a formula to give multiple answers

    hi i need help with a formula for my spreadsheet posted below
    i am new to this type of formula and not very clued on on vba's.
    thanks
    Attached Files Attached Files

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: Help with a formula to give multiple answers

    exactly what is it you want?
    this is what you noted in your sheet and it doesn't really give enough info to give you an answer...
    what I also want is column I to categorize the descriptions so I can put them in another table
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Registered User
    Join Date
    11-01-2011
    Location
    australia
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Help with a formula to give multiple answers

    i need a query on column D to determin a category in column I as posted
    i manually typed in categories in column I but want it to post them automatically
    when i paste in my statement

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Looping list of points through function to give answers
    By Spicey_888 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-14-2015, 12:45 AM
  2. Adding multiple answers to an IF OR formula
    By MOSBEIUK in forum Excel General
    Replies: 3
    Last Post: 05-06-2014, 07:32 PM
  3. Replies: 1
    Last Post: 01-30-2014, 12:44 AM
  4. [SOLVED] Formula help, multiple answers for IF function
    By bigdog08 in forum Excel General
    Replies: 4
    Last Post: 06-08-2012, 02:11 AM
  5. Replies: 1
    Last Post: 08-14-2010, 10:33 PM
  6. Replies: 0
    Last Post: 01-10-2006, 10:28 AM
  7. [SOLVED] How to create a formula with multiple contraints and answers
    By torky1 in forum Excel General
    Replies: 6
    Last Post: 03-05-2005, 04:06 AM

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