Excel says two numbers are not equal
Column A are numbers typed into the cells. Column B, the numbers in B1 to B3 are also typed in. Cell B4 is SUM(b1:b3) C4 is =B4=A4 Can someone please explain why excel is saying the two numbers in A4 & B4 are not equal. I understand about using rounding or truncation with large calculations but I've never seen anything like this on such a simple calculation. I've tried this on a new spreadsheet and the results are the same. I am using Excel Version 16.109 (26033013) on a Mac. Thank you for your help.
Unwanted format changes on Excel worksheet in SharePoint
Hello - I've been working successfully with an Excel worksheet (.XLSX extension) that is published to SharePoint and has multiple Users viewing/updating data on this worksheet every day. Today, columns on this worksheet keep reverting back to varying widths (some way too wide and others way too narrow) despite going into the worksheet, re-formatting the column widths and saving the document. Other worksheets in the same workbook so far do not exhibit this behavior and are maintaining the desired column formatting (i.e., proper widths). I cannot figure out what is causing this unwanted formatting to happen and it has not happened before. I'm guessing this is an Excel issue, but might the SharePoint component be a factor as well? What are the potential causes of this, and what can I do to make the desired formatting remain and not revert back to the unwanted formatting? Thank you!
Microsoft Excel Update Changed Formula
I've used Excel for the last 2-3 years to track changes in a sheet by month the data listed is added or changed. The formula I've used worked fine until today, when I started receiving an _xlfn in the formula. It now reads as follows: =IF(ISBLANK($A6),$A2,IF((_xlfn.MAXIFS(A$7:A$41,D$7:D$41,">"&0))>=$A$2,_xlfn.MAXIFS(A$7:A$41,D$7:D$41,">"&0),"")) My goal was to have Excel look if there were updated values in D6 and enter the most recent date associated with that value from A6 to A41. Does Excel no longer support MAXIFS?
Need a consecutive XLookup
Hello All, OK let me describe what I am trying to do: I need to create a Task List. In this list I will have let’s say 200 tasks, and 50 people to perform these tasks. i need a way to assign the first task to the first person, then the second task to the second person, then the 3rd task to the 3rd person and so on until the first 50 tasks are assigned. then I need to assign the 51st task to the first person, the 52nd to the second person, and the 53rd task to the 3rd person until that batch of tasks and People are matched. but this is not linear, I may want to choose task 52 to person 3 because the 3rd task is related to the 52nd task. i can live without this feature and fine tune the list manually but the main question is how can I look up a name and match it to a task. i hope this makes sense to you, please ask for any clarification and i shall add that bit. thanks in advance… wassim
Text to Column
Hello Everyone. I'm trying to split data into 2 columns. The original data is made up of cities and states: Notice that some items have a comma and others don't. Also, the cities states are different lengths. So, I cannot use a space or a comma as a delimiter. I'm trying to figure out how to separate them. I came up with this formula to add a colon so I can use the delimiter to separate them. The problem then becomes the fact that I have to count the number of spaces in each city to add the colon. Then, I have to copy and paste special as values. Also, notice that in New Orleans (for example), it keeps the comma: One more issue, if I get a new report with added cities and states, then I have to re-do the calculations. HELP!!!! BaltaLook up a date range and return title from list of date ranges it falls within?
I searched and didn't quite find this answer, hoping somebody can help. I would say I'm a novice with Excel, but can generally follow directions well enough. I have a list of from and to dates. I also have a list of established date ranges, each titled. I would like to look up each of my date ranges to find if they fall witin any of the date ranges from the list and then pull in the appropriate date range title. Example: List of established date ranges: From Date To Date Range Title 1/1/2026 1/15/2026 Jan 1st Half 1/16/2026 1/31/2026 Jan 2nd Half 2/1/2026 2/14/2026 Feb 1st Half 2/15/2026 2/28/2026 Feb 2nd Half Data I'd like to look up within those ranges: From Date To Date 1/5/2026 1/8/2026 2/5/2026 2/11/2026 Expected Results: From Date To Date Range 1/5/2026 1/8/2026 Jan 1st Half 2/5/2026 2/11/2026 Feb 1st Half Any advice welcomed.value Based sorting in Excel pivot table follows which order for equal values ?
The image attached is the WorkSheet Source table , pivot I created , value based sorting 3rd table -> ASC 4th table -> DES It confusing to conclude in which order it follows for the equal values to sort labels help me to figure out the logic ?
Excel collage spécial formules
Bonjour, J'ai 3 fichiers excel qui ont la même structure. Lorsque je fais un collage spécial sur plusieurs cellules de l'un des fichiers, un travail se lance spontanément sur les 2 autres fichiers et fait qu'ils reviennent à l'état de leur dernier enregistrement. Impossible de revenir en arrière, même avec le raccourci clavier ctrl + Z. De plus le curseur dans le premier fichier ne s'affiche plus, une croix se mets à la place et il n'est plus possible d'utiliser la fonction coller
Help with summing totals using multiple texts
Good evening. I have attached an image of my spreadsheet below which hopefully will help my blurb make a bit more sense! I am producing some uniform for a local club. I have made a spreadsheet to allow me to track the number of garments and sizes ordered (purple table). However from this information in the purple table I need to know how many logos of each size to order (orange table). I know what size logo is required for all the different garments and sizes of garment, as can be seen in the blue table, but this would require me to go through 1 order at a time tallying up what size logos I require. Ideally I would like excel to be able to look at the purple table and tell me how many items there are that require a given size logo. For example, I know that a 'Youth S T-shirt' and a 'S Legging' and 'Youth M Hoodie' all require a 6cm logo. and also that the 'Youth M Hoodie' also requires an 18cm logo. I would therefore like excel to look at the purple table and see that there are 3 x 'Youth S T-shirt', 2 x S Legging and 2 x Youth M Hoodie, therefore 7 items require a 6cm logo, so I would like excel to populate the orange table in the 'total needed' column for 6cm (cell B23) to show '7'. The 'Youth M Hoodie' also requires an 18cm logo and therefore cell B28 should also populate with '1'. I have tried COUNTIF, COUNTIFS, SUMIF, SUMIFS, but none of them have worked. I do not know if I am entered the information into the equation incorrectly or if I am using the wrong function/formula. Can anyone please help! Many thanks.
