logical 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 please
Newbie Question in Excel Formula's
I am creating a Excel sheet to calculate my company holidays over the annual period, and want it to calculate how many staff are off in any one day. So I want it to calculate FD, HD, UL so I know how many people are away from the business on a particular day. I have tried the help topics, but cant figure it out. PLEASE HELP! FD = 1 person paid for 1 whole day annual leave HD = 1 person paid for 1 half day annual leave UL = 1 person unpaid for 1 whole day unpaid leave RD = is not counted, but shown for planning purposes. Any help much appreciate, and thank you in advance.
Excel ran out of resources
Hi I am facing an issue with excel for Mac version 16.98, I am continuously getting message "Excel ran out of resources while attempting to calculate one or more formulas", when I delete the cell and type the formula again it is working and displaying the results, however when I try to close the file I am again getting the same message and the data gets changed to "Cal!" or Spill etc.... Can anyone support to resolve this issue Regards Ramsesh
Hvborfår tester Excel feil tall opp mot hverandre.
Jeg har i lengre tid avdekket og dokumentert en gjentagende feil i Microsoft Excel ved testing av tallsystemer opp mot faktiske lottotrekninger. Excel gir feilaktige resultater ved sammenligning av tall, selv når dataene er korrekt formatert og logikken bak testene er enkel. Dette er uakseptabelt fra et verktøy som profilerer seg som et presist og pålitelig regneark. Eksemplet gjelder: Testing av riktige tall i en gitt rekke mot tall fra offisielle trekninger. Antall treff rapporteres feil av Excel, og resultatet samsvarer ikke med manuell kontroll eller testing i andre systemer (eks. Python). Formatet på tallene er korrekt, og ingen spesielle desimaltall, flyttallsfeil eller tekstdata er involvert. Finner heller ikke en formel/kode som passer inn. Får feil på feil. Har nåen andre opplevet det samme. BMA
Validate the data logger data
Here the data is downloaded from the data Logger We want to check the pass or fail Allowable limit is given below the picture Is it possible to check the readings are within the limit or out of limit please guide me how to solve In time hours 2 hours + 20 hours = 22 hour 2 hours + 20 hours+ 12 hour =34 hours
Grand total line as a secondary axis to a clustered column
Hello, I need to make a combo chart for my table. Each week will have 5 clustered bars of Activity amount, then on the secondary axis, I want to show a line for the number of total activities per week. I have tried to make a pivot table; Unit and Category under Filters, Discipline under Columns, Week under Rows, and Sum of Remain under Values. I have enabled the grand total for rows and columns as well. But when I create the chart, I can't choose the Grand Total for the secondary line. Should I add a column, or make another helper table? Also, if I want to make another chart to only show the difference amount of Activity done per Unit, Category, and Discipline each week what should i do? Sorry if this sound trivial as I'm a beginner. Thank you! here is a sample for my table. https://docs.google.com/spreadsheets/d/1ffnBTEjYPAbbcLxDdFAtUwpEJUqWJh6q/edit?usp=sharing&ouid=107141251993720714129&rtpof=true&sd=trueA 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.
Must Go Faster
I work in Sales. Every week I have to create an availability for our customers based off of our Availability. Our availability has multiple duplicates. I know how to highlight the duplicates. What I would like to do is run a formula for selecting 1 of the duplicates based on criteria from a different column. For Example A387-A392 are all 1gal Boxwood. I have to manually compare each row by column so that I only have 1 row left. Manually I would select Row 390 based on rooting, size, counted, and date last. I have tried IFAND, COUNTIFS, but I keep coming up with errors. Any help is appreciated.
