Forum Widgets
Latest Discussions
Counting worked hours in a timeslot
Hi All, Looking to calculate how many hours a person has worked within set of parameters to determinehow many FTE there are available within three hour timeslots. So if column K and L have the start and end times, I am a looking for a formula to calculate how many hours that person worked within two other sets of time as stated in M1/M22: Filled in the first line as an indication of what I am hoping to achieve. Any help would be much appreciated!
Unknown error
I 'd copy screenshots ctrl + v to the cells wjile working on my file. It worked like a charm but then I've had uninstalled my excel do to the license expiration it was 2019 version and noticed this error so i thought to myself that need to get the latestet version. Just downloaded it and still the error is unknown please adviseConditional Formatting Rules randomly being deleted, not by a person, on shared workbook
I have an Excel workbook with multiple tabs that have different Pivot Tables based off of the same master table on its own sheet. I have been able to successfully create Conditional Formatting rules on a Pivot table using a formula before applying the rule. However, the rules that use formulas (not the ones for example based on a single cell value) are deleted from the sheet at what seems to be random times. I have confirmed that no individual is deleting this (on purpose). This doesn't seem to happen when I have my own sheet no matter how I change or update the data. i have also shared the sheet via OneDrive with another person and neither of us could get this to occur. But the live workbook, which is located in a Document Library in SharePoint (MS 365, several users also sync this library to OneDrive) and we have multiple users editing the master table and refreshing the pivot tables throughout the day either from the online version or in the desktop app. This seems to be specific to the sheets on SharePoint/OneDrive and that are using formulas in the conditional formatting rules. I can't find anything that talks about this in my searches so wanted to see if 1) anyone has also experienced this and 2) Any ideas if this can be solved or how to solve it? Here's an example of how the rules are setup. The formula ones are the ones that get deleted at random. I've tried other variations of the formulas as well and am pretty sure at this point that its the use of a formula, not the structure of the formula.I have conditional formatting formula is not working. I help with it.
I have a conditional formatting formula that is not working. I help with it. I need help with highlighting green if I got the right pick. I need help with highlighting red if I got the wrong pick. I put P where I think cell F6:F21. Thank You
Trouble with Countifs with Multiple criteria
I have a file that I want set so that when I dump my data into a tab it breaks everything down for me. I'm have specific issues with multiple criteria. i.e the highlighted cells in the attached file. I can't get the formula to pull both ecom numbers and mpus numbers. I'm also have issues grabbing only the numbers for orders "Not allocated" and "waiting on plan" or vice versa all orders except "Not allocated" and "Waiting on plan" Hopefully looking at the file it'll make more sense as to what i'm trying to do.
Meal cards
Marketing insists on giving me her spreadsheet like this. Currently I just have to sort out each column and print separately. The problem then becomes her wanting "couples" to stay together. So I cannot sort them together if I am forced to do it by the meal type. Is there a better way? Is there a way to quickly put all the data from C, D, E into a column together "meal choice" cell by ignoring the blanks? It just takes forever to do this. Find and Replace then print all columns separate then manually put the cards back with their couple grouping.Pasting column width issue
not sure if this started happening with version 2414 build 18324.20168 or not, but if i filter a table and copy it, then paste the copied cells as values to another sheet or workbook and then do a subsequent pastepecial and choose column widths, the data is deleted. can anybody repro?Row data value changing if changing the value in other row
Hi all, i am trying to solve an issue but couldn't. I want to change 2 rows value but if i change the row value others value also gets changed. There is no formula anywhere. It is a pivot table with external connections. Before changing value: After changing value in 1 of the row: I just want to change 2 values but it also changes other highlighted values too. Thanks
