tom

  1. B

    Converting name formats

    I need an excel formula to do the following name conversion: Current format: Tom & Nancy Smith Desired format: Smith, Tom & Nancy I have seen other examples that work with only one first name and one last name, but none for a couples first names. Thanks in advance, bateswi
  2. S

    Locum - multiple If Statements

    Looking to output column "D" Render. Thank you A B C D 1 DR LOCUM MOD Render 2 smith jack Q6 jack 3 smith (blank) Q6 error 4 smith smith Q6 error 5 smith smith "<>Q6" smith 6 smith (blank)"<>Q6" smith 7 tom tom "<>Q6" tom 8...
  3. M

    Comparing (>2) values, ignoring blanks

    I've got an interesting problem, where 5 systems contain lists of companies with IDs, and the companies are supposed to be consistent across companies, but I believe they're not, i.e: Company ID 123 may be "Tom Ltd" in the first system, "Adam Ltd" in the second system, etc for 5 systems, but the...
    • mr-tom
    • Thread
    • adam companies compare many cells systems tom
    • Replies: 4
    • Forum: Excel Questions
  4. A

    conditional formatting feature

    Hello. I have a table with 4 columns A B C D. The table represents names of students (column A), and three desired friends in class (columns B,C,D). For each student, I would like to color in blue cells of friends who are with him in class, and in red friends who are not with him in class. Can...
    • AMIRD
    • Thread
    • cells conditional formatting david ruth tom
    • Replies: 0
    • Forum: Excel Questions

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