michael

  1. J

    How to add space after text

    Column A, has a bunch of names, I need column B to take the names from column A and add a space with OR at the end. Example Michael Jackson need it to be Michael Jackson or Rhonda Rousey need it t be Rhona Rousey or Better yet the end result would take all the names in column A and put...
  2. M

    HTML Maker...??? Installed.. How to use it...

    Hello, I downloaded HTML Maker... Unzipped it.. Double clicked on it.. Excel opens up, Now what..? I don't see it installed as an Add-In... I had it installed many years ago, but things change over time.. (I've forgotten even how to use it).. Are there directions on how to use it?... I...
  3. M

    Stumped... Need Help with formula...

    I'm having a problem getting this formula correct.. =IF(AND(B1="SF",B2:B100=N12),B1,IF(AND(C1="LF",C2:C100=N12),C1,)) The result returned is 0, It should return "LF" Any help would be greatly appreciated... Thanks... Michael
  4. M

    Time Function

    Good pm, Asking for help. I would like to know how to arrive at a computation wherein: cell A1 = time IN cell B1 = time OUT cell c1 = number that if the times from a1 and b1 will fall between 10 pm to 6 am per hour will return as 1; a1 = 9 pm b1= 6 am c1 = 8 a1 = 6 pm b1 = 3 am c1 = 5...
  5. G

    Copy Data from 1 workbook to another workbook and paste it below

    Hi Guys, need help in copying data from 1 workbook and paste it in another workbook but in the bottom area. <colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody> <colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody> From Branch Sales...
  6. P

    Help on Indirect

    Need help on the following scenario. I am trying to use the below formula but I cant make it work. =VLOOKUP(A2,INDIRECT("'C:\Source\["&C2&".xlsx]Sheet1"&"'!"&"$A:$D"),4,0) I have a masterfile that looks like this. <tbody> Task ID Team Ops Status 123 A Michael Completed1 456 C Jude...
  7. P

    Vlookup depending on cell value

    Need help on the following scenarion I have a masterfile that looks like this. <colgroup><col><col span="2"><col></colgroup><tbody> Task ID Team Ops Status 123 A Michael Completed1 456 C Jude 256 F Michael 933 G John 858 J Jude 451 I Michael </tbody>...
  8. N

    Compare Names between two files and get a address

    Hello, I've two excel files (A and B ). File A got Names of 1000 employees of our firm. File B is complete list and got names of 35000 employees of our firm including their location and country. A macro should compare names between File A and B and populate Location in File A after looking up in...
  9. W

    concatinating similair columns

    Hi, I am using Excel 2003 on Windows 7. I have data like the below table, where there is a name in each of Columns B,C,D,E,F and I have concatenated columns B,C,D,E,F into column A. I included this data into a pivot table and what I am getting is 2 rows of data in the pivot table. 1 for...
  10. A

    How to reference Tab #2 in Tab #1 within a formula

    Background - I have an excel document with more than three dozen tabs. It is a extremely very detailed file. Tab #1 is my master tab that pulls data from all of the other dozens of tabs to perform various calculations. In A1 of Tab #1 , I used a formula to populate the tab's name so I do not...
  11. B

    Saving the file automatically with the last person to close or view the file

    Is it possible to create a macro that will display in a cell the last person to view that file and to save it? Sometimes someone might open a file but doesn't make any changes. I was planning on turning on the track changes but I'm not sure if some of Excel's functionality is lost by doing this...
  12. L

    copy paste filtered list from column B: to A: in vba

    I have a list of cells - when I filter on emp_type for Manager in column C I can select all of the cells in column B then click on the "green dot" in the green select box and drag it (Fill_Left) over to column A - copying the filtered text to column A How can this be accomplished in VBA? other...
  13. B

    Excel Certification

    I'm thinking about taking the MS advanced Excel exam so I can add this to my resume. Does anyone know what is the best study materials to get to study for the exam? Is there a website i could go to for exam dates and times? Thank you, Michael
  14. M

    vlookups: Having variable data in the range

    Dear Sirs I am struggling to dea l with a current vlookup issue. The problem exists in this formula. =VLOOKUP("Total Revenue",(E28),4,FALSE) The value in cell E28 is as follows: '[Consolidation 0509.xls]summary report'!$B:$E Within the cell E28 done through a CONCATENATE I set it...

Watch MrExcel Video

This Week's Hot Topics

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