dave

I have a data set that looks like this: <colgroup><col width="64" style="width:48pt" span="2"> </colgroup><tbody> Col1 Col2 a sam b sam c sam d sam e sam f sam g sam a bill b bill d bill g bill h...

Hi, Can I have some help. I want to create a list of unique names based on their lowest score e.g. Surname forename Score score Smith Dave French 3 Smith Dave French 1 Holland Fred Science 2 Holland Fred...

I have the following query and cannot for the life of me get any kind of nested formula to work. What I require is it to look at cell A1 in Sheet 2 and in Sheet 1 look for that cell in Column A (which appears more than once), but then look at Column B for a zero and then take the value from...

Hi there, Need a little help if anyone can please. One column holds data of names of staff who try to make appointments, for this instance "Dave" "John" and "Trevor" Another column holds a list of appointments made set to a simple "Yes" or "No" A 3rd column lists a value of sales that result...

i currently have a search box set up that works, i type in a persons name and then a search box appears under the typed selection with all the possible names it could be. However what i would like to do is now - is when typing in i would like to search i want more than one column to appear in...

<tbody> Game Win Draw1 Draw2 Loss Win Goals Draw1 Goals Draw2 Goals Loss Goals 1 Calum Steve 3 3 1 Owen James 1 0 1 Jim Victoria 2 1 1 Peter 0 1 1 1 2 Calum Dan 4 5 2 James Steve 4 5 2 Phil Tom P 1 1 2 Tom G Dave 2 0...

<tbody> Name Week 1 Week 2 Week 3 Dave y Phil y Julie y Barry y Michael y Karen y Holli y Nick y y Kate y </tbody> Hi, I have a master excel sheet like the one above. I'm trying to populate a series of other sheets with the names of...

I am creating a recording log and would like to add the various recording times - i.e. 16 tracks of various times such as 1:35 and 2:46 and 1:22, etc. When I of course add up sixteen various times they do not total properly. Thanks - Dave, The Olive Oil Guy

This is probably very straightforward but its doing my head in, can someone help I have a worksheet which has two columns one with Names the other with value, all i need is a formula in column 3 that will return for each individual "lowest" for the lowest value attributed to that person and...

I have a column with usually numeric digits and then a name of a person. I.e C11883 Dave Smith C11 Dave Jones D11111 William Brian Johnson I wish to create a new column removing the first word to give the results Dave Smith Dave Jones William Brian Johnson I have used the MiD...

<colgroup><col width="64" style="width: 48pt;" span="2"> <col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;" span="2"> <col width="64" style="width: 48pt;"> <col width="93" style="width: 70pt; mso-width-source: userset; mso-width-alt: 3401;" span="7"> <tbody>...

Hi everyone, My VLOOKUP seems to be pulling the wrong information. =VLOOKUP(AE1,'Study Database'!B9:AN6000,9) Where; AE1 = Dave I was expecting the lookup to find Dave in the database which covers B9:AN6000 and pull the information on row 9 from the line which has Dave's information. Instead...

I have the below code embedded within my sheet. my need is to repeat the same type of process but with several different targets like (C4), and have a different MsgBox for each cell and. Not sure if this is still sheet code or macros? Also, this code was given to me and the LCase is not...

Hi, That title is probably not clear.... sorry in advance. I hope this will clear it up. I have Column B with 30 rows of Data and a Unique ID in Column "C" yes for example. This column is shorter in length than on Sheet 2 and contains a unique identifier in column 2. Sheet 1 Column B...

Hi Everyone, I have a list of sales going back to 1st jan 2017 I'm want to have a macro tell me the staus of that client according to what has happened up until that row, so for example, all cilents are listed down Column C, All Dates are listed down column G the sheet is in date order old...

Hi Guys, Is there a way to do the following. I basically want to Use the first name from Column C (Name) and populate Column D (Name 2) if the ref in column A is identical to the cell above or below and if column B shows yes. I hope this makes sense. So the formula in column D would look like...

Morning all, Another little piece of help required please, this time regarding dates/times that overlap. Example Data: I need to calculate the number of days overlapping within the data for each unique Name. <tbody> Name (A) Start (B) End (C) Dave 08/02/2018 09:00 08/02/2018...

Hi All, I’ve have a simple function I want to create on my spreadsheet but I’m finding it difficult to achieve it. I want to select a name from a drop down menu and dependant on the name select I want to populate data in a static column. I have created the drop down menu for example: John...

I want to put a value in one cell and have it display all rows from a different sheet that contains that value. for example if i have one data sheet and i type in "dave" it will search that entire sheet and display all rows associated with the word "dave"

Good Evening, I have a export file for work that will export employee shifts by job code. In column A of the file there will be ~ 500 rows. I think what I am trying to achieve can be best explained as: I will have repeating values in column A (employee name like Dave, Tom etc etc.) It is...