mary

  1. J

    Find, remove matching text from string

    In column C, i have a Text string spanning several hundred rows. In columns ("H:M") are a list of names, that are repeated down. I'm in need of a VBA script that will search through the text string, for key words from ("H:M") and remove all except those matching words. As an example to go from...
  2. kweaver

    VBA inserting subtotal(s) rows

    Before I totally kill my day trying to do this, I thought I'd post this considering how quickly perfect solutions are created. I have a sheet which is already sorted by column H (starting in row 5). [thanks, Fluff] I now need to put in a subtotal row for each group of names in H5:Hn and total...
  3. A

    Two way lookup for column title

    I have a table that looks like the following <tbody> A B C D John Mary 16 21 55 32 Alex Lisa </tbody> What I need to be able to do is look for the letter (column title) that corresponds to a score of 55 for Mary. In other words, search for Mary's scores, find her score...
  4. B

    Excel Multiple Search and return Non Array formula

    Hi, I have difficult question which I need non array formula in column B which looks at column A reference uses wildcard match Column an returns vales from Column E. Column A Column B Column C Column D Column E <tbody> Name Group Name Should Be...
  5. B

    Excel Multiple Search and return Non Array formula

    Hi, I have difficult question which I need non array formula in column B which looks at column A reference uses wildcard match Column an returns vales from Column E. Column A Column B Column C Column D Column E <tbody> Name Group Name Should Be Search...
  6. A

    VBA Function Lookup Bold Bring Back Under

    I have about 150000 rows of data like below. I would like to look up a bold value. For instance if I have New York in cell D1, I want to bring back all of the values underneath New York so it would return <tbody> Jay Fred Mary Ted Sam </tbody> Here is what the data looks like below...
  7. M

    Selecting blocks of data with VBA end.xldown and end.xltoright

    <tbody> XX_ID_A Site Name Manager 1 Fred 9 1 Mary 1 Jack 9 1 Jill XX_ID_B System Plan Fname Lname Man Note 1 TAD John Smith 6 Service 1 TAD Jerry Jones 6 HR 1 TAC Alan Berry 7 1 TAB Mary Dawson...
  8. M

    Conditional Formatting On Multiple Ranges

    Hi, Can you please help me with conditional formatting (highlight both cells) as with the below example to highlight the name "Mary" in the "NAME and "Qty" Columns on ranges A3:B7, C3:D7, E3:F7. I'm new here and its my first ever post,Thank You in advance. <tbody> SHIFT 1 SHIFT 2 SHIFT 3...
  9. T

    Macro to find name in header and put in word in column below header matching the number of rows in another column

    I'm trying to get the macro to look for "Mary Lee" in header (row 1) and puts in the word "LOAN" below it. It should go all the way down to match the number of rows in column A. The name "Mary Lee" may appear multiple times in the header. Data will change daily, so the number of rows in...
  10. S

    How to use VBA sort 3 fields and merge first field

    Want sort F2 F3 F4 first , merge F2 then count first item show happen counts and belongings date Second picture show my wanted result Can VBA do it ?Please help Raw data below <tbody> F1 F2 F3 F4 1 Mary M 2019/2/2 2 Wang FM 2019/2/3 3 Mary M 2019/2/4 4 Chang M 2019/2/5 5 Mary M...
  11. I

    VBA find using variable refence entered in workseet

    <tbody> Column A Column B John John Search value entered to be used in VBA Mary Mat Johnny MaryS </tbody> I want VBA to find information in the worksheet, where the VBA find function uses the supplied search base from the excel sheet.eg above. The VBA code must find...
  12. I

    Help with Script, error in hourly calculations

    I posted this a few weeks ago, as i was working with the data, i noticed that some of the hourly calculations were not correct. To shed some light on this, here is what i am trying to do: I have the following headers: A=Payroll Company B=Code Payroll Name C=File Number D=Payroll Pay Date...
  13. K

    Inverting last name/first name to fuirst name/las name

    Have: Jones, Mary / Jones, Sam (or could be three names) Jones, Mary / Jones, Sam / Jones, Tom Need: Mary Jones; Sam Jones (or all three names if case may be)
  14. B

    SUMIFS Between Date Range

    Probably a repeat question but i just cant figure this out. Im trying to sum the number of times a persons name appears in a range on my "classes" sheet if the date in column A is between a range of dates in my "passes" sheet. Apologies for the terrible formatting of my tables im not familiar...
  15. L

    lookup multiple column

    Hi Can I do multiple column Vlookup. I searched the internet but most of examples are using Match-Index. I want to learn multiple Vlookup first then I will go to match-index. I am thinking of array function but do not know how to start I have the table below. I want to do the following Enter...
  16. L

    fill empty cells from above cells

    Hi I have blank cells in the sheet below (please see the link). To fill these blank cells, I want to copy the content of the cells above. In the original sheet, I just highlighted the first few cells with yellow for you. Thank you very much Example <tbody> contract key name location date...
  17. H

    transpose data query

    i have been working on an efficient way to get this excel data to transpose in the way that appears underneath it, at the bottom of the post the way i do involves several steps and its painfully slow, and the data set can be large, and as i need to do it 3 times a week, I'm hoping for a faster...
  18. M

    Is there a way to paste a string value into a cells in a single column, a certain number of words after?

    Sorry for the confusing title, perhaps an example better explains what I am trying to do. If I have a list of cells that contain sentences such as : A1 Mary Jane listening to music A2 Peter Parker doing homework A3 Eddie Brock eating pizza and I would like to add a word after their names...
  19. L

    vlookup + formatting

    Hi I wrote vlookup function + match function to return the value if a user enter name and month A1= please enter name A2= Please enter month A3= vlookup (?,?:?,match(?,?,exact),false) Everything is fine, if user enter Mary and month is Feb then the vllookup will return 22. My question, how...
  20. CyrusTheVirus

    I'll admit it... I'm stumped!! Need hierarchy help.

    This is the first time in my professional career that I am unable to figure out how to use features/formulas (i've never needed VBA, until maybe now) in order to solve a problem. Basically i need to create a certain formatted hierarchical structure based on the below table. I need each...

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