+ Reply to Thread
Results 1 to 8 of 8

need formula or vba code to count tech id between range

Hybrid View

  1. 07-04-2022, 09:41 AM #1
    johnlara
    johnlara is offline
    Forum Contributor
    Join Date
    04-30-2013
    Location
    washington
    MS-Off Ver
    Excel 2019
    Posts
    168

    need formula or vba code to count tech id between range

    Dear experts

    I have data of sales i want calculate % of region and pass/fail success rate in count and percentage

    i have tech id like TCID_001,TCID_002,......TCID_033 I want calculate range between tech id range like

    for e.g TCID_001-TCID_006 how many region between this tech ids, count of pass/fail and % Percentage of pass/fail from overall number
    TCID_007-TCID_0010 how many region between this tech ids, count of pass/fail and Percentage of pass/fail from overall number


    i want a excel formula or code to calculate

    please find the attachment
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-04-2022, 09:44 AM #2
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,603

    Re: need formula or vba code to count tech id between range

    Hi
    are you still using XL 2007? If not please amend your profile accordingly, thx ( answers are tailored to XL versions)
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
  3. 07-04-2022, 05:21 PM #3
    johnlara
    johnlara is offline
    Forum Contributor
    Join Date
    04-30-2013
    Location
    washington
    MS-Off Ver
    Excel 2019
    Posts
    168

    Re: need formula or vba code to count tech id between range

    excel 2019
    Reply With QuoteRegister To Reply
  4. 07-04-2022, 06:19 PM #4
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: need formula or vba code to count tech id between range

    With a table to determine the group.

    VLookup to add the group.

    After that a pivot table.

    See the attached file.
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
  5. 07-05-2022, 09:16 AM #5
    johnlara
    johnlara is offline
    Forum Contributor
    Join Date
    04-30-2013
    Location
    washington
    MS-Off Ver
    Excel 2019
    Posts
    168

    Re: need formula or vba code to count tech id between range

    hi experts i need a formula for this taks some time i use dashboard and charts with these counts and percentages
    Reply With QuoteRegister To Reply
  6. 07-05-2022, 09:25 AM #6
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: need formula or vba code to count tech id between range

    How about the solution in #4?
    Reply With QuoteRegister To Reply
  7. 07-05-2022, 09:49 AM #7
    CheeseSandwich
    CheeseSandwich is offline
    Forum Expert CheeseSandwich's Avatar
    Join Date
    12-22-2021
    Location
    Kent, England
    MS-Off Ver
    365 - 2501
    Posts
    1,432

    Re: need formula or vba code to count tech id between range

    I created a couple of different UDF's and applied them to your table. May not be correct but thought i would have a play.
    Attached Files Attached Files
    If things don't change they stay the same
    Reply With QuoteRegister To Reply
  8. 07-06-2022, 01:16 AM #8
    johnlara
    johnlara is offline
    Forum Contributor
    Join Date
    04-30-2013
    Location
    washington
    MS-Off Ver
    Excel 2019
    Posts
    168

    Re: need formula or vba code to count tech id between range

    Thanks alot sir for took my task for completion and spend your valuable time for me, Solved
    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. [SOLVED] VBA code to count unique words in a range of cells
    By scottyblaze in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 08-21-2014, 05:17 PM
  2. Congrats TECH-Team
    By HaHoBe in forum Suggestions for Improvement
    Replies: 3
    Last Post: 03-23-2013, 03:59 PM
  3. I need a tech geek here!!!
    By ninaperez in forum The Water Cooler
    Replies: 1
    Last Post: 02-04-2011, 02:52 PM
  4. VBA code to count non blank cells in a range
    By James_B in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2010, 02:19 PM
  5. coding tech
    By x taol in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-18-2006, 08:40 AM
  6. Tech help
    By Mike in forum Excel General
    Replies: 0
    Last Post: 10-19-2005, 04:05 PM
  7. [SOLVED] TECH SUPPORT NUMBERS
    By Alan in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 03-28-2005, 12:06 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