matches

  1. kevin lazell

    conditional formatting

    hi everyone not been on here for a while and am very rusty to say the least i have 5 consecutive cells say b1:f5 each cell has a date in each date is later than the previous one when b1 matches todays date then format red when c1 matches todays date then format yellow and b1 to go back to no...
  2. L

    Count if Date Matches

    =COUNT(Raw_Data[Week],44,Raw_Data[Region]) How can i change the above formula to count if the date under the header name Date in sheet Raw_Data matches the date in D2 or withing the week of the date under the calculation Sheet and the if the header named Count of assets in BU have data (if...
  3. B

    Index/match multiple criteria, multiple results

    I need to review a list of data and return all of the matches based on 2 criteria and cannot figure out the entire formula. Below is what I have now but it only matches 1 criteria: "CASH IN IMPORT'!$R$5. How on earth do I add a second criteria, which would be column B of sheet '3.INT' matching...
  4. T

    SUM INDEX MATCH Help.

    Hi I am currently using this formula. =IFERROR(INDEX(Transfers!$J$5:$J$999999,MATCH(A68&$A$61,Transfers!$F$5:$F$999999&Transfers!$H$5:$H$999999,0),MATCH($A$3,Transfers!$E$5:$E$999999,0)),0) It works great except it does not sum multiple matches it only find the first match in the table. I need...
  5. D

    #N/A error with Lookup and Min functions

    Good Afternoon everyone, I have run into an issue using Lookup with Min. I can use Lookup with Max and get the required results, =LOOKUP(MAX(E7:E1000),E7:E1000,D7:D1000) actually gives the date that matches the Max value. When I change the formula to =LOOKUP(MIN(E7:E1000),E7:E1000,D7:D1000), it...
  6. K

    old index match formula not doing what's needed

    I just found out an array index/match I wrote awhile back isn't doing what I needed. the formula is =IFERROR(INDEX(General.Lists!AV13:AV338, SMALL(IF(COUNTIF($CC$14,General.Lists!AN13:AN338)*COUNTIF($CC$15,General.Lists!S13:S338)*COUNTIF($CC$16,General.Lists!Z13:Z338)...
  7. L

    Change Formula

    Hello, I have the below listed formula that was created here for me, but I need to change it from looking at H8 or D8 to just look at the whole column for example just H or D and if it find it copy the date were it matches =IF(IFERROR(INDEX('Inventory Stats'!$H$8:$H$100,MATCH(D8,'Inventory...
  8. L

    Move Data If Sheets Match

    I need a formula to move data when column Matches I want to place a formula in a Sheet1 thats if Column D in Shet1 matches Column D in Sheet2 move the data from from shee2 for headers that match
  9. willow1985

    Looking for a more elegant way to write the following countifs formula

    Hello, was wondering if anyone could help me with the below formula. Is there a more elegant way of writing it rather than adding each additional section? I want the formula to count E:E if it matches Z2, and if S:S matches B12, C12 and D12. Would this be some sort of Countifs/And formula...
  10. K

    Need VBA help Cut and paste in to another locations if data and condition matches.

    Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> It is bit difficult to explain in the brief; so far here I will explain my requirement in the 4 steps to make it easer to understand, sorry for the trouble.</SPAN></SPAN> Step1</SPAN></SPAN> This is how looks my data sheet in the columns C, D, E...
  11. R

    Help with totaling up currency for a game

    I'm trying to make a spreadsheet as a shopping list within a game I'm playing in my spare time but for the life of me, I'm not able to figure out how to add up the values such that it correctly matches the game's values. 100 copper = 1 silver 100 silver = 1 gold An example can be found below...
  12. K

    Consecutive index match results??

    Hi, Does anyone know what I which additional formulas I would need to add/do to get this index match formula create a consecutive list of new matches as I drag the formula down to the next cells below So would like it to return the 1st match in one cell, then the second match in the cell...
  13. R

    Index/Sumif or Sumproduct

    <tbody> B C D E F G H I J K L M N O P Q 1 PROJECT 2019Q1 2019Q2 2019Q3 2019Q4 2019Q1 2019Q2 2019Q3 2019Q4 2019Q1 2019Q2 2019Q3 2019Q4 OP 2 YU 4 5 6 45 77 7 7 5 98 8 6 99 3 HU 12 34 6 7 8 1 3 4 6 7 9 2 2019Q3 4 PO 15...
  14. P

    Multiple matches in a column - need to sum up their matches.

    So in my example, in column A, I would like to look up the letter "B", and then look under the month of January, and sum up the number of "B"'s that is returned under that column. I just want the one row for the sum of B's. I dont want to have multiple cells that I still have to solve for, and I...
  15. F

    Vlookup on multiple matches

    Dear All I have a query related to multiple matches through VLookup In my attached sheet I have 2 list. List1 has Field1 and Time. List 2 has Field2 Field2 matches to Field1 to get the output on column E through Vlookup. But due to multiple matches I cant have the desired output. Desired...
  16. M

    Match & Countifs (probably ..)

    I've been struggling with a formulae (having tried various connotations of COUNTIFS) to first: - count the number of matches per item (an item can occur multiple times in the Master list) on an extensive list but that is further restricted to only those whose characteristic of interest has to...
  17. M

    Matrix matching function

    I created an x by y non-symmetric matrix in which, for values 1-5, "O" denotes a "preference to match". A "match" occurs only if both values reciprocate the preference (1 and 2 are a "match" because both prefer the other, while 1 and 3 are NOT a match because the preference isn't reciprocated)...
  18. J

    Sort List/Group, if matches value then return a value.

    <tbody> A B C D 1 Name Number Name Number 2 Alex 15 Sarah 45 3 Eric 20 Steve 33 4 Steve 33 5 Seth 33 6 Sarah 45 7 Erica 50 </tbody> I need to be able to Search Column A, find a Match for column C. Once that Matches, I need to Fill Column D with the same number to the...
  19. S

    Returning values for multiple matches without array formulas

    Hi guys, I am looking to effectively extract multiple matches without array formulas as the lookup array for the multiple matches is large and slows down my workbook too much. I have the values, lets call them 'account names', I want to match with as column headers, the lookup column is in...
  20. C

    vlookup question or index

    <tbody> 101 101 101 to 102 12 = 102 11 103 10 </tbody> Hey guys i am trying to write a formula that will will check to see if column D is greater then 12 then it will check to see if column A matches column B then pull the information from column C into...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top