mary

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

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

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

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

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

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

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

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

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

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

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

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

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)

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

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

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

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

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

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

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