Forum Widgets
Latest Discussions
How to filter to include blanks without selecting blanks.....
Good Morning All, I have a spreadsheet on Excel Online version that people fill in for requesting PPE and it has drop down boxes so they can select what they need. The people filling it in are not the most knowledgeable with computers never mind Excel just FYI for context. When the spreadsheet gets filtered eg to show only the requests for Bob, it shows the items for Bob and then the row underneath is row 532 which is outside my data and therefore the drop down boxes do not show so when someone comes to fill it in they can't select what they want to order and just end up free typing which defeats the object and means things can get missed. I want to be able to filter the spreadsheet in any column EG Bob so it shows the items for Bob and then the next row is the next 'available' row which in this example would be row 23 but also people are filling this in daily so row 23 is not set. Tomorrow it will have more data in and the next 'available' row could be row 30 so obviously tomorrow I would like to be able to filter to Bob, see all of Bobs items and then the next row showing is row 30. This is a test doc: https://1drv.ms/x/c/15153d41767146da/IQDVK5iPAiw-SoUyrf9ciYdwAb76zwpiF-IAtr6ISry1KwQ?e=v4vo3C Hope that makes sense and hopefully I am not asking for the impossible! Many Thanks,Excel 365: dd-mmm-yyyy now gives Sept instead of Sep
Excel 365: dd-mmm-yyyy now gives Sept instead of Sep — that breaks the documented format standard. Who thought this was a good idea? They linked it to the Unicode locale standard. But it violates the formatting of "mmm". Work arounds for USA locale format as [$-409]dd-mmm-yyyy → 05-Sep-2025 UK locale [$-809]dd-mmm-yyyy → 05-Sep-2025 AU [$-C09]dd-mmm-yyyy → 05-Sep-2025 NZ [$-1409]dd-mmm-yyyy → 05-Sep-2025 Problem is this is not portable. PLease can someone reach out to the devs and get this reverted? Formulas trying to pick out Sep & year from the string now will break.
How to add a new month to the existing bar graph?
Question: How to add a new month to the existing bar chart? I have 3 rows. Oct 2025, April 2026, May 2026 The headings are: Month, Start Value, End Value, Change The bar chart has the 3 start values and then the 3 end values then the 3 change I added a 4th row and the formulas and they change values as they should. The June values are just dummy values. But I do not know how to add the 4th month to the existing bar chart that updates as well. I can create a new one but then I have to re-create the chart details.
Names in Excel Name Manager
I have a spreadsheet ( I will call it spreadsheet "A") driven by macros that creates a new worksheet each month. I am developing a second spreadsheet I will call it spreadsheet "B") that links to it for a monthly summary. I have given all the cells names that are to be linked. The issue I am dealing with is when a new monthly tab is created on "A", I want the links from "B" to be updated to the new month. The approach I am taking is to delete all of the names in "A" and recreate them for the new month. (The reason I want to delete the older names is because over time, the Names list would grow into a very large list of obsolete names). The problem I am encountering is that when a name is deleted, a dialog box appears that the user has to acknowledge that, Yes, I want to delete this name. I want to make this process transparent to the user. So, my question is: Can I delete a name without generating this dialog box?Formulas Not Calculating in Workbook
Hello, I have a very large workbook with many formulas across different sheets. I currently have this workbook set to manual calculations only. And it is saved in a Sharepoint Directory with autosave enabled. When the source data for this workbook is updated. None of the formulas are updating when 1. The Calculate Now button is pressed. 2. The workbook is set back to automatic calculation. 3. When the work book is manually saved and closed. I have noticed another issue. When I go to File > Options. The Options dialogue never appears. I am wondering if anyone else have experienced this issue, and if so have been able to successfully troubleshoot the problem?
Help calculating a date, excluding weekends and US holidays
Hello - I am trying to fix an old IF statement to show a business day Work day. The current IF statement "=IF(WEEKDAY(NOW())=2,NOW()-3,NOW()-1))" still works except for US holidays, so we had a calendar popup to choose the correct date when there was a US holiday. The calendar popup doesn't work now due to an upgrade of Microsoft 365 to 64-bit. I tried updating the IF statement to a Workday IF statement and used a table "Holidays" listing the US holidays, but it isn't working. Any thoughts?
BYROW/BYCOL/MAP Variants for Nested Arrays + BENCHMARK
Hey everyone! I made some simple BYROW, BYCOL, and MAP variants that can return nested arrays, and I also made a BENCHMARK function for performance testing. Here's some code for testing: BYROW⊟ = LAMBDA(array, function, [orient], LET( me, LAMBDA(me, seg, LET( n, ROWS(seg), IF( n = 1, function(seg), IF( orient, HSTACK( me(me, TAKE(seg, INT(n / 2))), me(me, DROP(seg, INT(n / 2))) ), VSTACK( me(me, TAKE(seg, INT(n / 2))), me(me, DROP(seg, INT(n / 2))) ) ) ) ) ), IFNA(me(me, array), "") ) ); I didn’t put a huge amount of effort into polishing this but In my tests on my device, these performed a lot better than using REDUCE + VSTACK for the same kind of thing, so maybe it’ll be useful to someone. Really curious to see how people use it, and if something looks like it should be optimized or changed, say so. I'll update them regularly, fix bugs whenever I can. You can find the rest of them on my Gist pages: https://gist.github.com/Medohh2120/f565516bc636700adf5ba27fd8f0d19e, https://gist.github.com/Medohh2120/d9d04f56d93694aed9d0c49d516f0fbf.
EXCEL SE HA QUEDADO SIN RECURSOS
Hola buenas tardes. Desde hace unos días, cada vez que quiero introducir cualquier cambio en una hoja de Excel, me aparece el mensaje: "Excel se ha quedado sin recursos al intentar calcular una o varias fórmulas. Como resultado, no pueden evaluarse estas fórmulas. Para obtener más información, haga clic en Ayuda." El problema es que no sé cómo encontrar la fórmula o fórmulas que pueden tener algún error para corregirlas, y por tanto no sé cómo solucionar el problema. Gracias de antemano y reciban un cordial saludo.
Dragging and copying a formula
Hi, hoping someone can figure this out. I am trying to copy down a % increase - its a long list but it will not copy down. I have gone into automation and that is ticked, also file options advanced and ensured all that is ticked but still nothing it just gives random numbers. Hoping you can help. Thanks
Combinar correspondencia ahora que han desaparecido los DDE con resultados con solo dos decimales
Buenos días: antes combinaba correspondencia de un word con un excell, para hacer mis facturas mensuales con DDE, pero ahora esa opción ha desaparecido y cuando combino me salen muchísimos decimales. He aplicado el formato directamente en Word modificando el campo de fusión con un cambio de formato numérico (por ejemplo, \# "#,##0.00" para forzar dos decimales), pero sigue sin hacérmelo... alguna idea para poder fijar solamente dos decimales en el excell para que los resultados de la combinación en word den solo 2 decimales?
