multiple values

  1. M

    Find and replace in all sheets, and replace in exact format and properties

    Hi, I got this code from another post. The solution is amazing and really helps me. I would like to know if there is a way so I can 'Find' and 'Replace the exact value' The values I'm replacing with are hyperlinks. So I would like to replace the new values with those hyperlinks and keep them...
  2. R

    Finding and returning one of multiple potential values from a range

    Hi Everyone Unfortunately I cannot download XL2BB (work IT security), so I have had to use the below screenshot. I am working on a large formula and have got stuck on one component. For ease, I have broken out this component and simplified it as follows: I have 5 values: MYTPP; MAPTM; EGPSD...
  3. R

    Sum based on looking up mutliple comma seperated values.

    Hi In Cell E2 below I have the formula =SUMPRODUCT(SUMIF($A$2:$A$5,MID(SUBSTITUTE(D2,",",""),ROW(INDIRECT("1:"&LEN(SUBSTITUTE(D2,",","")))),4),$B$2:$B$5)) and it works a treat. However I need the same in G2 to J2 (the ?'s), where it pulls out the values based on the Heading in G1 to J2. Thanks...
  4. C

    Find first match from one range in another range and return related value

    I need to find the first instance of a named range that occurs in a table and return another value from that table on the same row. Two Named Ranges Cat1 and Cat2 <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> Cat 1 Cat 2 Type A Type E Type B...
  5. J

    Conditional Concatenation of Multiple IP Address Values Into One Cell

    I have the ff. tables in a worksheet: Table A (Sheet 1) - a list of 1000+ computers that don't have a specific piece of software installed Table B (Sheet 2) - a list of 15000+ host-to-IP address entries from the local DNS obtained using the <code style="margin: 0px; padding: 1px 5px; border...
  6. J

    Multiple Criteria Filter VBA

    Hi, I'm trying to create a macro that will filter multiple values using array. However, I'm not sure what is the problem on the code and it wont filter more than two criteria. Im trying to filter column I if it contains "*Extra Air*", "*Extra-Air*", "*ExtraAir*", and if it does then I will tag...
  7. B

    complex VLOOKUP help please as need to know: how many sales per unique sku?

    Hi, We are using the value "unique sku" to look up to. The problem is that each sale is on its own row and we need a total of all sales. I know what the answers should be, what is the formula? I am very stuck using SUMPRODUCT VLOOKUP. Does anyone even know how to do this please?! Thanks, RP...
  8. V

    Lookup column A, return column C value where non-blank

    So this is only some test data to prove the concept. Essentially I have a data set that will contain duplicated values in one column which I need to do a look up on with either blank cells or a unique identifier in another column. If the desire look up value is present in the first column, I...
  9. L

    Return multiple values for a lookup

    I realize that this is a repeat of other posts that are out there but I have tried for hours to tweak the formula suggested in the other posts to fit my needs and still can't quite get there. I have a name in cell C3 (Sheet2) and I want to return all the values in column A of Sheet 1 where...
  10. B

    Conditional Formatting - Three colors for various values

    I have a column that has a percent value and I'd like <1% to be green, 1-2% yellow and >2% to be red. Is it possible to have multiple conditions on a single row? I can't figure out how to make that work. Any help would be GREATLY appreciated!
  11. J

    Slicer setting for 'Contains' rather than equals?

    Hi all, I am wondering if/how i can modify either my slicer settings or my data in order to achieve a regular looking slicer that acts more like a filter for 'contains' rather than equals... So i have a table with a list of my teams and another table with a list of tasks and which teams are...
  12. L

    Find value in string and return reference cell

    I have been a long time viewer of this forum but just recently signed up. Based on what I have found on here I know that someone has an answer to this problem. I have a cell in column B that contains a string of values (example 1) on one sheet in a workbook. On another sheet I have cells that...
  13. C

    Cell with comma seperated values and vlookup

    1st table/report has cells with single values as well as multiple values separated by comma. <tbody> Identifier AA XY,AA,YX BE RE,WX,EW,XT AB,ER, </tbody> if any of the values in the cell is there in the 2nd table I need to filter the 1st report. 2nd table/report <tbody>...
  14. I

    Lookup Returning Multiple Values

    Hello, Is there a function similar to vlookup that will return multiple values instead of just the first time it appears in a list. I have the same user submitting multiple files and when I get a report of all files submitted from a given day I want to be able to look up the user by their ID...
  15. R

    Lookup a list of values and return values in singe cell concatenated format

    Hi - looking for a formula/code to lookup a range of values from a matched value and present them in a single cell concatenated format including range and comma separator: There will sometimes be sequential values that can be ranged i.e. 100-106 but then there may be single values so needs to...
  16. B

    Multiple Date Trouble

    Hey All, I have two data tables linked by Sale number. Let's say the data looks like this: <tbody> Sale Number Sale Date 12345 01/01/2016 23456 02/02/2016 34567 03/03/2016 45678 04/04/2016 </tbody> <tbody> Sale Number Change Date 12345 01/02/2016 12345 01/08/2016 12345...
  17. T

    Look up and return value based on more than one factor

    I've been searching high and low for a formula that will return a value from a table based on multiple factors (seems to be some combination of IF and Vlookup formula). I looked through the forum to see if anyone has already posted a question similar to mine but I didn't find an exact match (is...
  18. K

    Searching for values in cells that contain multiple values per cell

    I have a column of data (Column A) that has multiple values per row that are delimited by a comma. I’m trying to find a way to search this column to find rows that have two or more codes from another column, Column B (single values in this column). Any ideas on how I can do this? My second...
  19. B

    Concatenate multiple values from table row into one cell

    I hope someone can help me with this, seemingly simple(?), need: I need a formula to search through a table's row for multiple instances of a certain lookup value, then retrieve an associated retrieval value from a different row in that table, and concatenate all those retrieval values into a...
  20. N

    Using VLOOKUP and SUM to calculate data from different sheets

    Hi all, I am trying to find a way to calculate a value using parameters stored in different sheets/tables. I have been trying to do this with sum and vlookup without success. The input data looks like this: <tbody> Type Power A 5 A 9 B 0 B 1 C 6 C 2 C 3 D 7 D 0 D 0...

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