index

  1. S

    Sum only up to a certain point, then reset

    I have a list of staff with the hours they have worked on a weekly basis. I want to be able to put in a week's column when a payment has been made (this can be done sporadically and so isn't every week). When I put this in a column I then need a row below to reset for the following week to only...
  2. I

    VBA - INdex Match Multiple results

    0 I have two sheets (As Diplayed Below). Sheet 1 or INformation is where i have all of my information Stored. And Sheet 2 is where i want it displayed based on the Urgency (Tab Selection). Please can someone help me with a VBA code which can load this data on each of the Sections on Sheet 2...
  3. V

    Index Match entire row descending order

    I have rows of data I am trying to Index Match variable amounts of dates from. I saw a blog mentioned descending order can extract the highest, then lowest matches. Table example: Bob None 1/1/2020 None None None 1/3/2020 None None None Stanley 1/10/2020 None None None None None None...
  4. W

    Return MULTIPLE corresponding values for TWO Lookup Value, Horizontally, in one Row

    Similar to this link(reference the bottom)- I am trying to return multiple corresponding values with two look up conditions, horizontally, in one row. Then I can apply it down other rows. Not sure how to go about this- I have been stuck for days. I provided a sample below: ID Name Qty A...
  5. tlc53

    Return Text if Number Matches

    Hi, I have been trying to figure out this formula for sometime and feel it's now time to call in the experts. A2:A10 Account Code (format ### or ###/###) B2:B10 Account Description (text) B15 - This is a manual entry tab, you enter the account number B16 = I want this cell to return the...
  6. C

    returning elo calculations from one sheet to another

    Hi everyone, I am quite new to excel and have stumbled upon a problem. Namely I have a document where on one sheet (see 1.png) I have a table with teams and their elo values, while on the other sheet (see 2.png) I have data from a certain period that is then converted to an elo change for a...
  7. R

    Fancy sumproduct / index lookup

    Hi, Apologies for not uploading a workbook - company restrictions prevent me from this However, I need to consolidate the employee data in table 2 at the very bottom and present it as per table 1 below this message. the main issue I'm encountering is that the pay category runs across the row...
  8. V

    Index and match function doesn´t work for all cells

    Hello, I would like to compare value in D6 with values in first column of table F10:G25 and when found just write down the value on right side in second column. I tried to use =INDEX(F10:G25,MATCH(D6,F10:F25),2) (cell F7) and then also =INDEX(G10:G25,POZVYHLEDAT(D6,F10:F25,0),1) (which is G7)...
  9. B

    Complicated lookup reference in table

    Hello! Need some help with a dynamic lookup reference, likely using some sort of Index/Match combination as I'm trying to lookup a player name in a table based on his position and team name. For example, if I use the table below, the row reference in the first Match can only be B2:B16 or D2:D16...
  10. E

    Index and If formula together with two criteria?

    Hi, I would like to know how I can make this formula to use two criteria: =IFERROR(INDEX(Vikta;SMALL(IF(Vikta[Grupper]=1;ROW(Vikta)-4);ROW(2:2));1);"") I have tried this but it gives me a a "#SPILL" error...
  11. J

    Show cell based on current date

    Hello, I come for help :) My situation is very specific and I just can't get match/index functions to work (probably doing something wrong). Data structure: Item stock= yesterday's stock - consumption + production + incoming + delivery - modification + "+/-" => Throughout the month (year)...
  12. C

    Collect data from multiple sheets using Index/Match

    Hi! I´m kind of a basic excel user and struggeling with collecting data from different sheets. First of, the Excel is in Swedish, so heres a short dictionary: #SAKNAS! = NA PASSA = MATCH -------------------------------------------- What i want to do: In my HEAD-tab is where I want all the...
  13. S

    Multiple Cell Check without VBA

    Hi, I have an hard time being able to figure out a solution to my issue and would like to see if anyone can help or has ideas of how this challenge can be resolved. I am trying to find a formula that is able to tell me if a cell has changed from a number to a text (horizontally) resulting in...
  14. O

    Need AGGREGATE to list when category is mixed up with others under one cell

    Hello, I have a Data-Validation Drop Down on Cell A1 that contains Board Game Categories and whenever I click them, I need excel to pull all the Board Games associated with that category and list them down in COLUMN A. So far, my code is only pulling Board Games that has that specific category...
  15. G

    Index and Match between 2 sheets in VBA

    Hello, hoping you can help. I attached a quick example of the structure of my sheet. I have an issues list that is reviewed weekly, tab names change each week. I want my macro to Index:Match to pull the comments from last week onto this week's list, associated to the right issue number. When I...
  16. E

    Change Index/Match after balance is used

    I currently have a macro that goes through inserting formulas into cells and a for loop that changes the colors of negative values in the balance column. I would like to change the "shop floor" value with one from further down in a list when the "Balance" is less than 0. My thought for this...
  17. T

    Create Drop-down List from Multiple Columns

    I have different accounts listed horizontally as in the picture. I'd like to create a data validation in a new cell that containing all the accounts I have i.e. "My credit card" and "Paypal". I've been working at this problem for hours. INDEX and MATCH don't work in this case. Why real-world...
  18. M

    Searching an array of cells for a value and returning the column headers where a value exists

    Hi, I'm trying to find a way which i can return the column headers where a value exists in the cells F:M for the same row. As you can see from the screenshot for the first row, i would like to search for any value in row 3 and bring back the column heads for the rows. I have shown in Column N...
  19. E

    Title a Sub Routine with a variable.

    I have over a dozen checkboxes. They are titled checkbox1, checkbox2, checkbox3... etc. They each have a sub routine that tells them what to do when click. These subroutines are identical except for the number that indexes each checkbox. While this was easy to create using copy/paste. It is...
  20. S

    Index/Match Formula - Sum if falls between a date range

    Hi all, Please can someone help? :-) I am trying to find a tidier version of the below formula - what I am trying to do is basically add up the values in row 2 for the week before. The displayed dates are Mon-Fri (not inc Sat-Sun). Note, the below formula would be in cell F3, so on the 2nd...

Some videos you may like

This Week's Hot Topics

Top