john

  1. I

    Data separated by weeks-Macros welcomed and preferred

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

    Help with data that requires weekly hours worked.

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

    Issue with MATCH

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

    Delete duplicate data in Column I leaving just one unique row

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

    how to do SUMIFS on multiple filtered columns

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

    Remapping Columns

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

    Copy and Paste IF Cell in column is empty

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

    COUNTIFS? INDEX? MATCH? I just cant get this to work!

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

    Macro to display Google search hyperlinks and tooltips reading other cell value from same record

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

    Trying to pull 'Weekly' participation

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

    Formula problem and a pivot does not help...please can you?

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

    using structural table's columns

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

    Bolding words from text

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

    "sumif" help

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

    Dynamic Range Expansion (No VBA)

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

    Lookup between dates

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

    Creating an array for duplicate records

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

    Macro to Move Data with name to another sheet if name is moved

    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=...
  19. A

    Create a variable with just the first name from cell with full name

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

    INDEX / MATCH / MAX / MIN formula required

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

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