Forum Widgets
Latest Discussions
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!!!! Balta
Look 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.
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… wassimI need help with the baseball file.
I need help with the baseball file. Thes Teams Do Not Do Anything To Blue Jays White Sox Red Sox Column B At Astros I Want @Astros All Other Teams To Mariners At I Want Vs Mariners All Other Teams To Column C Change Time To One Hour Earlier Trim All Cells I Want Vba Code Thank you very muchnotes attached to cells not visible, broken since last excel update (Office 365 on Mac)
I've got many notes (the yellow non-threaded formerly called comments) in my excel sheets. Since the latest software update I can not display/view my notes anymore. The cells containing note still show the red triangle-mark, but the note does not show up when I mouse over. By clicking "show all notes" in the ribbon menu, it will just only show the connection lines between cell and invisible note rectangle. But I can not access view or even edit the notes. Also right click on the cell -> edit note does not show anything. is there a fix or at least a workaround existing? regards dewege macos: high sierra, excel (office 365) version 16.21.1 (190123)365 bestand downloaden naar desktop
bijgevoegd (groot) excel bestand kon ik niet meer met de desktop excel versie openen vanwege een beschadigd bestand en/of ander excel probleem (bleef hangen bij het berekenen van alle formules). ik kon het echter wel on-line openen met 365 (uploaden). Ga ervanuit dat daarmee de fout(en) in het on-line bestand gerepareerd zijn. Dus wilde ik het weer downloaden (zowel als xlsx en als csv) om weer verder te gaan met de desktop excel versie maar kreeg de melding dat dat te lang zou duren of te groot was. hoe krjjg ik het bestand nu weer op mijn desktop?
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
How to keep the result of the formula from appearing down the column before a number is added
I wish to produce a Teams running score sheet for lawn bowls. When each team (rink) has finished their end the score for either the H or A team is entered. When the next end is finished again the score is entered for the winning team. I am using an IF function in each of the coloured cells: =IF(B13="",C12,B13+C12) This works well, however the result of C?? runs down the entire column as cells in column B are blank waiting for the scores to be added. How can I fix this so the scores show for the rows only and not the entire column. Formula for the TOTALS column is =C10+G10+K10
Changing font color increases indent
The task is to color certain words or parts of certain words in the Arabic language. The original text was not indented, like so: but when I color a part of a word, the entire line becomes indented: but if I color the entire word, it goes back: The same thing happens to other fonts, other colors, and other parts of words too: There are other phrases in the cell so an indentation in one line makes it seem like the line has some particular significance when it doesn't. How do I remove that indentation?
