joe

I am trying to get a count of unique identifiers based on variables from two different columns. In addition, in one of those columns, I need to add multiple additional criteria. For example: Column A Column B Column C NJ Joe...

Hello all good afternoon, i have a query and no idea how to do it, should It be done via vba code or formula? I have a userform and a sheet1, and sheet 1 has columns A - K with data in, column A has a name for example joe blogs and Joe could be on numberous lines as this info will be his work...

<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 this predicament... I have several excel files with some similar information, but not the same. I get edited copies of these files every week. There is no way that the people sending me these files will ever change how the files are formatted so I have to take all four files and create a...

Hi all, I am looking to do a mail shot from a publication but need some assistance in sorting the data from a pdf. The data comes in the following format: OK1234567 R The food company Ltd Director(s) Mr Joe Blogs, Mrs Joe Blogs Unt A, Some Road, Some town, Some county, Some post code...

Hello- Thanks in advance for any assistance. Looking to have a column in excel which calculates the number of times a name appears weekly in a data set over time and assigns an integer to the name. The "Occurrence" column would auto populate the above target value. I was using '=...

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

Hi there, I have data that when i vlookup it only picks up the first value. What is the best way of being able to find the corresponding value in a different column if the criteria matches? For example, i want to be able to find what all the Type 2 bookings are for the individuals. What...

I am trying to look at my employee time sheets broken down by date, time, and who was on at the time. My time sheet software give me their clock in and clock out time. I've used MROUND to get the closest hour, now I'm struggling to put those names in the correct time slots. This is the data I've...

Hi all, I have a chart Column A with bunch of names, and i want to highlight all the duplicated names, in different colors. Below example, I want to highlight Ben maybe in red and John in Green and Joe in Blue (random colors) Is it possible? using Excel 2010 Column A Ben Ben John Carlie Troy...

Hi I have a staff planning tool which I have created in excel Database. Is fed from a data input sheet, and houses formulas to work out lots of variables. Sheet 2 is a list Column A - Employee Name Column B - Inclusive Holiday Date From Column C - Inclusive Holiday Date To The...

<tbody> A B C D E F Name Store # Number of Visits Name Count of Visits Joe 1542 3 Joe 3 Joe 1872 4 Brad 2 Joe 1932 3 Sarah 3 Brad 5323 2 Brad 2142 3 Sarah 6745 0 Sarah 0896 2 Sarah 3242 3 Sarah 5735...

Administration wants to list the actual dates each employee took off during the year. However, the recording system lists only the first date and the number of total vacation hours. So I need to get from <tbody> Joe Blow 9/6/17 75 </tbody> to <tbody> Joe Blow 9/6/17 9/7/17 9/8/17...

Hi All, I'm not an excel expert and I have limited knowledge. I have two sheets of data. The first sheet of Data looks like this <tbody> Name CallIN Abandoned Outbound Joe 30 3 25 Joe 20 7 12 Joe 15 2 2 Ben 3 17 0 Ben 8 2 15 Mo 12 15 7 </tbody> On another sheet I...

Hello, I been whacking my brain on this little problem for a few days now and about to cry So i have 2 tables Table1 <tbody> Month Name Hours 1 Joe 3 1 Jack 4 2 Joe 5 2 Bob 3 2 Nancy 6 3 Jack 4 </tbody> Table2 <tbody> Name Jan Feb March Joe x Jack Bob Nancy...

Hello, Need help with a formula that will find the first two blank cells in D column and then return back a start time and end. I been wracking my brain for a few weeks but still doesn't turn out right. My time system for night employees will add their lunch break return to the next day if they...

Hi Guys, I am trying to seperate first names from the last name. I am able to do it for the single first and last names, but when i have multiple firsts i am not able to do so... see below example; Joe Blow =LEFT(E4,FIND(" ",E4,1)) - returns Joe But when i have Joe & Jane Blow it only...

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

Hello all. I needs some guidance. I'm trying to create a formula that will look at a range of data and based on the words "closed" and "open" it will perform a cut paste to another tab. Example: A1 B1 C1 D1 E1 Joe Dirt Dodge...

I have a list of classes, teachers, and periods. I need to sum the periods for each teacher when their name is typed in. The problem is that the data is not arranged in a 3x2 grid. eg Math 8 3 Joe Math 9 4 Joe Math 10 5 Sam Eng8 4 Lucy Eng 9...