name fields

  1. O

    equation to output 'name', "COPY", or "NOT FOUND"

    <colgroup><col><col><col><col><col><col></colgroup><tbody> Hello, I had an excel test that I didn't do particularly well on, but this one question had me stumped. I need an equation that takes the name in this list and out puts the agent name in 'first.initial' or...
  2. S

    Split Text into 1 Column from String

    Hi guys, I'm trying to extract the first and last name from the string below into a Cell. <tbody> https://websitename.com/tour#/first-last?p=237 </tbody> I tried the following function "=RIGHT(C2,LEN(C2)-SEARCH("bands/",C2,1)-5)", but only getting "first-last?p=237". Is there a way to get...
  3. J

    Name of Merged Cells

    I am stumped! I have a good level of VB experience and have combed through VBA posts for answers but this one is beating me. Here is where I am at: - Merged 4 cells together (A1:B2) - Renamed merged cells "SampleBlock" - Select the range "SampleBlock" with the cursor so that it is the active...
  4. I

    MATCH function to find position of the result of NameRange

    Hi All, I have 3 user defined Names - ExecWinchrome, ExecWinFireFox, ExecWinIE. I need a function that tells me which one of these has minimum value and then find the position. In turn based on the position, I wast to display the Name I tried the following =Match(MIN(ExecWinchrome...
  5. F

    Row naming + Index function ??

    Hi, I have the following problem: I have two workbooks in Excel with the first stating time series information about a company, for example the revenue of the company broken down by country (in rows), i.e. Caribban, Panama, Macau and then total; while the years are stated in columns i.e. I...

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