simon

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

Hi Could really do with some assistance on this one ...svp Table below . . . to achieve 16000 in A3 I've calc'd as follows; =$B3*((D3*E3)+(F3*G3)+(H3*I3)+(J3*K3)+(L3*M3)) ... this works but is 'long-hand' and doesn't address the rate changes in columns B & C. Does anyone know a way of using...

Hi, Apologies if this has been covered.. I can find various posts on Sumproduct but can't quite get my head around what I need to do to get this to work. Please can someone help me with the final part of the formula? My table is below. This is a mock up that I can then expand across my...

Hello All, I have been using command prompt copy *.csv combined.csv However it has started failing for me on 1/2 the files. (trying to combine 365 files) Does anyone know another way to combine multiple .csv files quickly Regards, Simon

Hi I have searched high and low for this solution... If I have 4 sheets in a workbook, named Summary, Anne, Jay, Simon. I am looking for Anne to view only her sheet, Simon to view only his sheet, and Jay to view all.... (Their names could be in cell A1 of each of their sheets). How would I do...

Hi All, I couldn't find a specific match to this query but I'm assuming it's been asked before - please help or point me to the correct solution :) Thanks. Example: Sheet 1 Cell A1 - Text (basically it a description of a product) Sheet 1 Cell B1 - I will place my formula (this will then be...

Hi, I'm new to VBA and I know that this might be a big question, but here you go. I have a sheet with data that look a bit like this and the columns continues with the next date: <tbody> A1 B1 C1 D1 E1 F1 G1 Name Info1 Info2 Info3 Info4 12-09-2017 13-09-2017 .... Simon XX XX XX XX 1 2...

Hi folks, I'm hoping someone might have a formula for this use case. I have a sheet containing a column of data values. the values are like this: Updated_New_Customer_DE 2016_w32_1_Sunday_ladies [example] I would like to use a formula to extract the value either after the last underscore_ or...

Hello Could anyone tell me how I go about determining in Excel 2010 if a person named in Col A has any one of the Category Columns checked. I don't need to know if they've got more than one ie Mick has three checked. That's not important to what Im trying to achieve. I'm thinking its some kind...