belong

  1. B

    Extracting all items if they equal a location

    I have a spreadsheet contains the different offices for our company. I would like to extract, using a formula, all the members that work in that office. If the Office was named Alcosta, for example, and their were 10 members I would like to show all the members belong to that office. Then, in...
  2. M

    Creating new table

    Hi everyone! I have a problem and I can't figure out how to solve it, so I would appreciate any help. 1. I need to check each row in OLD TABLE, look into HELP TABLE for NEW_ID (if exists) and create new ID in NEW TABLE 2. Then I need sum all values that belong to NEW_ID and insert into NEW...
  3. K

    Find Group VBA require

    Using Excel 2000 Hi, I have 4 groups C1:C2 = Group A = 7 &7 D1:D2 = Group B = 7 &Z E1:E2 = Group C = Z &7 F1:F2 = Group D = Z &Z C7:F9 I have got data, I want results in H6:K9 Example how it works... with row 5 & 6 Cells C5, C6 = 7 & 7 result in H6 = A (because it belong to group...
  4. 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...

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