belongs

  1. M

    Extract cell value

    Hi, When you have a list of names with corresponding %'s such as below and you have double names, such as Tom and Joe, how to get the first % that belongs to the respective name? Tom 0.5% Joe 0.25% Brad 0.25% Bill 0.35% Charlie 0.26% Tom 0.6% Joe 0.30% Many thanks
  2. A

    Look up online addresses for telephone #s

    If I have a list of telephone numbers on excel is there a way for it to look each number up online and return what company each number belongs to. I am sure I have seen someone do this but not sure how.
  3. P

    Filtering help

    Hi, kindly help me. In column A , I have a list of User while in column B I have a list of groups. Some user belongs to multiple group. What I want to happen is if I select a user all of the groups it belongs will be display. Any suggestion?TIA.
  4. B

    Help with formula - not sure what do to

    <tbody> A B C E F G www.reddit.com/r/news/blahblah r/news News Politics 1871511396470 www.old.reddit.com/r/news/blahblah r/pics International 90712378456 facebook/groups/1871511396470 r/dogs Dog Lovers /doglovers123 facebook.com/groups/catsgalore r/cats Cat Lovers...
  5. I

    Opening multiple workbooks causes identity issues

    When opening more than one workbook in Excel (latest Office 365 version) VBA code does not know which workbook it belongs to. For example, suppose you have two workbooks open and you switch from one to the other, perhaps using ALT-TAB. Any procedures or functions referring to a particular sheet...
  6. S

    Advice on vlookup across text and numbers?

    Hello everyone. I have a list of "numbers" which consists of three letters followed by six numbers. Batches will belong to different clients. E.g. ABC100000 to ABC110000 belongs to client A, ABC110001 to ABC120000 belongs to client B etc. I would really like members of staff to enter a number...
  7. R

    Formula to figure out which month a week of a year belongs to?

    Does anyone have a formula to figure out which month a week of a year belongs to? For example, this current week (week of June 22nd, 2014; for this application weeks start on Sunday) is week 26 of the year. It is a week in June of course. The complicated part is weeks where the month changes...

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