david

Good day Have not posted here in ages but have a small problem In the sheet below there are for example five students who have arrived either "Late" or "On Time" for classes over a period of three days How do I calculate the percentage for each student of being "On Time" for the three days...

I have a table with several columns. The first is a name and the second is a date. For each name there are several dates. The dates should be sequential. If there is a gap of one or more days, I would like to add a line with the name and the missing date. <tbody> david 3/5/19 david 3/6/19...

Hi team, like below format, i do have lot number of records. I want formula to calculate unique count, on every date from which department.. can anyone suggest on this.. ---- User count

I have two columns of data A and B. In column A i have duplicate values and in B 2 type of names (david and george). I would like to count the sum of umique values in colum A for David and then for George. This is what i have so far. =sum(1/(countif(a2:a200,a2:a200) This one sums the unique...

i have created an excel table with imported data from a SQL server. the data being imported in a single column is the users Domain\UID. Columns B, C, D, etc are used to MANUALLY enter application user ID's (mainframe, etc). today a new hire was added to the SQL table and was successfully...

Hi I have an excel query and i can not figure it out: I have a list of names in column A and Dates along in Row 1. And under the dates by the names are zeros or BH (Bank Holiday), W (worked), H (Hol) & HF (Half Day Hol) I am trying to get results by looking at the name i want to know when...

Hello I require a 'static' function for 'choose,randbetween(1,6),0,0,1,1,2,3)? Thank you in anticipation David Wale

Hi everyone I have a problem filtering out certain rows and wonder if someone could please help me. The table below represents my spreadsheet. I have carried out an EXACT function to find cells underneath each other that are the same (e.g. David & David and Philip & Philip in ColumnB). This is...

Hi, I have a worksheet called Sheet1 On sheet1 is a Combobox1 which will have the names inside. These names are on a worksheet called TYPE and cells A1:A5 I would like the user to select a name then depending on the selection put a letter in cell P7 Here is the names & letter assigned to that...

You guys have helped me a couple of times recently. I hugely appreciate it but I'm stuck again. Apologies. So P2 is John and S2 is David in the next cells along there is a figure so Q2 is 4.5 and T2 is -4.5, I need a formula to look at the values in Q2 and T2 and know that T2 is the lowest...

Hi all, I am hoping that the following is possible to be done with vba code. I have searched but am struggling to find code to cover all of this. I have broken this down into 3 separate stages below. I have a set of data in an excel spreadsheet that runs from column A to Column K and 6000...

I have Column A "Fist Name" and Column B "Last Name". For example <tbody> FIRST NAME LAST NAME Arpil & Pat Abernathy Pat Abernathy David Ackary David Ackary Karen Smith Bob Barker Ellen Barker Jack Smith David Brady </tbody> I want to highlight or indicate in a 3rd column...

Hi, Apologies if this has already been asked, have searched but nothing found. What I would like to do is; from excel (2016) have the ability via vba to save an email (no email attachment involved) into a worksheet. There will be many email attachments going into the excel workbook so the...

Hi I used the formula below in trying to solve a puzzle I have, and it has got really close to what I need. It presented the results in col 1 and 2 below (C and D in your formula). However, What I need is to get the results separately i.e. Results for "7" in one cell in the spreadsheet and...

Hi, we have to collate reports from different departments. And I've been asked if we can help sort out (an evergrowing!) snag. There is a list of info <tbody> Customer Name Orders PETER SMITH ABC123 david jones 5962-99-3 peter smith XYZ789 222246 Green Bottles David Jones David...

Dear Friend How to edit code VBA for the VBA Vlookup another sheet please see table and ad visor:eeek: Thank you lotto Beginner VBA Sheet1 <tbody> item Detail Age School name Mother Country parent 1 david 17 T 2 job 12 G 3 steep 13 H 4 art 15 I </tbody> Sheet2...

Hi I need a little help. I need to compare the value in Sheet1.Col-E with Sheet2.Col-F if they're equal then copy value from Sheet1.Col-A to Sheet2.Col-E. Thanks for any help David

I have a table that looks like this: <tbody> Teacher Class Mark Smith English Mark Smith Math David Park Science David Park History </tbody> I currently have a VBA solution (at the bottom) that combines teachers to one row, and lists their classes in the next, separated by commas...

I have one combo box and a buttom I have this table in excel date name goods name Qty 21-1-2018 David Pen 12 22-1-2018 Peter pencil 14 10-2-2018 David paper...

Hi, Im trying to count all the people in on total people column and then trying to count them again but using there ID. But if it comes up twice to count it as 1 in a date range. Im using a Raw data download of about 4000 records and trying to stay away from an array formula that does work...