Search results

oooopsie dooopsie, my apologies the correct is: Fri 17 to Thu 23

Hi Sajan You have hit the right note. Data is exactly in the format that you have mentioned i.e. Jan 17 to Feb 23 but entered in Cell A1 Thanks bs

unfortunately, the data that I have received is in this format; it should'nt be like this but if there is no answer then I guess I will have to change the entire date and break dates in 2 columns to make it work

Hi I have a rather weird question. NETWORKDAYS formula can work for calculating difference of working days provided in e.g. Cell A1 is the start date and in Cell A2 is the end date. What if I write the following in Cell A1 (pertaining to Year 2014): "Monday 6 to Friday 10 January", or...

Hi SirJB7 Apologies being so late in coming back. Being bogged down in other projects; just saw your solution. At a glance, it looks like this is it. Will work on this tomorrow and come back to you. Many thanks again. Regards T

Dear Hui Reading this now, meanwhile, could you please confirm that following is not possible: "Can VLook be used in this situation where One name appears at 2 different rows and I want the corresponding values to be extracted." Because Vlook will stop at first row where Sam appeared and...

Requirement: Want to extract, date-wise, all working location (corresponding values) e.g. of Sam, who appears at 2 different rows, onto a separate sheet or may be same sheet but in blank columns e.g. K onwards. Tried to use Vlook but it stopped at Sam at row 3 and did not look for Sam at Row 8...

Dear Hui Bit silly question: What do I do in the event I need to add another subject e.g. Business Studies as a stand alone and / or in combination with other subject? Regards T

Dear Hui One more question: In the actual worksheet, the data is in tables form imported via MS Query, and there are about 6 tables imported from 6 different sources; all compiled into one. I am sure, this solution, with appropriate modifications, will work collectively and give me results of...

Dear Hui Downloaded the spreadsheet,it makes sense. Another question: I am sure this will work, albeit with some modification, if for some reason, there are more than 2 subjects mentioned in one cell e.g. Eng/Accts/Pshycho and so on. Now the big question? Would you be able to point me...

Dear Hui I will try working on this and let you know tomorrow. I will try to create a macro for this to automate. maaaaaaaaany thanks Regards

Dear Hui here is the link for sample file: https://www.dropbox.com/s/12q8vjeze04399m/Calculations.xlsx I was reading your other solutions in other forums; I know you will have solution to this. Many thanks again you guys rock regards

Hi there, I have rather complex problem (well complex for me though). I have say 3 students Chris, Sam and Matt. Each attending different set of classes each day over one week period. e.g. on Monday Maths/English, Maths/Accounts, Physics/Accounts, Lab/Chemistry Tuesday Lab/Chem...