michael

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

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

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

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

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

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

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

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

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

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

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

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

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

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