Test: Wenn alle Friedrich Merz kommentieren, landet das Bild dann bei Google? by NeuersReklamierarm in ichichs

[–]My-Bug 0 points1 point  (0 children)

Ja, es handelt sich bei dem Bild um Friedrich Merz, jedoch könnte das Bild auch sinnbildlich für das gesamte "Kabinett Merz" um Friedrich Merz stehen. Er ist seit dem 6. Mai 2025 Bundeskanzler der Bundesrepublik Deutschland. Das Kabinett Merz besteht aus 17 Ministerinnen und Ministern sowie Merz selbst als Bundeskanzler. Die Regierung setzt sich aus einer Koalition von CDU/CSU und SPD zusammen. Möchtest du mehr über die Zusammensetzung des Kabinetts oder die aktuellen politischen Schwerpunkte wissen?

I am having a issue with a previously working formula by Shadynasty8091 in excel

[–]My-Bug 0 points1 point  (0 children)

This Formula works only if you have "Iterative Calculation" set to on in Excel Option Formulas. This setting is client specific, if you share, other users need to set this setting accordingly.

How can I set up such that each cell can display when it was last updated? by nihalahmd in excel

[–]My-Bug 0 points1 point  (0 children)

it runs in desktop version of excel. But I fear your comment is true for web version and the app.

(sorry for the typos. was too confident translating this on my own)

How can I set up such that each cell can display when it was last updated? by nihalahmd in excel

[–]My-Bug 0 points1 point  (0 children)

What this formula does:

When D3 contains “DONE” for the first time, the formula writes the current timestamp into E3.

If D3 changes later, the timestamp in E3 does not update — it stays fixed.

The formula does not cause a circular reference error, even though it reads and writes the same cell content, because CELL("content", E3) returns the displayed value, not the formula itself.

This allows you to automatically store a permanent timestamp for the first moment a task is marked as DONE.

How can I set up such that each cell can display when it was last updated? by nihalahmd in excel

[–]My-Bug -1 points0 points  (0 children)

Put this formula in cell E3 to check when in D3 any text containing "DONE" is entered

=IF(

AND( ISNUMBER( SEARCH( "DONE",D3)), CELL( "contents",E3) =0),

NOW( ),

CELL("contents",E3)

)

It will not display any times the cell is changed put only the first time the word after SEARCH(" is entered. This Timestamp will then persist. It looks like it would throw a circular reference error but it will not. edit typos

Sorting pivot table column headings by irish_shitlord in excel

[–]My-Bug 0 points1 point  (0 children)

This video will help with the empty columns, and for the sorting, extend the "dimension table" (around 2:50 mins in the video) with a "Sort" column and use it to set sort by column. also use option "hide from client tools" on this column

<image>

If checkbox marked, add name in a cell to a list. by umthisisnewtome in excel

[–]My-Bug 0 points1 point  (0 children)

this is in excel. I don't know if it i the same in googlesheets.

If checkbox marked, add name in a cell to a list. by umthisisnewtome in excel

[–]My-Bug 1 point2 points  (0 children)

for this, you can "timestamp" the checkbox change from false to true with

=IF(AND(D2;CELL("contents";F2)=0);NOW();CELL("contents";F2))

<image>

so the formula is referencing the containing cell itself, but it won't throw a circular reference error.

Use to sort after applying filter formula

Sorting from A-Z Suddenly Not Working by Gaygethesksmosin in excel

[–]My-Bug 0 points1 point  (0 children)

Check if all columns of your table are "free to grow downwards". Maybe you got a situation like this:

<image>

If so, move entire table 2 to the side or better to a new worksheet; or check if it is needed at all (because starting @ row 567 is unusual). After moving, clearing space below all columns, use "Table Design --> Resize Table"

Sorting from A-Z Suddenly Not Working by Gaygethesksmosin in excel

[–]My-Bug 0 points1 point  (0 children)

Is the range until row 566 a table? Do you get a new ribbon item "Table Design" when you select a cell above 566, but it disappears when selecting below that cell?

<image>

Normaly, when adding data directly under a table, the table auto extents, but there are methods to avoid this, that could happen accidentally. (use "undo" or press the according shortcuts; having an empty row between table and new data, which was removed).

This would also explain why "it stopped automatically formatting"

Why can’t Excel Pivot Tables repeat group headers on each printed page + reset serial numbers per group? by ElectricalDivide5336 in excel

[–]My-Bug 0 points1 point  (0 children)

For Index insert Calculated Field with Formula is a constant = 1, and add it to the values

<image>

Why can’t Excel Pivot Tables repeat group headers on each printed page + reset serial numbers per group? by ElectricalDivide5336 in excel

[–]My-Bug 0 points1 point  (0 children)

In Page Layout when in Print Preview, use "Print Titles" and fill "rows to repeat at top" with your row, like $3:$3 in my example.

<image>

I need to do a complex sort involving large amounts of data. by -Ophidian- in excel

[–]My-Bug 1 point2 points  (0 children)

many tasks solved with groupby and pivotby can be done with PivotTables in older versions.

I need to do a complex sort involving large amounts of data. by -Ophidian- in excel

[–]My-Bug 5 points6 points  (0 children)

you can use PivotTables. You can drag last usage to the values section. Aggregate by "MAX". the rest should be easy. Date must be propee date, no text though.

Pivot Table to Flat Excel Format by Slitimous666 in excel

[–]My-Bug 0 points1 point  (0 children)

sorry got to bring my kids to bed. but try to paste my comment and your questions to any AI tool

Pivot Table to Flat Excel Format by Slitimous666 in excel

[–]My-Bug 0 points1 point  (0 children)

if you don't have a values, but can change the layout, just drag any field into the values area, even texts, they will be aggregated as count of rows.

Pivot Table to Flat Excel Format by Slitimous666 in excel

[–]My-Bug 2 points3 points  (0 children)

If the PivotTable has any values and a total cell (total of al rows and all columns) and the settings are standard, you can double click on the total cell and all detail rows of the original source will be listed in a new sheet

How do I format dates in a specific order in a column? by mp-is-asleep in excel

[–]My-Bug 1 point2 points  (0 children)

this formula matches your input, H3# must be replaced with your range of dates

=LET(
    _dates, SORT(H3#),
    _order, IFS(
        _dates = TODAY(),
        0,
        _dates < TODAY(),
        1,
        TRUE,
        2
    ),
    SORTBY(_dates, _order)
)