bloggs

Hi All, Wondering if someone could point me in the right direction and help please - I have a workbook that I generate other workbooks from, so from the dataset in the main tab a macro sorts the data and then for each name, generates another tab with all the respective data on. For example...

Hi On Sheet1, I have the following columns of data <tbody> A B C D 1 DATE NUMBER NAME TYPE(S) 2 01/01/2019 123 J Bloggs A,B 3 01/01/2019 456 D Smith A 4 01/01/2019 789 P Jones B,C 5 02/01/2019 123 J Bloggs B 6 02/01/2019 789 P Jones D 7 03/01/2019 456 D Smith A,B,C 8...

Hi MrExcel World, I am trying to concatenate 2 cells, which is easy enough. The problem I am having is that one if one of the cells is blank I don't want to return anything. Example below; Concatenate----------------------First Name----Last Name John...

Hi there, Sorry to bother you but I was wondering if any Excel experts could give some guidance on a VLookup question? I am trying to look-up two combined records. I have a sheet with Entity 1, Entity 2, Entity 3 as columns, then as rows (headers) I have departments (Accounts, HR, Admin). I...

Hi all I know there's been multiple posts on this throughout the past but all with slightly different requirements... I have a list of c.1500 names (some with middle names, some without) and i'm trying to split them out by title, first, middle (if there is one) and surname. I've tried text to...

Hello all, I am hoping someone can help me. There is a report that shows user files being backed upsuccessfully or not. In column D is the success status. If a backup fails it tries again up to 3 timesthat same day for each user. The data issorted by username and in date order. My example...

Hi , I am trying to create a formula column which shows how many days members of staff have worked in a row. A B C Name Date Number of days in a row J Bloggs...

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

Hi All I have a huge data file (1000000 rows) that shows amongst other things: Customer Number, Name, Item and Value. Im wanting to reduce the data set by combining multiple rows that are for the same person and the same item. For example in the table below I would like to combine Joe Bloggs...

<tbody> A B C D E 1 Joe Bloggs 1.2 2 Your Manager Job Level Team Morale My Morale Development 3 Joe Bloggs 1.2 This comment is for Option 1 Just for visual Just for visual 4 Betty Sue 1.2 This comment is a dummy Just for visual 5 Joe Bloggs 1.2 Just...

I have a column of text that contains some text and example of which is below Bloggs Joe, GB Sales:Required;Smith John, GB Sales:Required;Jones Sally, GB ASC:Required;Walker, Alan, GB Sales:Required There could be a number of combinations of the 'GB ?:Required' text and I won;t know what these...

Good morning, brilliant site – so helpful!!! I’ve been asked to see if it may be possible to see if there is some code which could help in us re-organising some informationÂ… We have to collate a report where it takes our main stocklist and cross references it against other part number & their...

I am trying to extract data from a cell(s) that contains surname, first name, middle name. e.g bloggs, john charles I am just after the surname e.g. bloggs The following formula works well for my data. =TRIM(MID(SUBSTITUTE(SUBSTITUTE($H12020,",","")," ",REPT("...

Hi, I've got a list of names in Column A, e.g. Joe Bloggs John M. Bloggs Mary-Ann Bloggs Ruth Sally Bloggs All the names are in different formats (i.e. some just first name and last name, some with a middle initial included, some with double-barrel first names, etc.) I know how to isolate...

I have a rather large dataset (sheet1) that contains names, year and grade Example key dataset fields Name Year Grade Fred bloggs 2000 A1 Mary Smith 2016 A2 john Jones 2017 A1 John Bloggs 2016 A3 Ros bloggs 2000 A3 I can filter / copy the data onto sheet 2 on any of the criteria But I would...

I have 3 columns of data - around 50 rows. Col A is a date (Promotion year) Col B is last name Col C is rank (this is the same for all) Data example 2017 bloggs manager 2017 smith manager 2016 adams manager 2015 bloggs manager 2014 smith manager 2014 adams manager etc Can a formula...

Good morning everyone, I'm struggling with a vlookup today and I can't understand why it isn't working! I have two tabs the first tab looks like this: <tbody> A B C D 01/01/2017 02/01/2017 03/01/2017 From =IFERROR(VLOOKUP(B2,'journey details'!$D$2:$D$4,3),"") To...

i have 4 columns containing data a is employee number example 123132 b is employee name example joe blogs c is a number so example 123132 Joe Bloggs 1.00 213233 Peter Jones 1.00 213167 Sea Young 1.00 heres the challenge if the column c says 3.00 i want this to create in total 2...