sarah

Hi, Suppose I have a list as per below :- <tbody> A B C D E Graham 1 12 5 12 Simon 1 32 4 332 Richard 4 43 6 23 Brendan 6 12 34 45 Sarah 8 45 77 33 Stephen 5 32 43 45 Taylor 3 45 23 66 Mark 2 34 56 77 Andrew 9 67 23 88 </tbody> In my actual excel the list is much larger...

<tbody> A B C D 1 Name Number Name Number 2 Alex 15 Sarah 45 3 Eric 20 Steve 33 4 Steve 33 5 Seth 33 6 Sarah 45 7 Erica 50 </tbody> I need to be able to Search Column A, find a Match for column C. Once that Matches, I need to Fill Column D with the same number to the...

Hi, Please can someone help - I think I need some sort of vlookup / match / index solution? Basically what I need to do is fill the yellow column with the relevant data from the orange column. For example: Where it has Sarah Lauder in cell A43, I want to populate cell C43 with the value...

STARTING POINT: <tbody> Name Beginning Change #1 Change #2 Change #3 Ending Bob Sarah </tbody> Data will be manually populated into the "Name" column above. After populating into the name column, my goal is to have the subsequent columns automatically populated based on whether...

Hi I am really stuck with my formula! Any help is much appreciated I have created my countifs statement which is working fine and returning a result of 3 - but i want to take this one step further and do a count only of unique values to show that although there are 3 headcount assigned to tasks...

Hello I have a data table (columns A and B) which I could summariseusing a pivot table but don't want to as I want to perform some further work onthe data in the data table itself. I can sum up the values for each person and can do that incolumn C using a simple SUMIF function but as you can...

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

Hi All - any help with this issue would be greatly appreciated. I have a sheet where I make work assignments (including budgeted hours) to each employee by task by day. There can be multiple assignments and employees on any given day. The sheet outlines all assignments for a year and looks...

I am looking to setup a formula to be able to search multiple columns (4-5) of names and if there are any duplicates to export them to those cells. I am sure that it is easy but formulas I have been using shows the first duplicate and then the same one again in the next cell and if possible I...

hello, i have a serious problem, that by excel i can count how many the students -at this simple example - are duplicate as shown in result column by row , it helped me out in another tasks, is there a way to achieve same result in Access ?! i hope some one help me out <tbody> <tbody>...

Hiya, I'm hoping somebody can help. I want to use conditional formatting in the end column called all courses complete. I want the end column to be red and say no until all 6 courses have been completed. Once I put all 6 dates into each course column I want the end column to turn green and...

Hello, I have single column in Excel with 6 unique values and I want to list all possible unique combinations (combinations of 2, 3, 4, and 5). Example: Column A John Jones Jamy Sarah Mark Mike The output I'm chasing is all possible combinations of 2, 3, 4, and 5. Example: (John, Jones)...

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

hello guys, i wonder is there countif in access query like excel ! i have a table that contains names like <colgroup><col><col></colgroup><tbody> Name Result I want Sarah 1 John 1 Mick 1 Sarah 2 Sarah 3 John 2 </tbody> i need a formula that count like that in result column, is...

Hi all, Hopefully someone can help me with this because it's driving me mad. I have two tables on separate sheets. The first holds a list of cases and who managed the case (and how long it was open, but that one is less relevant for now). The second has a list of staff that appear in the first...