Search results

Hi, Slimline! You're looking at row 1 of dWS worksheet and your data is at row 5. Regards!

Hi, Derek B! Thanks for the introduction, very impressive. Would you mind posting it here: http://chandoo.org/forum/threads/hello-introduce-yourself.20/page-63 so all Chandoo community may find it easily? Thank you very much. Regarding the .xlam issue, a few questions: a) What Windows version...

Hi, Derek B! Welcome to Chandoo forums! Checked this yet? http://chandoo.org/forum/forums/new-users-please-start-here.14/ About your question, I'm running a computer with Excel 2010 x86 (32 bits) with FUNCRES.XLAM enabled under Win 7 x64 and I've never experienced such issue. Tried disabling...

Hi, sms2luv! Moving 100 Mb by VBA code, either reading or writing a remote file from VBA, let us say "ABC...abc...012...", a 100 bytes string char written a million times, then reading it. Regards!

@shrivallabha Hi, buddy! I forgot to tell you about don't posting code at threads of this OP (@Eloise T) since she's playing as Dr. Frankenstein, building a sort of monster from a many snippets all joined by screws & nuts. I'm afraid is very late for you :( Regards! Hi, Eloise T! How're you...

Hi, Eloise T! And with shrivallabha's code? I was referring to it. Regards!

HI, Slimline! No, I didn't check any value first. Now it runs without crashing but still wrongly. The problem seems to be in this line: If Cells(1, iSource) = Cells(1, jDest).Value Then You're comparing cells from same implicit object (i.e., not qualified by range or worksheet) so it...

Hi, sms2luv! Run a home-made benchmark transferring via VBA let us say, 100 Mb or so, using this methods: 1) TeamViewer 2) VPN (I'd go for Turbo VPN, Hello, or Touch VPN) 3) Critrix Receiver If still unsatisfied with all of them, then go for a 2 in 1 tablet-notebook running Win10. Regards!

Hi, bosco_yip! You're right, thanks for the catch. Hi, mithil1! Try this, it'll work with any number of years: =IZQUIERDA(A1;HALLAR(" ";A1))&(-IZQUIERDA(A1;HALLAR(" ";A1))-1) -----> in English: =LEFT(A1,SEARCH(" ",A1))&(-LEFT(A1,SEARCH(" ",A1))-1) Regards!

Hi, mithil1! Another option: same as above but not "0+" required. B2: =IZQUIERDA(A1;1)&(-IZQUIERDA(A1;1)-1) -----> in English: =LEFT(A1,1)&(-LEFT(A1,1)-1) And a question: 2 Yr 0 Mo should display 2-3 or 1-2? Regards!

Hi, sms2luv! If you keep a machine on at your home/office then you can access via TeamViewer to it from everywhere using Android/iOS devices. Regards!

Hi, Slimline! Your uploaded files have a quite different version of my uploaded code, which I think it works fine. More indeed your code doesn't work, it displays a subscript out of range at line: Set DestWB = Workbooks(DestWBname) where variable DestWBname has the value "Central". Please get...

Hi, MonioDee! Opened your uploaded file without any issue. If you're wondering about the difference between sizes of .xlsm and .xlsb, don't worry about it, .xslb format files are lighter than .xlsm while keeping the same features. Regards!

Hi, Eloise T! I't stick to shrivallabha's code, it's the simplest and should have no issues. Tried it yet? Regards!

Hi, YasserKhalil! Thanks for your kind works, feel free to ask anything about it. OP didn't even answer my question at post #7 so I tried to be as literal as possible. I thought about it but freezing values at certain date should include that date in "the calculator" at least. Regards!

Hi, Slimline! A) J is the index used to search for an exact column match, K is the max column, J<=K means column found. Problem: consider uploading a sample file. Regards!

Hi, Brad Rego! Give a look at the uploaded file. This is the VBA code: Option Explicit Sub AllTogetherKeepThemSeparated() ' ' constants Const ksWSSource = "Source Data" Const ksSource = "SourceDataTable" Const ksWSCalc = "Calculator" Const ksCalc = "CalculatorTable"...

Hi, Brad Rego! Just in case they're repeated (otherwise it'd be a trivial situation), give a look at the uploaded file. Formulas for 3rd worksheet are: A2: =SI.ERROR(INDICE('Source Data'!A$2:A$13;COINCIDIR(0;CONTAR.SI(A$1:A1;'Source Data'!A$2:A$13);0));"") -----> in English...

Hi, Brad Rego! Names in worksheet Source Data at column A, are unique or repeated? Regards!

Hi, sms2luv! I'd bet on Excel working on a different unveiled way. And unknown for me. Regards!

Hi, PaulFogel123! I'm afraid I don't understand to which "= formula" are you referring to. Could you please elaborate? Thank you. Regards!

Hi, Rodrigues! Does this help? http://bfy.tw/D9Uy Regards!

Hi, gregorii77! Nothing to apologize for, I'm trying to find out if it's a Windows setup isseu. In your desktop, go to Start, Control Panel, Clock Language & Region, Regional & Language Configuration, Change Date Hour or Number Format., Additional Configuration. There check at Decimal Symbol if...

Hi, gregorii77! Which regional settings are you using? In F13 I have a value of 1500, one thousand and a half, that I see as 1,500 formatted. This will never satisfy 1 of the 3 conditions of the AND(), since it says "F13<1,5". Regards!

Hi, emmatm! Late advice, already got my hands dirty on it. Regards!