+ Reply to Thread
Results 1 to 5 of 5

Need help with an excel formula stumped!

  1. 10-14-2016, 07:39 AM #1
    Fitzlegend
    Fitzlegend is offline
    Registered User
    Join Date
    10-14-2016
    Location
    dublin
    MS-Off Ver
    2016
    Posts
    3

    Need help with an excel formula stumped!

    I have an excel file and one part of it is manual with a lot of entries each week. I know this can be done with excel but i am not sure of the formula to get this working.

    I have a column called OTC. Basically what this column purpose is to check if a task has a bug with it and this data will then be used in a pivot table. If the task is task underneath then there is no bug and it will return a 0 as in that task had no bugs. If a task has a bug underneath then it will be called a value based on how many child bugs there are. eg. if there is 4 bugs a 4 will go in the parent task.

    The bugs will have no data as these are the child bugs from the parent task. This is pulled from Team Foundation Server. Would anyone know the code to do this, it has us all stumped and would save so much time automating it. File is attached!

    Cheers
    Andrew
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-14-2016, 07:43 AM #2
    xlnitwit
    xlnitwit is offline
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Need help with an excel formula stumped!

    Hi,

    In B2 you might use

    =IF(E2="bug","",IF(E3="Task",0,MATCH("Task",E3:E$100,0)-1))

    and then fill the formula down.
    Don
    Please remember to mark your thread 'Solved' when appropriate.
    Reply With QuoteRegister To Reply
  3. 10-14-2016, 08:11 AM #3
    Fitzlegend
    Fitzlegend is offline
    Registered User
    Join Date
    10-14-2016
    Location
    dublin
    MS-Off Ver
    2016
    Posts
    3

    Re: Need help with an excel formula stumped!

    Cheers! that worked
    Reply With QuoteRegister To Reply
  4. 10-14-2016, 08:17 AM #4
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,384

    Re: Need help with an excel formula stumped!

    For future reference, most people here are stumped and need help with an Excel formula, so your title did not really tell us much! The forum rules request that you make your title meaningful:

    RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  5. 10-14-2016, 08:28 AM #5
    Fitzlegend
    Fitzlegend is offline
    Registered User
    Join Date
    10-14-2016
    Location
    dublin
    MS-Off Ver
    2016
    Posts
    3

    Re: Need help with an excel formula stumped!

    Thanks will do, and honestly i didnt really know what to call it as i was not sure if it would be a formula or a different method to solve it.
    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. Formula Stumped
    By NSchipper in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-19-2016, 02:39 PM
  2. IF THEN formula stumped
    By tig1142 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-30-2014, 03:04 AM
  3. Stumped on Sum/CountIF Formula
    By abaibai in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-28-2013, 03:04 PM
  4. [SOLVED] Stumped on an IF Formula
    By studiostustar in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-17-2012, 08:13 PM
  5. [SOLVED] Stumped with Formula Array returning cell adjacent to formula dataset
    By Giles_Silver in forum Excel General
    Replies: 5
    Last Post: 06-04-2012, 12:18 AM
  6. Excel formula - stumped!
    By jamdav666 in forum Excel General
    Replies: 2
    Last Post: 03-22-2012, 11:51 AM
  7. Stumped on Formula
    By Jessamynhp in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-19-2005, 06:05 PM

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