Forum Widgets
Latest Discussions
Series fill a formula down a column automatically skipping a set number of rows
I am trying to fill a formula down a column every 6th row but incrementing the variable in the formula ($A2) for each entry. The formula uses the Take command and inputs 5 rows of data, so to keep it from "spilling" I need the formula to increment every 6 rows, having one blank row between each section. I have been able to accomplish "copying" it each 6th row with VBA #1 and filling the series with VBA #2 but can't figure out how to combine the two. Any help would be appreciated. VBA #1: Sub FillEvery6thCell() Dim ws As Worksheet Dim startRow As Long, lastRow As Long, col As String Dim formulaText As String Dim r As Long ' Set your sheet and parameters Set ws = ThisWorkbook.Sheets("Top 5 Employees") col = "A" ' Column to fill startRow = 10 ' First row to start filling lastRow = 60000 ' Last row to fill ' Get the formula from the starting cell formulaText = ws.Range(col & startRow).Formula ' Fill every 6th cell For r = startRow + 6 To lastRow Step 6 ws.Range(col & r).Formula = formulaText Next r Range("A2:A60000" & iRow).Replace What:="@", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False, FormulaVersion:=xlReplaceFormula2 MsgBox "Formula copied to every 6th cell in column " & col End Sub VBA #2 Sub FillFormulasDown() Dim sourceCell As Range Dim fillRange As Range ' Define the cell containing the formula Set sourceCell = Range("A2") ' Define the target range Set fillRange = Range("A2:A5000") ' Fill formulas down sourceCell.AutoFill Destination:=fillRange, Type:=xlFillSeries End Subsort by column then by numbers in a row
HI all I have a table of results pictured here. Once the results are in, I sort the table by the Total Score Column. When we have a tie (as in line 3 & 4, I need to sort by who has the most highest score... so, who has the most 9 (equal here), then by most 8.5 (line 4 wins the tiebreaker, 4 over 2) Can I do this so it doesn't affect the order of the columns but just the rows involved.
Regarding the filter by condition option in pivot table in the excel
I'm taking Google Data analytics course in the coursera, there they use filter in the pivot table and apply conditions like, less than or greater than, they were using the Google sheets, and I couldn't find that option in the excel, you can select or unselect the value in the filter but there's no option to apply conditions like lesser than or greater than such value. Is there any way you guys know, from which you filter the fields by conditions, please let me know.Excel table not using updated formula in new rows
I have an Excel spreadsheet that keeps giving me the same issue with the formulas in column O. Originally, column O contained the following formula: Original formula: =IF(R4<>"", R4, Q4) + IF(ABS(I5-I4) < 30, 25/1440, IF(ABS(I5-I4) <= 50, 40/1440, IF(ABS(I5-I4) <= 150, 60/1440, IF(ABS(I5-I4) <= 250, 80/1440, IF(ABS(I5-I4) <= 300, 100/1440))))) The formula has since been updated to: Current formula: =IF(R4<>"", R4, Q4) + IF(ABS(I5-I4) < 30, 25/1440, IF(ABS(I5-I4) <= 50, 40/1440, IF(ABS(I5-I4) <= 150, 60/1440, IF(ABS(I5-I4) <= 250, 80/1440, IF(ABS(I5-I4) <= 300, 100/1440))))) + C5/24 However, whenever I insert a new row, Excel automatically fills it with the original formula instead of the updated one, even though I have been using the updated formula for quite some time now. How can I make Excel recognize and use the updated formula when new rows are inserted?
Excel 365: Unexpected Predictive Behaviour Causing Retroactive Cell Changes in Structured Dataset
Hi everyone, I’m posting this to share an unusual and potentially important issue I encountered in Excel 365 this morning. I’ve already submitted a detailed report to Microsoft via the Feedback Hub, but I felt it would be useful to document it here for visibility and to see whether anyone else has experienced something similar. While entering data into a structured table (a parts‑catalogue workbook), Excel began exhibiting behaviour that did not match Flash Fill, AutoFill, or the standard predictive typing feature. Specifically: Grey predictive text appeared beyond the cursor and extended into cells below the active cell Excel began rewriting previously validated cells in the same column Each time I pressed Enter, Excel updated earlier rows based on its latest inferred pattern Attempts to correct earlier rows caused further cascading changes Undo did not revert all changes The behaviour resembled an AI‑style inference engine trying to “learn” my pattern, becoming progressively more confused This was not the normal predictive typing behaviour (which only shows grey text inside the active cell and does not affect other cells). The behaviour stopped only after I clicked the Flash Fill button twice, which suggests an internal state reset. I’m not seeing the issue now, and other workbooks behaved normally, so this appears to have been a transient internal mode rather than a persistent setting. I’m sharing this here because: it caused silent data corruption in a structured dataset it may indicate an experimental feature or feature‑flag activation others working with structured data may want to be aware I’d be interested to know if anyone else has seen similar behaviour If helpful, I can provide the reproduction steps, screenshots, and the engineering‑style report I submitted to Microsoft. Thanks, JohnForcing Gridlines to print through shaded cell formatting
I know how to force gridlines to print but if any cells are formatted with a fill shading in them, the gridlines will not print through them. Is there a way to print gridlines in formatted cells which are filled? No gridlines will print through the shaded cells.
Excel Find / Command-F crashing on Mac Tahoe (Office 2019 / Excel 16.78) – anyone else?
Excel Find / Command-F crashing on Mac Tahoe (Office 2019 / Excel 16.78) – anyone else? Mac mini + Tahoe 26.5. Excel 16.78 (Office Home & Student 2019). Problem started after recent Tahoe update. Classic Find is behaving badly and often crashes Excel. Workflow: click/select a column Edit → Find → Find… or Command-F search for text or email fragments (ex: "kristin" or part of an email) Excel may crash or Find becomes unusable Things already tried: full Excel reinstall blank workbook test new macOS test user Office container reset / plist tests preference resets same Tahoe version confirmed Upper-right Microsoft Search appears, but that is not equivalent to classic worksheet Find for email-column workflow. Question: Is this a known Tahoe / Excel 16.78 Find bug or Search-routing issue? Has anyone fixed this or seen it resolved with a newer Excel build or update?Recurring issue I'm experiencing with charts that are moved to a dedicated chart sheet.
This is also happening to my students in my Excel for Agriculture courses: they send me their assignments, and while the charts look perfectly fine in older versions of Excel, in my Excel 365 I cannot see them properly. As a test, I even opened files that were working perfectly just a week ago, and now my own charts appear exactly like the image I attached. Needless to say, these are not corrupted files, the data source is fully verified, and everything else is in order. The only workaround I found was to insert a new regular worksheet, move the charts to that sheet (where they display correctly), and then move them again to a new chart sheet. After doing that, they look fine again, just as before. Before anyone asks the obvious questions: I have written four Excel books and have been teaching Excel for Agriculture for 20 years, and this is the first time I’ve ever seen something like this. I urgently need a solution. At this point, it makes no sense to keep paying for a Microsoft 365 subscription if this continues to happen. Please, if possible, translate any replies into Spanish. Thank you!
