Search results

Hi, Eloise T! As Chihiro told you above: A trick for persons with ADHD (aka Attention Deficit Hyperactivity Disorder) is this: a) double all quotes in formula b) embed a) into quotes. Regards!

Hi, Eloise T! - OP: original poster, person who started a thread. - whenever faced with an Excel constant between xl and x1 go for xl of Excel. - what's LEN in that formula? you could use something like: If Len([L3])<>9 then and it works. Regards!

Hi, CarolineGMartin90! 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 or a clean & readable VBA code. It'd be easier to understand for people who might be able to help you...

Hi, shrivallabha! One of the jewels of the crown... old times, good times, time passes by... Thanks for bringing this from the time tunnel. Regards!

Hi, Chirag R Raval! This thread only goes by post #10. Regards!

Hi, prasaddn! No way of doing it without all pattern masks previously defined. Regards!

Hi, Chihiro! AFAIK this is true from Excel versions 2010+, but for older ones -2007 in particular, which is still highly deployed- it is strongly recommended. VBA garbage collector uses a reference count that automatically destroys objects when it reaches zero. From 2010 in advance it's...

Hi, DangerMan88! Give a look at the uploaded file. This is the involved code: Option Explicit Sub RollingSetback() ' ' constants Const ksWSInput = "Kaizen Log" Const ksTeamMembersInput = "TeamMembersTable" Const ksTypeInput = "TypeList" Const ksMembersInput =...

Hi, Belleke! Give a try to this code: Option Explicit Sub X() Debug.Print sCarlsbergFunction("123456789A024321") End Sub Function sCarlsbergFunction(psInput As String) As String '123456789A024321 into 1234.56.789.A02.4321. ' constants Const ksPos = ",4,2,3,3,4" '...

Hi, jb! It's right that COUNTIF's range could get changed, since you'd be moving boundary cells of that range. But in the uploaded file you used ranges from row 3 to 7 and if you're changing row 2 formulas related to 3:7 won't get changed, of course. Regards!

Hi, ! Welcome to Chandoo forums! Checked this yet? http://chandoo.org/forum/forums/new-users-please-start-here.14/ About your question, have you tried the built-in feature for recording macros? This question it's very likely to be suitable for this approach method, which is feasible for novice...

Hi, Cody! 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, Krishna Khemraj! Does this help? https://stackoverflow.com/questions/38145421/vba-listbox-drag-drop Regards!

Hi, Eloise T! I think your glasses are needing an urgent upgrade. You read this: and missed this, which was just following: BTW, nice Spanish :) Regards!

Hi, Eloise T! I always post formulas in local and English languages. Regards!

Hi, Dillina! Does this help? https://excelribbon.tips.net/T008731_Maintaining_Formatting_when_Refreshing_PivotTables.html Regards!

Hi, Eloise T! Another option: =AÑO(HOY())-AÑO(C4)-(MES(HOY())-MES(C4)<0)*1-Y(MES(HOY())-MES(C4)=0;DIA(HOY())-DIA(C4)<0)*1 -----> in English: =YEAR(TODAY())-YEAR(C4)-(MONTH(TODAY())-MONTH(C4)<0)*1-AND(MONTH(TODAY())-MONTH(C4)=0,DAY(TODAY())-DAY(C4)<0)*1 Regards!

Hi, NSMURTHY! No need of VBA code for that. Check the uploaded file. I moved totals to row 1 for easy sum formula and placed only one formula for all data cells: A3: =SI(Sheet1!A2="";"";Sheet1!A2) -----> in English: =IF(Sheet1!A2="","",Sheet1!A2) Copy across and down as required. Yellow shaded...

Hi, Izhar! Glad you solved it. Thanks for your feedback and welcome back whenever needed or wanted. Regards

Hi, GN0001! 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. Regards!

Hi, Eloise T! Regards!

Hi, Winston618! Please do take care of resetting "On Error Resume Next" sentences with "On Error Goto 0" since any other error (not only that which you want to trap) that happens after executing that statement will be omitted and code flow may go thru unwanted instructions. Remember that is...

Hi, sms2luv! Posting at a thread without adding anything useful, just to bounce it up, doesn't guarantee better probabilities of getting answers to your original question. I think that people who usually read these forums or who stumbled over your question, receive a very first impression...

Hi, Izhar! You've introduced slight changes that have high impact in the code behaviour. The updated uploaded file corrects all them: a) your worksheet data starts at row 3 and not at row 2 b) there's missing the named range "FilterList" which corresponds to parameters c) you've removed the 2...

Hi, alexandru barabas! First of all, 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!