consists

  1. J

    PowerBI - calculate difference of two median values

    Hi all, Hope you can help me with the following question; I have a couple of columns with data: - Column A consists of numeric data (revenue growth in %) - Column B consists of numeric & Text data (year: 2016, 2017, 2018 and current) - Column C consists of text fields (different geographical...
  2. Z

    VBA - WorksheetFunction.Small with conditions??

    Hi, Column A consists names, and Column B consists numbers. How can I find 3rd lowest value from column B, where column A contains "John" ?
  3. S

    Excel- Automatically Update one Table Based on Input from Another Table

    Hello all. I have 2 tables in separate worksheets (same workbook). First table is tblUnitList, second table is tblUnitLocation. I would like to manage tblUnitList and have tblUnitLocation updated whenever an addition, change, or deletion is made to tblUnitList. tblUnitlist consists of a header...
  4. E

    Sumproduct, Countif, Avoid Duplicates, Left - Not Calculating Correctly!

    Hello - I have been stuck on this formula for a few hours. It is the last one I need for this report. Here is mycurrent formula: =SUMPRODUCT((1/COUNTIF(CIF,CIF&""))*(--(LEFT(Officer,3)=D2))) CIF = my rangename for each customer’s ID, which consists of three letters and four numbers...
  5. N

    Cells Relating to Each Other...

    Good Afternoon to All... I have 2 columns, as the source information. Column # 1 consists of 6 digit numbers. Column # 2 consists of names that are associated to each number in Column # 1. I would like to key in the info of #1 (the 6 digit number) in any cell and have the name associated with...
  6. S

    Highest value in column

    I'm hoping someone can help with something I'm trying to do at work. Here's the basic situation: Column A consists of names and each name shows up 1-20 times. Column B consists of numbers. I am trying to highlight or somehow identify the highest number corresponding to each name. Is there a...
  7. M

    RANK based on multiple criteria

    I have a list of data that consists of 3 columns Col A consists of values T1-T4 Col B consists of a region name (North American, Europe, etc) Col c consists of a numeric value I need to create a formula that will rank the above based on their value within their region with all T1 values being...
  8. P

    SUM last N-entries until certain value is reached and then find earliest date from that range plus 180 days

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]-->I have two columns. Column A consists of dates and column C consists of numbers. I need to SUM last entries in column C until they reach value >=6, then find earliest date from...
  9. A

    Compare from 2 columns and retrive from third

    I have an excel file with 2 workbooks, one consists of ID and Sales and another consists of Client Name and Price I want, if I write Name for ID in 1st sheet then respective Sales block should take the Price value from 2nd workbook of respective Client Note: the values in ID and Client Name are...
  10. R

    Need Help VBA in outlook

    Hi Everyone, Can someone assist with my below requirements. 1. I am receiving more than 50 plus mails (excel) in my inbox which consists the same subject called "nata" 2. I just wanna open and consolidate those excels together using vba macro. Is it possible.

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top