index data

  1. B

    Index Function

    I have a table that lists names and dates in the rows next to each of them. Names in B3:B105 (range named "Name") and the Dates in C3:L105(range named "Requests") the entire range is B3:L105 (named "DaysOff"). I want to be able to enter a date (in cell N5) and have any name(s) be returned that...
  2. A

    Lookup a value in a list and return multiple corresponding values in a column

    I am looking for a formula to lookup a value in sheet1 Column A and return multiple corresponding values in Column B. I have sheet1 that contains Account Names (A2 - A65736) and Product Codes (B2 - B65736) and Account Manager Names (C2 - C65736). 1. Accounts have more than 1 product code...
  3. J

    Search count of multiple values

    Hi, I need to know how many values in a column match my criteria: Column a:a 1 2 3 4 5 6 7 8 9 10 Column b:b S D T S S S D D D T I need a formula that will go through column b and count how many times the following values occured consecutively. S D answer: 2 S D T answer:1 D...
  4. mcraven1971

    Need help with if, index, and concatenate

    Hello all... I have a perplexing dilemna. When my coworkers enter data into the "DATA" sheet it is entered as follows: A4: WELD ID B4: FIRST MEASUREMENT C4: SECOND MEASUREMENT D4: AVERAGE OF FIRST AND SECOND MEASUREMENT There will be upwards of 600 rows of data and 1,100 or more columns. On...
  5. T

    Return a name that goes with data from multiple sheets

    I have a workbook with multiple sheets. The last sheet returns the 10 largest inputs from all the sheets. I cant seem to get the data that belongs to the outcome. I want to have the name that belongs to the largest number in the column left to the number. -- removed inline image ---
  6. A

    Hyperlink Cells to changing sheets name

    Hi there, Once again I am trying to get your help on the below and am feeling lucky again. I have numerous sheets in a workbook with details of multiple projects (1 project = 1 sheet) and one particular sheet 'Summary' in which I need to have summary of latest updates of all the projects...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top