Search:

Type: Posts; User: Monica at Plastics; Keyword(s):

Search: Search took 0.00 seconds.

  1. Shared Workbook on one user not saving

    we are using a shared workbook and one of the users has the autosave button in the top left corner. I don't have that and i am able to save mine.
    But she can't and isn't getting updates.
  2. Replies
    3
    Views
    292

    Re: index across multiple tables

    You are correct about the upgrades. the amounts are all in that row (26) on my spreadsheet. I need it to list the choices out on a different tab it looks like this but I only want it to list out IF...
  3. Replies
    3
    Views
    292

    index across multiple tables

    is it possible to use this layout (they are tables, I couldn't get it to paste that way) and have excel look at all the tables and return the header and amount under the header of that table only if...
  4. Replies
    9
    Views
    425

    Re: Using IF and Index together

    I saved the sheet and repasted it and it is working now Thank you for all your help!!!
  5. Replies
    9
    Views
    425

    Re: Using IF and Index together

    That worked for the first row but if I try to drag the formula down I get #Num !
  6. Replies
    9
    Views
    425

    Using IF and Index together

    I have a spread sheet that if the number of units is greater than zero I have it returning the name of the product. I want to use index with that. First do i have to use match with it? How can I use...
  7. Re: INDEX Formula that Indexes cells with specific text String

    Thank you soooo much for all your help!!!
  8. Re: INDEX Formula that Indexes cells with specific text String

    The same data that I sent you previously is on each tab I just have a tab for each employee. Holiday is just spelled out in column H like the PTO was. cell A1 of 'PTO taken' has the word PTO. so it...
  9. Re: INDEX Formula that Indexes cells with specific text String

    is it possible to index this formula? =IF(Calton_Jacob!$H108='PTO Taken'!$A$1,Calton_Jacob!$I108,"")
  10. Re: INDEX Formula that Indexes cells with specific text String

    The only thing is I only want it to return only the PTO dates, I do have Holiday in that same column H as the PTO.
  11. Re: INDEX Formula that Indexes cells with specific text String

    So what I want is for it to return each employee's PTO amounts, without skipping rows on the results tab. I need it to show the date that it was taken and in a different column the hours that were...
  12. INDEX Formula that Indexes cells with specific text String

    I have a situation similar to this old thread here: https://www.mrexcel.com/forum/excel-questions/971417-index-formula-only-indexes-cells-specific-text-string.html


    <tbody>
    WE:
    1/18/2019
Results 1 to 12 of 12