john

Hi, I have an excel sheet that has over 34,000 rows. It has the employees name, payroll date, and time card hours. Example: Payroll Name File Number Payroll Pay Date Timecard Hours John Smith 0012345 07/26/2018 8.00 John Smith 0012345 07/27/2018 8.00 John Smith...

Hi, I have an excel sheet that has over 34,000 rows. It has the employees name, payroll date, and time card hours. Example: <tbody> Company Code Payroll Name File Number Payroll Pay Date Timecard Hours PayCode AAA John Smith 0012345 07/26/2018 8.00 Reg AAA John Smith 0012345 07/27/2018...

Hey all, FormR kindly helped with combining two formulas together: =IF(AND(INDEX(T:T,MATCH(E5,AF:$AF,0))=G5,INDEX(BJ:BJ,MATCH(E5,AF:$AF,0))=H5),"Yes","No") This formula is replicated in Rows until 1500 i.e...

Hi I'm using excel 2016 i have a spreadsheet with 56,000 rows and in column I have i have a set of data that is duplicated i would like to delete the duplicates... however i need to retain the very last row of the duplicate as an example i have highlighted in red below ( the data is just a...

Hi ,I want to SUM after applying filters on multiple columns Table 1 <tbody> ID Salary Level1 Level2 ID123 6 John Tom ID123 6 John Tom ID123 7 John Richard ID123 7 John Richard ID123 8 John Swetha ID123 8 John Swetha ID123 10 John Randy ID123 10 John Randy ID123 10 Ram Rocky...

Hi, I am importing data from a text file into excel. Unfortunately the text file has stacked columns, so what would be the best way to convert the data from this: <colgroup><col span="2"></colgroup><tbody> Name Address Number Zip John 1234 St. 1111111 44444 Mary 5678 St. 2222222...

Hi I need a code that will copy and paste data from column D to column B if column B is empty, the code will ignore any empty cells in column D and move to the next cell with data to copy over. From this <tbody> A B C D JANE JANE DOE JOHN DOE JOHN DOE JANE JANE SMITH JOHN SMITH JOHN...

Good morning all. I am not all that savvy with excel and am attempting to create a form that will auto fill from another spreadsheet when given a few criteria. On the column header is dates from the first of a month to the end. On the Y axis are names. In the data range are letters denoting...

Hello, newbie here. I wonder if it's possible to create a macro which creates hyperlinks for all existing values in a column such that: 1. When user clicks a cell link, a Google search result page opens, showing results based on existing cell string value 2. Tooltip of each hyperlink shows...

Good day all, I'm trying to pull the weekly attendance of personnel, at the moment i do this manually (not clever enough to do the other bit:confused:), please see my screenshot of an example, I have on another sheet all the week numbers and dates they start/finish on. So I get the information...

Hi I have an excel query and i can not figure it out: I have a list of names in column A and Dates along in Row 1. And under the dates by the names are zeros or BH (Bank Holiday), W (worked), H (Hol) & HF (Half Day Hol) I am trying to get results by looking at the name i want to know when...

Hi I have a table like below. I highlighted and then Insert-->Tale. I click on a cell outside the table and wrote =sum([revenu]) But I got an error message? Why is that? when I can use Structural table columns? (for example [name], [store], [item] Thank you very much <colgroup><col...

I have raw text data in cell A1 I also have list of words that I want to be bolded to that cell. (These words are listed in column B) I want it to be like this: Bold every "Jack" and "John" in cell A1: Jack and John are brothers. Jack is older than John. Jack likes football but John hates...

Hello there, Please assist Please I need a formula that reports how much cookies James sold between <tbody> 03/01/2019 and 09/01/2019. See table below <colgroup><col><col><col></colgroup><tbody> <colgroup><col><col><col></colgroup><tbody> A B Salesman Cookies...

Hi I want to dynamically expand my data as follows without using VBA. I have text data in a single column. There is no empty cells in between the data but the number of rows having data can vary. <tbody> Names John Sam Jessica </tbody> I want my result as follows. <tbody>...

Hi I have a spreadsheet im trying to complete which if done manually will take forever but i cant work out how to automate. In one sheet i have information as per the below Date Employee Name Holiday taken 02/06/2018 Joe bloggs 03/06/2018 Joe bloggs 06/06/2018...

I am trying to recreate a multi-page invoice. I have it working as a single page but I think I need to abandon what I have already done use an array to cycle thru the data. Here is my data. <tbody> A B C Customer Invoice Payment 2 John K Company 3060453 $1 3 John K Company 3060453 $7...

Hello all I have a Master Sheet that has Names in column A and each Name has its own Sheet and Data ex: <tbody> A1 BOB A2 JOHN A3 PETER A4 SMITH A5 LIZ A6 TOM </tbody> I have A sheet named "1" in B1= BOB, Sheet named "2" B1= JOHN, Sheet named "3" B1= PETER Sheet named "4" B1=...

I have a spreadsheet which, simplified, is in this format: EUName >>>>>Product>>>>>>>>>>email John Smith>>>>Computer>>>>john.smith@abc.com Sara Jones>>>>Monitor>>>>> sara.jones@abc.com <end spreadsheet=""> And I have some code (simplified version listed below), that when I put the cursor on a...

I think my formula may require MAX INDEX and MATCHsomehow, but I’m stumped. I need to look at the earliest date and the latest date against memberslisted below (dates in between should be ignored). Ineed to then compare the Total Score against the earliest and latest date andif the Total...