LinkBack URL
About LinkBacks
Using Excel 2010
Hello,
In the attached workbook I have done all correct as per given link, but in the cells E5:E19 formula is not working giving results 0.
Does is possible instead Formula To VBA solution.
Please help.
Regards,
Moti
Using Excel 2010
Hello,
In the attached workbook I have done all correct as per given link, but in the cells E5:E19 formula is not working giving results 0.
Does is possible instead Formula To VBA solution.
Please help.
Regards,
Moti
I have changed formula slightly.
It is an ARRAY formula needs ARRAY entry(Ctrl+Shift+Enter). In E5 copied Down.
Formula:
Please Login or Register to view this content.
To enter ARRAY formula
Copy and paste the formula in cell
Press F2
Press Ctrl+Shift+Enter together
Excel covers the formula with {}.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
@Kvsrinivasamurthy, Thank you, yes your formula worked as expected correctly.
Does it is possible to get VBA
Have a great weekend. Good Luck!
Kind Regards,
Moti
Ok. I will try.
Only change that can be made is instead of manually entering the formula, VBA code will enter formula. We cannot avoid formula because Rand is a volatile function. Any change in worksheet changes the values in Column B.
Code for VBA
Please Login or Register to view this content.
Last edited by kvsrinivasamurthy; 04-13-2024 at 10:41 AM.
@Kvsrinivasamurthy, ok I understand you just rapped a formula in the code because of Rand Function. Ok I have changed the L & W values fixed now in the column C…and I want count for Consecutive Count L & W in the columns F:G…does in the situation is it possible to have proper VBA solution. Please see the attached sheet.
I appreciate your help. Have a great weekend. Good Luck!
Kind Regards,
Moti
Last edited by Motilulla; 04-13-2024 at 03:35 PM.
Try.
Code:
Please Login or Register to view this content.
Another code without using formulas
Please Login or Register to view this content.
@Kvsrinivasamurthy, you made my day I am happy to have solution post#7 this is what I wanted it is an amazing answer. I want one more favour please can you add one more character “D” for results also. I have not expected result for this task W&D&L; I hope you will find it.
Please can you take a look when you can?
Thank you for your time to solve W&L puzzle. Have a great Sunday. Good Luck!
Kind Regards,
Moti
Adding to KVS solution [all credit to KVS
Please Login or Register to view this content.
Last edited by JohnTopley; 04-14-2024 at 06:27 AM.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
@JohnTopley, thank you for adding D, into @kvsrinivasamurthy code it is your generosity it would like to thank you also for it. I like your added formula Check Sum.
@kvsrinivasamurthy, this is entirely solved thank to you for initial start-up solution.
Wish you both great Sunday and good health always.
My best regards,
Moti
Last edited by Motilulla; 04-14-2024 at 07:23 AM.
Welcome. Thanks for the comments.
@JohnTopley, please can you take a look post#9 code; where the L result are correct, but of the D & W are not? Here is the file attached
Kind Regards,
Moti
My typo!Please Login or Register to view this content.
JohnTopley, thank you for the quick correction all worked perfectOriginally Posted by JohnTopley
My typo!Please Login or Register to view this content.
Have a pleasant day.
Kind Regards,
Moti
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks