+ Reply to Thread
Results 1 to 8 of 8

Count Other

  1. 08-31-2022, 12:45 PM #1
    CarmenV
    CarmenV is offline
    Registered User
    Join Date
    09-07-2021
    Location
    Boston, MA
    MS-Off Ver
    365
    Posts
    4

    Count Other

    Hello,

    I have a list which is compared to another sheet to return the value (simple enough)

    But here's the list:
    Project Support Vendor - PM
    Project Support Vendor - IP
    Project Support Vendor - C/P
    Project Support Vendor - System Planning
    Project Support Vendor - Environmental
    Project Support Vendor - Enviromental GZA
    Project Support Vendor - Environmental Mapping
    Project Support Vendor - SCS - None
    Project Support Vendor - SCS - Campaign
    Project Support Vendor - SCS - Notification
    Project Support Vendor - SCS - Outreach
    Project Support Vendor - SCS - Traditional
    Project Support Vendor - Legal
    Project Support Vendor - Legal Vendor
    Project Support Vendor - Estimating
    Project Support Vendor - Outreach
    Project Support Vendor - Siting
    Project Support Vendor - Siting - None
    Project Support Vendor - Siting - Application
    Project Support Vendor - Siting - Local Zoning
    Project Support Vendor - Siting - Petition
    Project Support Vendor - Siting - Project Change Notification
    Project Support Vendor - Siting - Section 72
    Project Support Vendor - Siting - Section 72 Derterminations
    Project Support Vendor - Siting - Exempt Modification
    Project Support Vendor - UG CM/Support XLPE
    Project Support Vendor - UG CM/Support HPFF
    Project Support Vendor - Asset Management
    Project Support Vendor - Environmental Mapping
    Project Support Vendor - Other

    Each of these are accounted for except "Other", in the original datasheet the user would have entered the "Project Vendor - Description"

    How can I pull the random text that would be entered in place of Other? Do I have to make a long formula to exclude each of the Project Vendor instance?

    Thanks in advance for any suggestions.
    Reply With QuoteRegister To Reply
  2. 08-31-2022, 01:03 PM #2
    Glenn Kennedy
    Glenn Kennedy is online now
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,023

    Re: Count Other

    Hi there.

    A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

    Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
  3. 08-31-2022, 01:27 PM #3
    CarmenV
    CarmenV is offline
    Registered User
    Join Date
    09-07-2021
    Location
    Boston, MA
    MS-Off Ver
    365
    Posts
    4

    Re: Count Other

    My apologies, I've attached the spreadsheet.

    The Detail Summary Analysis tab will have a summary of the "##### Dets Summary" tabs.

    The highlighted fields on the Detail Summary Analysis tab are the ones that I can't tie and will be random or there may be no "others" to add.

    .
    Attached Files Attached Files
    Last edited by CarmenV; 08-31-2022 at 01:34 PM.
    Reply With QuoteRegister To Reply
  4. 08-31-2022, 01:28 PM #4
    Glenn Kennedy
    Glenn Kennedy is online now
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,023

    Re: Count Other

    Your attachment dropped off somewhere. Do have another go,
    Reply With QuoteRegister To Reply
  5. 08-31-2022, 01:35 PM #5
    CarmenV
    CarmenV is offline
    Registered User
    Join Date
    09-07-2021
    Location
    Boston, MA
    MS-Off Ver
    365
    Posts
    4

    Re: Count Other

    Quote Originally Posted by Glenn Kennedy View Post
    Your attachment dropped off somewhere. Do have another go,
    The original failed to upload
    Reply With QuoteRegister To Reply
  6. 08-31-2022, 01:37 PM #6
    Glenn Kennedy
    Glenn Kennedy is online now
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,023

    Re: Count Other

    OK.... it's there now. BUT. What do you expect to see? Where do you expect to see it?
    Reply With QuoteRegister To Reply
  7. 08-31-2022, 01:43 PM #7
    CarmenV
    CarmenV is offline
    Registered User
    Join Date
    09-07-2021
    Location
    Boston, MA
    MS-Off Ver
    365
    Posts
    4

    Re: Count Other

    Quote Originally Posted by Glenn Kennedy View Post
    OK.... it's there now. BUT. What do you expect to see? Where do you expect to see it?
    Dets Summary tab, rows 113:116 were manually entered when Project Support Vendor - Other was updated in the original template. I need to be able to capture these random entries and summarize them in the Project Support Vendor - Other (Detail Summary Analysis tab Row 168)
    Reply With QuoteRegister To Reply
  8. 09-02-2022, 10:42 AM #8
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,548

    Re: Count Other

    Perhaps the following:
    1. Populate in J138:J167 and J172:J181 using: =IFERROR(INDEX(INDIRECT("'" & $I$2 & "'!A8:AZ200"),MATCH(A138,INDIRECT("'" & $I$2 & "'!$A$8:$A$200"),0),MATCH("Check Calc",INDIRECT("'" & $I$2 & "'!8:8"),0)),0)
    2. Populate J168 using: =SUMIF('404959_C-21-257 Dets Summary'!A8:A200,"Project Support Vendor*",'404959_C-21-257 Dets Summary'!AJ8:AJ200)-SUM(J138:J167)-SUM(J172:J181)
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    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] Count list not Match to a range as criteria and count duplicate as one and ignoring blank
    By brake in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-03-2018, 05:00 AM
  2. Count duplicate cells in specific range // Count lunch/dinner participants
    By Arnodekkers1995 in forum Excel General
    Replies: 1
    Last Post: 05-19-2017, 07:37 AM
  3. How to count unique text & number to have same function with distinct count in office 2013
    By FM_mine in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 04-11-2016, 11:14 PM
  4. Macro count items in sheet2 and provide count in embedded label in sheet1
    By jaredmccullough in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-05-2015, 11:27 AM
  5. Range.columns.count property returns wrong count after union operation
    By gopinan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2008, 04:48 AM
  6. Count Intervals of Filtered TEXT values in Column and Return Count across a Row
    By Domenic in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 09-06-2005, 07:05 AM
  7. [SOLVED] Count Intervals of Filtered TEXT values in Column and Return Count across a Row
    By Sam via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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