Latest activity
-
MMike H reacted to shamimarita's post in the thread Error with VBA code from youtube example with
Like.
Hello Mike, I reviewed the screenshot of your VBA code, and I see where the issue might be originating. The runtime error you are... -
Ttallnsknny replied to the thread How can I eliminate duplicates in a list and list in descending order?.Hi Shamima, Thank you again for your help, but it's still not quite correct. If I take your formula as suggested and plug it into the...
-
MMike H replied to the thread Error with VBA code from youtube example.Thank you so much! Sorry as I am new to VBA code in Excel. I replaced the code for sub Jan and Feb to test. Error is now gone...
-
-
shamimarita replied to the thread How can I eliminate duplicates in a list and list in descending order?.Hello Mike, Thank you for clarifying! Based on your description, here's how to achieve the desired outcome. Array Formula for Unique... -
shamimarita replied to the thread Error with VBA code from youtube example.Hello Mike, I reviewed the screenshot of your VBA code, and I see where the issue might be originating. The runtime error you are...
-
MGreetings. Love the video for creating tabs with in tabs. I set up 12 tabs, one for each month. 24 tabs total counting the on and...
-
-
Ttallnsknny replied to the thread How can I eliminate duplicates in a list and list in descending order?.Hello Shamima, Thank you for your input, but this is not what I am after. As a reminder, I use Excel 2016. I am not trying to identify...
-
shamimarita replied to the thread How can I eliminate duplicates in a list and list in descending order?.Hello, You can achieve this using a combination of Excel formulas to eliminate duplicates, sort the list in descending order, and...
-
Ddaveb1967b replied to the thread Excel Formula help.TY! - I will check this
-
shamimarita replied to the thread Excel Formula help.If the calculation isn't returning the correct percentage, it suggests there might be an issue with either the formula range or how the...
-
Ttallnsknny posted the thread How can I eliminate duplicates in a list and list in descending order? in Excel Formulas.Hello again, I'm close to finish my spreadsheet, but I am stuck on a new problem. I use Excel 2016 so some new functions don't exist...
-
Ddaveb1967b replied to the thread Excel Formula help.Thanks ! This looks perfect to me and I tried to utilize it but it is not calculating correctly. driving me nuts. for example - I...
-
shamimarita replied to the thread [Solved] Table can't be called.You're most welcome! I'm so happy to hear that the explanation helped deepen your understanding. Exploring alternative formulas is a...
-
shamimarita replied to the thread Excel Formula help.Hello, To modify the formula to count values between 0 and 48 (inclusive), you can use the following formula: =COUNTIFS(A2:A100...
-
shamimarita replied to the thread [Solved] Problem using IFERROR, INDEX and SMALL commands.Hello Mike, Thank you for your kind words! I'm so glad to hear that the solution is working well for you. If you have any more...
