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...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top