brown

Hi all I have a column of data with Users names and a column of User IDs - the ID is to anonymise and not have the ability to trace an individual. So for example - 3 entries for John Smith; 1 entry for Jane Doe; 5 entries for Sam Brown.... so the 3 John Smith entries will have the same user...

Hello, Need your quick help. I'm trying to write a formula where from a group I can find if it has a text (specific/partial). "Has Black?" is the result I want. <colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody> Animal Color Animal Has Black? dog...

Hi all, I have workbook Main.xlsx with 03 sheets(main, sum_A1, copytolastrow_A2). Please help me create 02 macro brown to folder to do: 01 macro sum from multiple wb and 01 macro copy from multiple wb that: 1. Macro SUM: Brown to special and sum all file .xl* - sheet(A1) - range(A5:E6) to...

I have the following VBA Code Snippet and I've trying to learn how to use the Cells object. How would I replace the Activecell object with the Cells object in the Do Loop? In this instance, the Active cell would be Cells(2,2). What confuses me is how to replace the activecell object with...

Hello VBAers, I have a list of data where I need to enter a blank row under the row of where a certain value appears in a column. <tbody> Dog Brown Charlie Cat Jack Dog Brown Princess </tbody> In the above example, every time Brown appears, I would like to enter an empty row beneath...

I have a field that is a string but at the end has (2) or other number. The string lengths vary. I need the integer as it's own field. ie The brown rabbit (3) The blue ox (10) new field 3 10 thanks

Hi Everyone, I need help in excel. Please find below for example: <tbody> A B C D 1 Vikas Agarwal John Monty 2 Parul sharma Brown Peter Chris 3 4 </tbody> i want to take all words mentioned before John/Peter. so my B1 should be Vikas Agarwal and B2 should be Parul...

Hello...My name is Robert, and I am trying to discover a way for me to merge multiple CSV files into a single Excel worksheet? I don't want the merged files to appear as tabs on the bottom of the new worksheet. I simply want the data for each file to be stacked on top of each other. For example...

I have a series of Columns containing employee names from my company directory. Column A is the Requestor of the respective row's project (several more columns containing project info). Columns B-D contain the next three managers in the org chart. <tbody> Requestor Manager Manager's Manager...

Hello all, I am trying to find a formula to add up how many hours an employee worked in each work week. There is lots of data on my sheet, but below are the columns that I believe will be pulled from. I'm fine with adding a helper column (shown in my example as the "total hours per week"...

Hello Folks, In My Work Book I have: James Brown Han Solo Luke Skywalker I need a formula that will make it : Brown, James Solo, Han Skywalker, Luke Your thought please and Thank you in advance

Hi all I currently have some code that copies and pastes rows, a variable number of times dependant on data in Supervisor Name field, to a new sheet. What I am looking for is a way of adding a cell prior to the pasted data, populated with 'Call 1, Call 2 etc. which references the number of...

I wonder if any of you can help me. I have a large amount of data taking up over 1000 rows. The data is for entrants results across 4 events (columns C, D, E and F). Sometimes an entrant will take part in 2 or more of the events. Each event they take part in is shown in a separate row. What I...

Hello everyone, I am trying to get a VBA code that will highlight duplicates found across 13 columns of data, possibly 100+ rows of data. So I'm looking for duplicated rows across those 13 columns. See below: <tbody> Name DOB Address Phone Etc Etc Etc Etc Etc Etc Etc Etc Etc John Brown...

I'm wanting to concatenate some rows dependent upon if they are a different value. So in column C i want to say =IF(D2="Variable",concatenate(c3,c4),c2) So i need the formula to check if parent sku is the same as the child sku, then if it does, then concatenate both of them skus together, and...

I'm attempting to do a lookup from data organised like: <tbody> Name 7755 7756 7757 Hill 100.00 25.00 98.00 Smith 10.26 896.57 3215.14 Black 18.76 12.00 47.86 Hill 56.98 25.47 33.59 Brown 1254.26 8569.24 4529.10 Hill 5869.25 5689.24 1.56 </tbody> In my lookup sheet I have the...

Given the following <tbody> Andy Bob Jeff Blue x Black x Purple x Green x Yellow x Red x Brown x Orange x </tbody> How can I get the output to be (or can I): <tbody> Andy Bob Jeff Blue Black Purple Green Yellow Red Brown Orange </tbody> I am...

Hello I'm having trouble with a spreadsheet I have created. When I turn on the filter I can't get the information to display as I want. Please see example layout below. <tbody> A B Committee 1 Joe Smith Jane Brown Committee 2 Alex Davies Heather Nimmo Committee 3 Tom Munro Jake...

Hello guys, so i have this problem in excel where I need a fomula to sort words separated by commas and code(in this case its coded as 1) them individually in each field. brown, fox, is, lousy, fox, fox, is, bad, fox -- sample word. this is stored in a single field so as I separate them...