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


    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

  • SUMPRODUCT active link formula
    Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
  • Block certain cells in condition met in cell A
    Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
    Hi, Below formula works well, =(INDEX('PRICE LIST'!$C$7368:$C$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!$A$7368:$A$7679)*(WORKSHEET!P28='PRICE...
  • Match data from 3 columns to return data from the correct 4th column
    Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
  • VLookup
    Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
  • Defining a range
    Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back