Forum Widgets
Latest Discussions
Excel help
Hi all, I have list of LGA location names in excel file. An example are as follows: Currently after I extract the data, I use look up function to get the New LGA column to replace the existing data. This is a manual task. The original file I have download from MS SQL and the file format is csv. Is there any other way that can do this more efficiently and automatically? Thankskpan8Feb 13, 2025Copper Contributor5Views0likes0CommentsREMOVE A CHECKBOX FROM EXCEL WORKSHEET
I was handed an Excel worksheet that has three checkboxes that I wish to remove but cannot seem to remove them. Excel Help says to right click the Box and then hit Delete. There is no Delete in the ensuing dropdown menu and Delete on the keyboard does not work. Any suggestions?tjbCanton2020Feb 13, 2025Copper Contributor317KViews4likes22CommentsImport Tab Delimited File from Clipboard
I'm looking to create a macro in excel to import a file from clipboard. I have tried to record a macro and that did not work. I do not want to enter a file name. I would like to copy from notepad and execute macro to import the data with pipe delimits. Sorry if this is a repeat, I ould not fine an answr anywhere. Thanks.JimKFeb 13, 2025Occasional Reader4Views0likes0CommentsDax to find open status for more than 1 hour
Hi Team, I have the below table: Here I want to find that whether door is being open for more than 1 hour or not. The Status column shows whether door is open or not. CreatedOn column shows time duration. Could you please help me create a dax logic to achieve this? PFA file here B&M.pbix Thanks in advance! SergeiBaklan33Views0likes1CommentOptimizing Excel Formula for Dynamic VLookup
Hi, I have this formula: =IF(F2="", "", VLOOKUP(IF(VLOOKUP(F2, $A$2:$I$1400, 4, FALSE) = 0, VLOOKUP(F2, $A$2:$I$1400, 6, FALSE), F2), $A$2:$I$1400, 9, FALSE)) This formula is meant to fill in the Manager’s email. Rank 0: Every role below the Department Manager level is ranked as 0 in the 4th column (‘Rank’). Currently If an executive reports to a Senior Executive (Rank 0), the formula checks the 4th column. If the Senior Executive has a Rank 0, it looks at the 6th column instead (to get the employee number the Senior Executive reports to). Example: For employee ‘7586’ with email ‘email address removed for privacy reasons’, the formula currently fills ‘email address removed for privacy reasons’. It first looks at the 4th column of 1577, finds 0, then takes the value in the 6th column (0209) and uses that for the final VLOOKUP. Needed Change: I need the formula to perform an additional VLOOKUP. It should check the 4th column for employee 0209. If it’s still 0, it should look at the 6th column instead. Goal: The new formula should fill ‘email address removed for privacy reasons’ as the manager’s email for employee 7586, not ‘email address removed for privacy reasons’.8932LDGFeb 13, 2025Copper Contributor22Views0likes1CommentWhat causes an excel file to 'Show Print Preview' rather than show the preview by default.
I am curious what causes this to happen, I have already set the print area etc., but for some reason I don't get an immediate preview when going to print, I have to click this button inside the print preview. (I have also attached the full screenshot Doesn't seem to matter what settings I change so far, just curious what exactly causes this change in excel, I have many other documents that just bring up the preview straight away when going to print, but at the moment, this one particular file I have to click another button. I have a MS flow that converts excel files to pdf automatically after a review process, but it keeps failing on this one file and I can't figure out why, but I think the key revolves around this, so I really want to find out what causes excel to present an additional button that you have to click to generate a preview rather than showing the preview off the bat like it does with every other file which works fine in the flow. ThankyouModulaFeb 13, 2025Copper Contributor46Views0likes4CommentsExcel Maps not showing all options for regions
Good morning , I am trying to generate maps with excel, however I don't visualize the possibility to select Multiple countries/regions and Countries/regions, only World and regions with data. The first screenshot is how it should be, the second is my Excel program. Does someone know why? thank you for any help (consider that I am at Excel for dummies level... ) MarinaMarCar80Feb 13, 2025Occasional Reader16Views0likes2CommentsAssistance with complex VLOOKUP formula
Hi everyone, I need some help with a formula I'm using to fill in the Manager’s email. Here is the formula: =IF(F2="", "", VLOOKUP(IF(VLOOKUP(F2, $A$2:$I$1400, 4, FALSE) = 0, VLOOKUP(F2, $A$2:$I$1400, 6, FALSE), F2), $A$2:$I$1400, 9, FALSE)) Context: Rank 0: Roles below the Department Manager level are ranked as 0 in the 4th column (‘Rank’). Current Process: If an executive reports to a Senior Executive (Rank 0), the formula checks the 4th column. If the Senior Executive has a Rank 0, it looks at the 6th column instead (to get the employee number the Senior Executive reports to). Example: For employee ‘7586’ with email ‘p22#gmail.com’, the formula currently fills ‘p23#gmail.com’. It first looks at the 4th column of 1577, finds 0, then takes the value in the 6th column (0209) and uses that for the final VLOOKUP. Needed Change: I need the formula to perform an additional VLOOKUP. It should check the 4th column for employee 0209. If it’s still 0, it should look at the 6th column instead. Goal: The new formula should fill ‘p26#gmail.com’ as the manager’s email for employee 7586, not ‘p23#gmail.com’. Any suggestions on how to adjust the formula to achieve this? Thanks in advance!Agile6679Feb 13, 2025Copper Contributor49Views0likes2CommentsHow do I display duration data in a Stacked Bar Chart using dates?
I want to display the duration of my projects in a chart using the dates (quarters). I tried using the date data but the chart does not display the way I want. I was able to display the data using the actual duration data but that doesn't map to the quarters. Can you please let me know how I need to setup the data to have the dates as the hortizonal axis? Thanks in advance! This is the data the chart is based on. Resources Project Name Feasability Initiation Programming & SD Phase Authorization DD & CD Phase Construction Approval Mary Jones Jackson Library 775 238 20 209 627 20 Macon GA Court House 772 53 20 93 837 20 LA Center 257 439 20 339 997 20 NYC 5th Avenue 70 175 387 20 369 625 20 Keller Museum 70 175 387 20 369 625 20 Kevin DeMichel CUBs Stadium 72 213 20 165 420 20 Dan Mitchell Newark DE Library 356 303 20 256 644 20 John Daily Sears Tower 100 100 100 100 100 100 100 This is the RAW data: Project Resource Activity Name Start Finish Original Duration Jackson Library Kevin DeMichel Feasability 27-Nov-17 20-Aug-18 0 Initiation 17-Aug-18 20-Nov-20 775 Programming & SD Phase 20-Nov-20 19-Dec-20 238 Authorization 19-Dec-20 23-Sep-22 20 DD & CD Phase 7-Oct-22 13-Oct-25 209 Approval 1-May-23 26-May-23 627 Construction 30-May-23 30-May-23 20 CUBs Stadium Christina Marzocca Feasability 27-Nov-17 20-Aug-18 Initiation 15-Aug-18 29-Jun-20 Programming & SD Phase 29-Jun-20 27-Jul-20 Authorization 27-Jul-20 23-May-22 DD & CD Phase 9-Feb-22 4-Jun-25 Approval 1-May-23 26-May-23 Construction 30-May-23 30-May-23 Newark DE Library Dan Mitchell Feasability 27-Apr-20 12-Aug-24 Initiation 27-Apr-20 5-Jul-21 Programming & SD Phase 5-Jul-21 23-May-22 Authorization 23-May-22 17-Jun-22 DD & CD Phase 17-Jun-22 26-May-23 Approval 29-May-23 26-Jun-23 Construction 31-May-23 12-Aug-24SolvedE_Buck2010Feb 13, 2025Copper Contributor8.6KViews0likes4CommentsNew formulas like FILTER and UNIQUE not appearing on macOS
Hello, I have MacBook pro with macOS Monterey 12.6.6 and I am running Excel 365 16.82. I know there is a more recent version of macOS and Excel which requires 13.0 or newer, but I don't think my version is that old that it doesn't have UNIQUE and FILTER? When I type =FILTER I get the error #NAME? and it is not suggesting any functions with similar names. Why is this the case?8Views0likes0Comments
Resources
Tags
- excel42,204 Topics
- Formulas and Functions24,465 Topics
- Macros and VBA6,353 Topics
- office 3655,939 Topics
- Excel on Mac2,619 Topics
- BI & Data Analysis2,334 Topics
- Excel for web1,879 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,609 Topics