jones

Been trying to figure this out for a while and nothing seems to be working. I am trying to create a holiday tracker that counts weekdays in a week by week from a too and from date. The set up is as follows <tbody> Name Start Date End Date 16th Apr 23rd Apr 30th April John Smith 16th Apr 18...

I have a data table of dates, first names, surnames and salary. I need to be able to lookup the salary on or before a given date. I need to do this multiple times so do not want to use the Control Shift Enter array construct. Any suggestions for a single line formula that can deal with the data...

I have list of full names. some names have first name only, and some have first and middle name. I would like to use a formula that will extract the last name from all of them. I know that flash fill could do it but I need a formula because the list is always updating. For example Name...

Would anyone know how to return only the first several digits of a vlookup value? I'm trying to save space by shrinking the columns and only having a portion of the lookup value. For example, my source data shows the table below. I would like to just pull in "Jones, Indiana". I've tried...

Hi All, I have a spreadsheet that contains peoples names in a column and different values associated to the person in another column e.g. Wright 1.5 Wright 3 Wright 4.2 Wright 7 Jones 4.6 Jones 2.1 Wilson 9 Wilson 6.7 Wilson 1 Wilson 3.2 Wilson 5 I want to be able to...

I'm in need of some assistance with a task I'm trying to complete. I have a sheet called "Client Summary", where I'm trying to pull in data from several other sheets where the "Client ID" matches on each sheet. Depending upon the sheet I'm hitting, it could be a 1:1 or 1:many search. Here are...

I have a vertical list consisting bunch of names. I'm looking for a way to find the second and third matches of a cell value prepended with a space. I'm using =VLOOKUP("*"&" " &B2&"*",A:A,1,FALSE) for the match1 below, which is working fine, but I couldn't figure out a way to automatically...

This is a stumper - hoping someone has an idea. I need to calculate average hours worked by an employee in a quarter so I have all of the hours separated by each week in columns. I don't want to penalize new hires for the zero hours in the columns prior to when they were hired. But I do want...

I am using MSExcel 2016 I have a list of names (around 400+) in one column. The name consists of a Prefix1 / Prefix 2 / first name / last name / civil honour 1 / civil honour 2 / civil honour 3. Some of the last names are hyphenated. I am looking to delimit this text into separate columns...

I am trying to create a dashboard that shows employee evaluation information in a chart with four quadrants. I am trying to figure out how to get the employee name to populate in the correct quadrant based on the evaluation score for that quarter. I would eventually like to slice the data so I...

Hi, I want to be able to extract/copy data from columns H (2017-18), M (First Name), & N (Last Name) from a worksheet called AllMembers based on Criteria Life Members and Financial only from column L (M'ship Type) and copy this data to another sheet called MemberSignIn in columns B (Last...

I have a column in a spreadsheet that contains data in the following format: Smith (Jones) I would like to quickly remove the " (Jones)" from each entry so only the "Smith" is left. Is there a way to do that using "Find and Replace"? Tony

Hi Community! - I am needing some help trying to configure a macro/vba to trigger which email address to send to based on user selection from a Cell based dropdown list. Below is my code. I can't figure out where I am going wrong.. Essentially the macro should work as follows: If...

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