Forum Widgets
Latest Discussions
Gantt Chart without weekends
I have a Gantt chart in Excel to help us with project management and timing. I found an example a few weeks ago and have modified it to get about 95% of the way done. The issue is weekends. The chart, and the calculations, are using a full 7-day week and not a 5-day work week. Attached is a screen capture. L5 contains the formula that starts the chart. =Project_Start-WEEKDAY(Project_Start,1)+2+7*(Display_Week-1) Project_Start is the range T1:AC1, although I'm using it as the end/launch date of the project. My task calculations work back from that date. Display_Week is the range T1:AC2, again I'm working backwards from the launch date so that's a negative number here. As outlined in the red box, the tasks and chart are including weekends. How do I fix that so it calculates dates based on work week vs calendar week and also doesn't display weekends on the chart itself? Thanks!MichelBrysonNov 13, 2024Occasional Reader8Views0likes2CommentsDynamically fetch print area from other workbook on company network
I'm trying to prepare a sheet in workbook DEST that contains data fetched upon opening from a print area in workbook SOURCE. This is for the benefit of person X in my company who does not have access to SOURCE, while we both have access to DEST. Both workbooks live in our company onedrive and other people also contribute data to the print area in SOURCE. I can achieve this by establishing a data connection, but it only works for my changes to SOURCE. They will be propagated to DEST when DEST is opened, provided SOURCE is closed, otherwise a permission error occurs. Also, if other people contribute to SOURCE while I am away from office, those changes will not end up in DEST until I have opened SOURCE and somehow updated what seems to be "my version" of the SOURCE workbook. It seems the linking of data is dependent on my credentials. Is what I want to achieve not feasible with Excel 365? can changes not propagate to DEST unless SOURCE is closed? Can I not get changes to propagate without having to open SOURCE myself?pasticNov 12, 2024Occasional Reader4Views0likes0CommentsFormula Needed
Using Alexis as an Example, I need Excel to search Column A for all the versions and then avg the data for the same Column found in B because sometimes there are multiple for the same Column. As in Column D. Then I would like the avg'd information to be put into H-J respectively for each name in Column G. Can this be done? I assume its going to involve MAP, Index? Where I am stuck is Column A includes the Column G but not exact match and the AVG data found in the Columns B-D and puts it in its corresponding column H-J.SolvedRoPa321Nov 12, 2024Occasional Reader10Views0likes4CommentsAuto fill Department column
Good afternoon Microsoft Community, This is my first post ever with this site. I have the following project that I need help with. I need to auto fill the Department in column A in the Raw Data worksheet, with the DEPARTMENT name on worksheet Supervisor Drop-Down list. The Raw Data worksheet has Column F with the names of the current employees. I want a function/formula that will check for the names in the Supervisor's Drop-Down list and automatically add that department to Column A on the Raw Data worksheet. I have explore many different videos on the web and have not been able to find a solution. please advise on the best approach to handle this task.SolvedMartinDeLamoraNov 12, 2024Copper Contributor76Views0likes8CommentsComplex look up with output
Hi, I'm looking for help with a complex lookup problem. I have tried a number of options but haven't been able to achieve the desired result. If it were possible to use Conditional Formatting to highlight unique values incolumns from 2 different Excel sheets that updates when filters have been applied to each then this would be a simple solution, but unfortunately Conditional Formatting does not update/adapt to filtered data (that I can see), so I'm trying to achieve something more complex and dynamic with Ifs, AND, Lookups etc... Basically, a simplified version of the problem (which I have created a sample Excel sheet for this but there doesn't appear to be anywhere to upload a document) is: Lets say I have a list of training courses in a table with column headers for different Grade and within each Grade column there is L1,L2,L3... representing different levels. On another sheet I have a report of students who have competed various courses. I want to search the table by Grade an level for respective courses and search the students report to see if they have those courses complete. Any courses not listed in the student report, for that student, needs to then be displayed in a list so that it the courses can be assigned. The idea would be that multiple cross checks could be done for each student who is in a different Grade/level to see what they are missing. I created a 3rd tab with dropdown menus for the 3 variables, where the output list of courses should be displayed. Is that possible? Many thanks in advance for any help with this.anealonNov 12, 2024Copper Contributor37Views0likes3CommentsCOUNTIFS Automatically pick up cell
I have built a worksheet using countifs to counts the number of transits ships make in and out of the port with 3 criteria. As we are monitoring across a 12 month period for compliance the workbook is working well. One of the criteria is counting the Captain's name (1 of 41 names). Is there a way to automate the formula to pick up the name rather than typing it 96 times for each person. This is the COUNTIFS formula - The Name in this case is Starkey =COUNTIFS(June!$C$2:$C$638,"Night",June!$F$2:$F$638,"Starkey",June!$K$2:$K$638,"Inbound",June!$M$2:$M$638,"Tory")SolvedJakeOliverNov 12, 2024Copper Contributor351Views0likes11CommentsExcel functions for column compares
I'm new to Excel and want to find a function that compares one column to another and if the value goes up sends me an indication (trend up) and if the value goes down (trend down). For example Total Count Most Recent Today Count 15,054.29 10/30/24 18607.14 4.57 10/10/24 4.57 6,692.13 10/30/24 6889.51 3,504.65 10/30/24 4191.37 If Total Count is larger than Today Count - return trend down indicator If Total Count is less than Today Count - return trend up indicator If Counts are equal - no trend indicator Is there a function that can do this on Excel?draiaNov 12, 2024Occasional Reader19Views0likes2CommentsRemove-Manipulate Quicken Data for Reporting
After bringing CSV into Excel I would like to convert to pivot table, but need to insert week ending data to each significant row (green) and remove date row without financial data, blank and total rows (yellow)InThoughtNov 12, 2024Copper Contributor2Views0likes0CommentsExcel Table Appears to Automatically Expand but drop down list doesn't update
I usedExcel 2013. I created a drop-down list that is based on an Excel Table via the Data Validation button on the Data ribbon. If I add or delete a row from the middle of the table, my associated drop-downs are updated automatically. However, if I inserta rowof dataat the very top or bottomof thelist (range), even though the table appears to have expanded,the drop-down list does not updateautomatically. The Auto Correct options "Include new rows and columns in table" and "Fill formulas in tables to create calculated columns" are checked.None of the sheets on my workbook are protected.RHONDA LUCASNov 12, 2024Copper Contributor63KViews0likes10Comments
Resources
Tags
- Excel41,575 Topics
- Formulas and Functions24,066 Topics
- Macros and VBA6,250 Topics
- office 3655,796 Topics
- Excel on Mac2,568 Topics
- BI & Data Analysis2,271 Topics
- Excel for web1,836 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,578 Topics