Search results

Hi, Clare Cameron! Welcome to Chandoo forums! Checked this yet? http://chandoo.org/forum/forums/new-users-please-start-here.14/ About your question,consider uploading a sample file. It'd be easier to understand for people who might be able to help you. Include indication of the input data, the...

Hi, emmatm! Absolutely not. I won't ever forgive you. Unless we're talking about three six-pack of Carlsberg! :DD I was just joking, I apologize for my non-native English if it makes me sound a bit different from my intention. It won't happen again... Regards! PS: ... until next time.

Hi, Kathhybug1964! Glad you solved it. Thanks for your feedback and welcome back whenever needed or wanted. Regards! PS: Remember that in Spanish "h" is mute :DD

Hi, shazzad! Welcome to Chandoo forums! Checked this yet? http://chandoo.org/forum/forums/new-users-please-start-here.14/ Regards!

Hi, Eloise T! Giving up. Good luck. Regards!

Hi, Eloise T! You'r missing the most important module, SIX! Regards!

Hi, Eloise T! In the other project/situation I didn't know a priori what type of data other than dates would contain the related column, so I went for a schema on a cell-by-cell basis. Actually I don't know why I did it in such way. o_O In this case, if column E doesn't contain any other type...

Hi, emmatm! If we weren't in a writing platform I would say "Before speaking I would like to say a few words" and they are: I highly appreciate your gesture, I'm sure Marc L will join me, but it's not necessary, thanks a lot, indeed it'll be a bit difficult as I'm from the Southern Cone...

Hi, mithil! Give a look at the uploaded file. There you'll find a working model with all the posted formulas. Regards!

Hi, Hardeep! So long... almost 4 years. I'm wondering if I should add a close date for old code... hahaha! Glad it still works, for the original intended use. Let me check it tomorrow. Regards!

Hi, emmatm! As a sign of goodwill here's the updated code and uploaded file. Option Explicit Sub DifferenceBetweenEngineersAndArchitects() ' ' constants Const ksWSSource = ",Projects,Small Works,Tech & Crate,Tech Only" Const ksWSTarget = ",All,Scheduled,Completed,Progress"...

Hi, Eloise T! What about this? Trying on another machine with same OS and same Excel version. Regards!

Hi, Eloise T! Posted on Nov 21st, 2016. :mad::confused::p:eek::oops::rolleyes:o_O Regards!

Hi, Marc L! Pourquoi pas, mon ami? (Why not, my friend?) Be my guest... But I think we'll have to wait & see what does emmatm says... I kept on wondering about a counter proposal... ;) But if you check the code you'll see that you'd be in disadvantage if you settle only for that... Regards!

Hi, mithil1! I think that if you do that you won't be retrieving the exact decimal part since not all months have 30 days. Instead of that you can do this, assuming that starting date is in A1 and ending date in B1: a) separate cells C1: no. of entire months...

Hi, khal! Does this help? https://www.mrexcel.com/forum/excel-questions/152116-apostrophe-concatenation.html Regards!

Hi, Andrew Quirl! Please be patient, I recommend you to read this, if you haven't done it yet, which seems you haven't... http://chandoo.org/forum/threads/new-users-please-read.294/ Where you may find this: "Please Don't PLEASE DON'T SHOUT! We have big ears and will hear you just the same. "...

Hi, Faruk Hosen! Does this help? https://superuser.com/questions/928536/how-do-you-format-numbers-in-excel-for-indian-currency-rupees Regards!

Hi, AAP! Checked this? https://msdn.microsoft.com/en-us/library/office/bb687891.aspx Give CTRL+ALT+F9 a try. Regards!

Hi, neeraj2050! Consider uploading a sample file. It'd be easier to understand for people who might be able to help you. Include indication of the input data, the attempted solution (formulas, code) and the manually written expected output data as example. Thanks. Regards!

Hi, mithil1! In a very old thread, rescued from the bottom of hell, I wrote about this better-avoidable function. http://chandoo.org/forum/threads/datedif-function-not-available-in-excel-2010.12307/#post-72251 Check the link with OP Nitika.Kaul for further information. Regards!

Hi, emmatm! Maybe redundant but... same file or date & time stamped as for now? Check this: http://chandoo.org/forum/members/sirjb7.1781/ Information tab, quote from that guy Albert. Rude & awkard? Nothing farthest from my thoughts... (unless 'til I get any proposal which I've never...

Hi, paulcherianc! Instead of merged cells use Center In Selection. Regards!

Hi, mohan08! If you didn't do it yet I strongly suggest you to use the built-in macro recorder (Programmer tab, Record Macro button), perform all the actions that you describe, stop recording, and then analyze the created code. Regards!

Hi, emmatm! File updated and uploaded again. This is the adjusted VBA code: Option Explicit Sub DifferenceBetweenEngineersAndArchitects() ' ' constants Const ksWSSource = ",Projects,Small Works,Tech & Crate,Tech Only" Const ksWSTarget = ",All,Scheduled,Completed,Progress"...