forum.chandoo.orgChandoo.org Excel Forums - Become Awesome in Excel

Menu Home Forums New posts Search forums What's new New posts New profile posts Latest activity Members Current visitors New profile posts Search profile posts Log in Register What's new Search Search Search titles only By: Search Advanced search… New posts Search forums Menu Log in Register Hi All Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam Post Spam and you Will Be Deleted as a User Hui... When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post. Home JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding. You are using an out of date browser. It may not display this or other websites correctly. You should upgrade or use an alternative browser . New posts Forums New Users - Please Start Here Important Information for New and Existing Users Threads 0 Messages 0 Sub-forums Sub-forums Introduce Yourself New Users Please Read Posting a Sample Workbook Frequently Asked Excel Problems Chandoo.org Ninjas Threads 0 Messages 0 None Ask an Excel Question Anything about formulas, formatting, shortcuts, pivot tables etc. Threads 26.6K Messages 162.2K Threads 26.6K Messages 162.2K P Simple Excel formula not returning accurate value (if <=) 1 minute ago Peter Bartholomew Discuss Data Visualizations and Charting Share charts and Discuss Threads 1.3K Messages 7.8K Threads 1.3K Messages 7.8K Best chart to visualise tax related scenarios Jan 10, 2020 Chihiro Excel Dashboards Discuss excel dashboards. Ideas, examples and more Threads 577 Messages 3.2K Threads 577 Messages 3.2K B Form Control - Scroll Bar - Was it working properly in prev. versions? Dec 23, 2019 Bhawani VBA Macros Discuss VBA for excel. Ideas, examples and more Threads 10.5K Messages 70.7K Threads 10.5K Messages 70.7K Please Help with this issue 45 minutes ago Marc L The Vault A collection of tips, VBA code samples, examples & tricks shared by our members Threads 143 Messages 733 Threads 143 Messages 733 A Remove password Monday at 2:36 PM Arachnyss Excel Challenges Post an Excel related Challenge for others to Solve (You must have a solution) Don't post questions here! Threads 57 Messages 997 Threads 57 Messages 997 Sorting a list of comma-separated lists Sep 30, 2019 salim hasan The Lounge Get to know each other, discuss anything excel and have fun Please don't post "How Do I ..." questions here, Use the other specific Forums Threads 702 Messages 6.4K Sub-forums Sub-forums Excel Resources Threads 702 Messages 6.4K Microsoft Navision / Dynamics Support / forum Yesterday at 2:18 PM Chihiro Questions about Chandoo.org Products Ask questions about Formula e-book, Project Management Bundle etc. Threads 112 Messages 459 Threads 112 Messages 459 K Need a formula to add zeros before the number Dec 31, 2019 KNMSRK Excel Jobs, consulting gigs & freelancing Post jobs, consulting gigs, freelancing opportunities about Excel, VBA, Add-in, Power BI, etc. Threads 27 Messages 89 Threads 27 Messages 89 [Paid] Show picture on floating userform Apr 15, 2019 Chihiro Power Pivot, Power Map etc Post your Power Pivot, Power Map etc queries here Threads 332 Messages 1.6K Threads 332 Messages 1.6K Replicate this COUNTIFS with DAX Yesterday at 3:37 PM rolo Whats happening... New Posts Unread Posts New Threads Latest posts S Simple Excel formula not returning accurate value (if <=) soderlloyd Today at 6:20 PM Ask an Excel Question Replies 2 Views 5 1 minute ago Peter Bartholomew P F Please Help with this issue Fred Wayne Today at 12:41 PM VBA Macros Replies 3 Views 51 45 minutes ago Marc L Y How to extract text to the left of the second occurrance of a date. Yodelayheewho Today at 5:16 PM Ask an Excel Question Replies 1 Views 8 48 minutes ago Chihiro N Pdf file Nashraze Today at 4:01 PM Ask an Excel Question Replies 1 Views 11 49 minutes ago Marc L Conditional Formatting toggle? mklangelo Today at 1:25 PM Ask an Excel Question Replies 1 Views 21 Today at 4:39 PM mklangelo F VBA - web scraping same class but different inner text ferocious12 Sunday at 9:13 PM VBA Macros Replies 8 Views 124 Today at 3:12 PM p45cal P Locked VLookup + Countif + Sum RTowles Today at 2:23 PM Ask an Excel Question Replies 1 Views 25 Today at 3:05 PM bluesky63 B K I need help with a VBA time function, please? Kristen_cancerkiller Sunday at 2:30 AM VBA Macros Replies 11 Views 137 Today at 2:05 PM Kristen_cancerkiller K B Overlapping time formula help bmegal4909 Yesterday at 4:01 AM Ask an Excel Question Replies 4 Views 57 Today at 1:29 PM Peter Bartholomew P S In a sheet all cell value come to same column sivaprakasam Today at 10:19 AM VBA Macros Replies 1 Views 14 Today at 10:51 AM Marc L A Need Circuit to search alphanumeric value as well. Ananthram.Gupta Yesterday at 5:02 AM VBA Macros Replies 1 Views 62 Today at 9:33 AM Ananthram.Gupta A J Excel function help (countif?) Johnny3000 Yesterday at 6:19 PM Ask an Excel Question Replies 4 Views 54 Today at 9:09 AM Johnny3000 J K help with formulas please keasha Yesterday at 12:12 AM Ask an Excel Question Replies 4 Views 64 Today at 8:35 AM bluesky63 B F How to count days without public holidays and any leave? Falinaicare Yesterday at 8:21 AM Ask an Excel Question Replies 2 Views 45 Today at 4:27 AM Falinaicare F M VBA to deselect single slicer item using data model pivot table morgyt Wednesday at 9:59 PM VBA Macros Replies 4 Views 53 Today at 2:43 AM morgyt M P Could you point me in the right direction? Peacedout Yesterday at 1:02 AM Ask an Excel Question Replies 9 Views 52 Yesterday at 6:56 PM vletm V T Formula For Total Charges Based on Dates and Holidays Tech56 Yesterday at 3:49 PM Ask an Excel Question Replies 2 Views 37 Yesterday at 4:58 PM Tech56 T N I am trying to create a pivot table that shows backlog items by month in 30/60/90 day format. Please advise how this can be done NikNac Yesterday at 3:27 PM Ask an Excel Question Replies 1 Views 19 Yesterday at 3:59 PM vletm V S Change letters for +/- SarahJohnsonHBB Yesterday at 3:13 PM Ask an Excel Question Replies 1 Views 32 Yesterday at 3:55 PM vletm V Replicate this COUNTIFS with DAX rolo Yesterday at 11:17 AM Power Pivot, Power Map etc Replies 2 Views 34 Yesterday at 3:37 PM rolo View more… Latest posts S Simple Excel formula not returning accurate value (if <=) soderlloyd Today at 6:20 PM Ask an Excel Question Replies 2 Views 5 1 minute ago Peter Bartholomew P F Please Help with this issue Fred Wayne Today at 12:41 PM VBA Macros Replies 3 Views 51 45 minutes ago Marc L Y How to extract text to the left of the second occurrance of a date. Yodelayheewho Today at 5:16 PM Ask an Excel Question Replies 1 Views 8 48 minutes ago Chihiro N Pdf file Nashraze Today at 4:01 PM Ask an Excel Question Replies 1 Views 11 49 minutes ago Marc L Conditional Formatting toggle? mklangelo Today at 1:25 PM Ask an Excel Question Replies 1 Views 21 Today at 4:39 PM mklangelo F VBA - web scraping same class but different inner text ferocious12 Sunday at 9:13 PM VBA Macros Replies 8 Views 124 Today at 3:12 PM p45cal P Locked VLookup + Countif + Sum RTowles Today at 2:23 PM Ask an Excel Question Replies 1 Views 25 Today at 3:05 PM bluesky63 B K I need help with a VBA time function, please? Kristen_cancerkiller Sunday at 2:30 AM VBA Macros Replies 11 Views 137 Today at 2:05 PM Kristen_cancerkiller K B Overlapping time formula help bmegal4909 Yesterday at 4:01 AM Ask an Excel Question Replies 4 Views 57 Today at 1:29 PM Peter Bartholomew P S In a sheet all cell value come to same column sivaprakasam Today at 10:19 AM VBA Macros Replies 1 Views 14 Today at 10:51 AM Marc L A Need Circuit to search alphanumeric value as well. Ananthram.Gupta Yesterday at 5:02 AM VBA Macros Replies 1 Views 62 Today at 9:33 AM Ananthram.Gupta A J Excel function help (countif?) Johnny3000 Yesterday at 6:19 PM Ask an Excel Question Replies 4 Views 54 Today at 9:09 AM Johnny3000 J K help with formulas please keasha Yesterday at 12:12 ...