Forum Widgets
Latest Discussions
"Reverse FV" function? Or?
Hi all, I need some help please. I would like formula for excel, where I have known inputs: A1 = 30 (number of years) A2 = 500000 (needed capital) A3 = 8% (known yearly return of investment p.a.) A4 = 10000 (initial investment) and I need to calculate needed monthly investment, to reach that required sum (in A2). Thank you very much for your help and time. DanielOBWM_Daniel_OMay 21, 2025Occasional Reader13Views0likes1CommentExcel no longer opening files with [] in the file name
Since office 365 upgraded to version 2504 our users have been unable to open files with [ ] in the file name. Example a file with the name [12004][]_MCH_12004-SSC Pacific.xlsx excel throws the errors Basically cutting off the whole file and only finding 12004 now. Why was this functionality taken away. We understand that [] is not recommended in an excel file name. We have antiquated systems written in COBAL that auto generate these file with the brackets. Older versions of office still can access the files but anyone with 365 can not. How can we get this functionality back? Nothing in the changelogs for office version 2504 mentions a change to remove this functionality.fair-riteMay 21, 2025Occasional Reader22Views0likes1CommentFormula needed to retrieve % of correct reviews for an employee, where reviews are on separate tabs.
Hello everyone! Thank you in advance for any assistance you are able to offer. I'm working in MS 365 for web on a windows cloud environment through a Citrix network. Looking for a formula that will populate one employee's evaluation results as a % correct for each of multiple worksheet tables of reviewed items (pass/fail). See attached workbook for details on what I'm trying to do. I would like to be able to choose an employee's name from a drop down on the RESULTS tab, select the months to begin and end a date range and have this return the total reviews and number failed for each 'Review Name' for that employee. Thanks again! :)SolvedMarcus_BoothMay 21, 2025Brass Contributor122Views0likes10CommentsFind and Replace Highlight colour
When I'm using the Find and Replace function and hit find, Excel finds the cell but its very hard to see because of the highlighted colour. Is there a way to change the default colour? Thanks in advance.Solvedmark_murphy_manlukMay 21, 2025Brass Contributor68KViews3likes51CommentsStop Autofill from Incrementing Certain Cells
I am going to try to explain this the best I can. Please, be patient with me. It might take a few attempts when it comes to properly describing things. Thanks! I am making a spreadsheet that keeps track of the ages for characters in a series I am writing. There are MANY characters, each one with a different birthday. Each story takes place for a different date and year. Right now, there are about 40 periods of time, and those are at the top of the spreadsheet. So, I basically have a character name, their date of birth, and then the subsequent cells calculate how old the character is for that period. When I try to use the auto fill, it increments the cell so that it no longer uses the correct cell. In essence, it tries to use the cell next to the date of birth cell. It does the same thing when I try with the column as well. So, how do I get the autofill to use a static cell horizontally while incrementing the cell vertically? Or the other way around?ScrewygirlMay 21, 2025Occasional Reader33Views0likes2CommentsMacro for overdue expense card reports
Hi. I am trying to figure out a macro that will allow me to use data provided to create a system that allows me to see people who are late submitting their expense card reports. I would like to break it down so that I can see those who are 30, 60, and 90 days past due on submitting their reports. If there is anyone out there that can help me to automate this system rather than manually entering it I would greatly appreciate it. Thank you and have a nice day.nleydig9May 21, 2025Occasional Reader41Views0likes3CommentsNo access to group/ungroup dates in Pivot Table filter. Jan-24 and Jan-25 show as Jan only.
I'm trying to follow instructions I found for grouping/ungrouping dates on a Pivot Table filter. Using 365 (desktop app and web based housed on Sharepoint Cloud) The dates on my column are formatted as Date='Mar-12', so when I type in Jan25, it converts to 1/25/2025 but displays Jan-25. The day of the week doesn't matter, just Month and Year. Adding that column to the Pivot table as filter, shows... <12/1/23 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec >3/2/2025 I have data for Jan-24 and Jan-25, but they are lumped together. There is no option to right-click on the dates displayed within the Pivot Table Filter. What am I missing? Thanks!SolvedMarcus_BoothMay 21, 2025Brass Contributor63Views0likes2Commentsinclude a static number when a cell has an entry
Hi all. I am setting up a spreadsheet to tally entry fees for a clinic and show (horse industry). There is a $20 arena charge for those attending the show only. I have a column for attending the show but only want the arena charge to be included when there is something in that column. The column in question is D, I've totaled the cost columns in C, E, G with the total in H where I add the $20. Would the 20 be better added in E but only if there is a number in D? what would be the formula? B C D E F G H I J Andrews, Susan 2 =B3*200 3 =D3*30 3 =F3*25 =C3+E3+G3+20 =H3-I3 Barz, Janica 2 =B4*200 4 =D4*30 6 =F4*25 =C4+E4+G4+20 =H4-I4 Bowman, Bonnie 2 =B5*200 3 =D5*30 3 =F5*25 =C5+E5+G5+20 =H5-I5SolvedpevendenMay 21, 2025Copper Contributor23Views0likes2CommentsSum from cell across multiple sheet, depending on hire date
I can not figure this out, I am trying to make a summary sheet that will count the vacation days across multiple sheets from "Start" to "All" (these are timesheets between those named sheets) for employees. But I need the count to reset on their hire anniversary month and day. Employee 1 - Hired on 1/2/2001 (found in cell B5 on the sheet named "Summary") Employee 2 - Hired on 4/9/2020 (found in cell B6 on sheet named "Summary") In this example, any vacation days in cell F5 (employee 1) across multiple sheets between sheets named "Start" to "All" will count until the anniversary month and day arrives, then it will reset and start counting forward again until that date arrives again. Any help will be much appreciated!SolvedLisaB1009May 21, 2025Copper Contributor250Views0likes12CommentsExcel
Português (BR): Estou enfrentando um problema persistente na padronização de dimensões de ilustrações, imagens e pictogramas no Excel. Mesmo ao tentar definir uma altura padrão (ex: '1.4' cm para uma ilustração de hexágono) no campo 'Altura' da guia 'Formato da Forma', duas figuras diferentes, com ambas selecionadas (Segurando Ctrl), resultam com tamanhos divergentes (ex: 1,38 cm e 1,36 cm), em vez do valor exato digitado (1,4 cm). Já verifiquei as propriedades, incluindo a fixação da taxa de proporção, e tentei soluções como copiar/colar e reiniciar o Excel, sem sucesso. O mais intrigante é que, por um breve período, consegui padronizar as dimensões corretamente, mas o problema retornou inexplicavelmente, mesmo no mesmo arquivo. Suspeito de alguma configuração ou atalho que possa estar interferindo. Percebi que isso não acontece, por exemplo, no PowerPoint, apenas no excel. Gostaria de saber se possuí algum tipo de configuração específica para não ocorrer esse ajuste/arredondamento automático no Excel. E gostaria de uma solução eficaz para garantir que todas as ilustrações selecionadas mantenham o tamanho exato que digito.JPMCA005May 21, 2025Occasional Reader7Views0likes0Comments
Resources
Tags
- excel42,718 Topics
- Formulas and Functions24,783 Topics
- Macros and VBA6,422 Topics
- office 3656,055 Topics
- Excel on Mac2,659 Topics
- BI & Data Analysis2,382 Topics
- Excel for web1,929 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,647 Topics