abcde

  1. K

    Index/Match If

    Hello, I am looking for a formula. I have one tab with raw data, multiple records, multiple duplicates, etc (tab named [raw]). I have another tab [Plan] where I need to insert my formulas. In my reference cell A1; I will enter a unique ID number. I want to use that value I entered in A1 and...
  2. P

    How do I sum, excluding duplicate values?

    Example: I have one item number ABCDE but this item number appears 3 times, on rows 1 through 3. Each row lists a different raw material off the bill of material, along with the budgeted tons. Material A 5 lb. 500 tons ABCDE Material B 1 lb. 500 tons ABCDE Material C 2lb. 500 tons...
  3. K

    Matching between Multiple Dates

    Hello, I have two tabs. [tab1] is a mailing list. This tab holds a bunch of information regarding a marking letter which was sent; information fields are: [Customer#], [dateSent], and [colorPrefer]. <tbody> [tab1] A B C 1 Customer# dateSent colorPref 2 12345 1/5/2018 red 3...
  4. P

    Adding functionality to a formula to catch case sensitive issues

    Hello - I have the formula below but want to add ability to catch if B7 is not an exact match due to letters being lower or capital. i.e. ABcDE would not match ABCDE. I tried to add TRUE and EXACT terminology into the formula but could not make it work or I had it wrong somehow... ugh. Any...
  5. P

    Find multiple strings of data in data set and return values if found

    Hello, I am looking to see if i can do the following in a formula only. I have a headache from trying so hoping one of you experts can lend a hand i would be grateful. Thanks in advance! Note I used cells a,b,c,d,e etc to make the example easy, but I need to be able to use this anywhere in a...
  6. J

    How to get a row which has latest date in a column

    I need to vlookup a set of information from one spreadsheet. Problem I am having is the table array which i am selecting has multiple records with same unique value I am using. I want to get the data with the latest datetimestamp. The dataset is not massively big but has close to 200K rows...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Top