index count array

  1. C

    VBA alternative to Index/Match/CountaA

    Hi all I'm trying to find a way to create an alternative to a longwinded INDEX/MATCH/COUNTA formula in VBA, in the hope that the VBA simplifies the process, or at least has a more straightforward way of achieving the same end. The requirement of the formula is to lookup all entries in a...
  2. J

    Generate list from column A for all B cells containing number C

    I have a sheet with a list of names (A), followed by a cell (B) which contains one or more years separated by commas. I want to generate a list of all names from A when B contains the number in D: <tbody> A B C D E John Doe 1998, 2005, 2014 2005 John Doe Jane Doe 2012, 2014, 2017...
  3. J

    Translate Excel formula into a VBA working code

    I have limited experience with vba. I know how to create variables and print out a few things, but what I am looking to do is slightly more complicated than that. I was able to create an excel formula that looks at a list and returns the value for a corresponding row, column by using the index...
  4. M

    I've got a real tough one here. Need countifs & some weird combo of index/match ?

    Hi everyone, Let me first start off by saying that this is my first post here on the forum. I've lurked for a while now and answered all of my questions via the helpful and extremely courteous nature of everyone responding to others plea's for help. I'm unfortunately stumped beyond reason here...
  5. L

    Array formula to determine changes in price and time of changes

    Hey! I've been looking around for a while in the forums, but haven't been able to find a solution. I'm working on an array formula that is supposed to determine when a price of an item has changed and what the new price is based on an inventory log that contains several different items. I've...
  6. K

    Extracting last row data in col A from another worksheet based on list

    Hello, I'm hoping someone can assist. I have run into another issue. I have a workbook that has several sheets. The sheets are created based on a named range. What I am trying to do is with the main worksheet ("Project Tracker"), I am trying to enter a formula in the Due by date. If the...
  7. D

    Text position,remove and replace(inex? substitute?)

    Hi Masters/Sifu, I have a question where I need to allocate "@" in an email address and I need to remove text after that and replace with something else: For Examples: likeaboss@boss.com likeadude@dude.com likeabrother@brother.com I need to index the "@" and remove the text after that and...
  8. J

    starting range for an array

    I have a formula =COUNTIF('MAIN DATA'!$BS$20:$BU$4000,"15") i want to be able to get my starting column/row number with the index feature INDEX('MAIN DATA'!B:B,A1):'MAIN DATA'!$B4000 a1=2354 example 'MAIN DATA'!bs2354: just cant figure it out

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