+ Reply to Thread
Results 1 to 2 of 2

Give value to specific string

  1. #1
    Registered User
    Join Date
    04-24-2013
    Location
    ithaca,ny
    MS-Off Ver
    google docs
    Posts
    18

    Give value to specific string

    Hello have a workbook attached - looking to be able to track vacations for each person.

    Would like to be able to count each time a specific contributer has used the string ie "vacation" give it a value for each month pull the data from "Forms output" page. Then list the number of times each person has used the srting "vacation" for each month in the owners month on a sheet called "vacation tracker" thereby being able to tell how many time a specific owner has used the the string "Vacation" each month for the whole year.




    https://docs.google.com/spreadsheets...gid=1885856332


    thanks
    Last edited by ithacarob; 02-19-2017 at 05:48 PM.

  2. #2
    Registered User
    Join Date
    04-24-2013
    Location
    ithaca,ny
    MS-Off Ver
    google docs
    Posts
    18

    Re: Give value to specific string

    I have half the formula
    =COUNTIFS('Forms output'!C2:J2,"=VACATION")
    But need C2;J2 to match =ARRAYFORMULA(IFERROR(INDEX('Forms output'!D$2:D$99967,MATCH($D6&$G$1,'Forms output'!$C$2:$C$99967&'Forms output'!$B$2:$B$99967,0)),""))

    and then have G$1 = Each month from "Vacation tracker" C3:N3

    thanks

+ 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. Replies: 24
    Last Post: 11-10-2015, 07:27 PM
  2. Need Formula to lookup for specific text in a string and give desired output.
    By winmaxservices1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-18-2014, 03:45 PM
  3. [SOLVED] vlookup type function, see if string has key, if it does give value
    By edsters in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-13-2013, 10:05 PM
  4. Trying to match partial string with another string and give position or cell
    By pat3white in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 07-01-2013, 10:07 AM
  5. Replies: 0
    Last Post: 03-13-2013, 03:34 PM
  6. Determine if give string falls between ranges
    By jsimha in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-16-2012, 04:54 AM
  7. Vlookup needed to give value lookup value is a string within a cell.
    By CFlack8472 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-23-2012, 01:20 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1