Forum Widgets
Latest Discussions
A formula to check whether "Start time" column is after "+12 hour" column
In the example above, the first column end time is 22:00, +12 hours column is 10:00 (this means that the employee can start work anytime after 10:00 to ensure they have gotten their 12 hour rest), and the start time was 12:00. In this example since the start time is 12, its after the rest time so this timing is acceptable). In the second example, the end time is 16:53, +12 hours is 4:53, and the start time is 2:00. Since the start time is within the rest time, this should be amended. Since there are a lot of data and rows and columns. I want a formula that can check and compare the "+12 hours" column and "start time". If the "start time" is before "+12 hours" column, I would appreciate it if the formula could either highlight that row or indicate that it hasn't met the 12 hour hour criteria in another way. Since there's a lot of columns and rows, if its a simple solution that doesn't require too much complication would be great, if possible.angeliaJul 14, 2025Occasional Reader15Views0likes1CommentA Little Help from my Friends
I am an advanced (expert) in Excel. I've used it for over 20 years everyday and have thousands of education hours under my belt. I would like to get some ideas on how some of you would approach this complex situation I have. I have already created three different methods but each have too many draw backs or failure points. With that said, I'll try to be brief but detailed enough for your thoughts. I have a file for which I'll call the Master-File it has a list of parts, suppliers, prices by month with Forecast and Actual. Current and Future months are forecast, previous months are actuals. I have 6 people that send me, what I'll refer to as Sub-Files. These subfiles contain the same headers as the Master-File. In the Master-File previous months data cannot change. (Ex. If reporting was done today 7/14 Actuals for June would be imported as Actuals and the remaining July thru December would be Forecast updated with the latest forecast data, which is already included in the sub-files). Months are listed left to right in columns not rows. Also, those sub-files can contain new parts that are required to be imported into the Master-File. My first solution was to use Power Query and import the Sub-files each month from a folder into the Master-file. Problem with that was, data from previous months would change in some of the Sub-Files and would over-write the data. (This data can't change once locked in). My second solution was to utilize a Unique ID for each record where I could easily identify new parts first and import that data by manually copying and pasting the data. Then sort the data using a match formula so the records in the Sub-file matched the Master-file and then manually copy and paste in the Actual and Forecast data. Some data was not correctly matched, so I started using XLOOKUP to import the data in the Actual and Forecast. Then, copy and paste as values. With 6 different files the table would at times over-write the data in the Actual forecast fields causing errors. Even after turning off auto table formula update option. Plus, this was very time consuming. Now I am starting over. I have some other ideas but if two heads are better than one then many heads are even better. I would love to hear your thoughts on how you would go about handling this process.47Views0likes4Commentslogical function
I have tried building a logical function that can help me calculate the exact values in the Score column. This can help me calculate for large data. values under the score section are the criteria that is reach if any of the conditions under the 6 disability domains is met. I need help pleasecnoah92Jul 14, 2025Copper Contributor40Views0likes2CommentsVersion History Empty
I use to use the feature https://support.microsoft.com/pt-br/office/restaurar-uma-vers%C3%A3o-anterior-de-um-arquivo-do-excel-89c09b39-8f01-456e-82be-5d89f371436a to recover old versions of my files. But today, when I went to recover a June 30th version of an Excel file, the versions table is empty. Is there any other way to recover old versions? This empty table is an application bug?MC11Jul 14, 2025Copper Contributor20Views0likes1CommentSubstituting Text in Excel Lookup Formula
I'm keeping game weekly statistics in Excel. I have the Lookup formula below: =LOOKUP(7,[WeekX.xlsx]Game!$A:$A,[WeekX.xlsx]Game!$B:$B) The "7" refers to a player number. I'm using Week1 in the first week, Week2 in the second week, etc. I have many of these Lookup formulas in the one spreadsheet. I would like to substitute "WeekX" where the "X" can point to a spreadsheet cell value (i.e. 1 or 2 or 3, etc.) I've tried double quotes "" and Concat in the Lookup formula. I have not been successful. Any suggestions?SolvedPaulMcK007Jul 14, 2025Copper Contributor78Views0likes5CommentsShortcuts to favourite formats in Excel for Web
We're switching to excel for web more and more. In my desktop excel, i have 6-8 favourite formats stored as simple macros, and short cut buttons in the quick access toolbear It makes it really easy to tidy up worksheets. Is there a way to achieve the same within excel for web? I know i can't add macros, but quick access to favourite formats makes life much easiertespo76Jul 14, 2025Copper Contributor102Views0likes2Comments- GHardy_1369Jul 14, 2025Copper Contributor275Views0likes1Comment
Excel College Student SOS
Hey! College student here. I've been jumping through hoops trying to understand Excel. I'm not sure if Microsoft Excel has changed because this is my first experience with the whole ordeal. The homework given from my (ACG Excel class basically) has me following directions and I can't find the Smart Lookup tool in the Review tab??? There are so many features I cannot simply find in the Ribbon. Also, the Ribbon looks different. Not necessarily like the original. Someone please help me out of my misery.greensidegoldJul 14, 2025Copper Contributor85Views0likes3CommentsGet spot prices for Gold and Silver using Stock converter
Hello, I am getting prices nicely for any currency using the quotation EUR/USD, Now if I do the same for XAU/USD or XAG/USD it doesnt work. I found out that i can input Gold or Silver but even then it chooses a stock instead of the spot price. TO get to that price i need to manually search in the data selector @SI0Y or @PL0Y. I need to be doing this via vba automoatically each day however. Can you help me out on how to get the spot prices for gold and silver directly and not doing manual searches? thxZio81Jul 13, 2025Copper Contributor1.3KViews0likes1Comment
Resources
Tags
- excel42,909 Topics
- Formulas and Functions24,895 Topics
- Macros and VBA6,452 Topics
- office 3656,100 Topics
- Excel on Mac2,665 Topics
- BI & Data Analysis2,405 Topics
- Excel for web1,943 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,658 Topics