User Profile

Detlef_Lewin

Silver Contributor

Joined 10 years ago

2692 Posts530 Likes348 Solutions

View All Badges

User Widgets

Recent Discussions

Re: Agent Mode continuously loading
Probably everyone on this side of the universe is trying to test 'agent mode' right now. And the servers can't handle it.
Oct 06, 2025 Place Excel
32Views
0likes
0Comments
Re: Calculate Days in between Dates
=NETWORKDAYS(E68,D68,$L$6:$L$34)-1
Sep 24, 2025 Place Excel
37Views
0likes
0Comments
Re: Question on Sumifs
Remove the merged cells. Then it will become clear.
Sep 23, 2025 Place Excel
50Views
0likes
0Comments
Re: IF Statement Problem
The layout doesn't match your formula. It also lacks column and row headers. And if every value is 0 then subtracting and multiplying does not change anything. Please provide a workbook with a meaningful explanation.
Sep 18, 2025 Place Excel
41Views
0likes
0Comments
Re: IF Statement Problem
=IF(NOT(OR(D21:D23)),0,D17-(D17*C24))
Sep 16, 2025 Place Excel
84Views
0likes
0Comments
Re: Time-Axis doubt
Go to Insert > PivotTable. In the "Create PivotTable" dialog box, select your table range and be sure to check the box that says "Add this data to the Data Model" before clicking OK. (Copied from a chatbot answer)
Sep 03, 2025 Place Excel
75Views
1like
0Comments
Re: Time-Axis doubt
The values in your pivot table are all 0. It seems that a regular pivot table cannot deal with that small numbers. Try a data model pivot table instead. It works for me.
Sep 03, 2025 Place Excel
76Views
1like
0Comments
Re: Dash (-)is not recognized in cell
Maybe it is not a dash but a similar character. Check with UNICODE(). It should be 45.
Aug 18, 2025 Place Excel
51Views
0likes
0Comments
Re: What does this indicate?
That indicates a value from an Excel datatype. It is one of these silent 'updates'.
Aug 09, 2025 Place Excel
109Views
1like
1Comment
Re: How to sum columns and cells with dates and simple criteria?
Why don't you use a pivot table?
Aug 08, 2025 Place Excel
98Views
0likes
1Comment
Re: Vlookup problems
If you would use formatted Excel tables and structured reference in the formulas then there won't be a problem with a too small data range. The ranges will expand automatically.
Jul 30, 2025 Place Excel
49Views
0likes
0Comments
Re: Vlookup problems
My solution. =MAX(0,SUM(XLOOKUP(B2,'22GP Raw data'!$A$2:$A$5,'22GP Raw data'!$D$2:$E$5,0)*{1,-1}))
Jul 30, 2025 Place Excel
48Views
0likes
2Comments
Re: Lookup 2 values
Use COUNTIFS() or a pivot table.
Jul 29, 2025 Place Excel
63Views
0likes
0Comments
Re: Name seperation
I used Flash Fill on you sample data and it worked 100%.
Jul 25, 2025 Place Excel
74Views
1like
0Comments
Re: Irregular date calculations in large spreadsheet
The output of ISTEXT() is either TRUE or FALSE not "dates".
Jul 11, 2025 Place Excel
64Views
0likes
0Comments
Re: Irregular date calculations in large spreadsheet
Either H11498 or D11498 is text. Check with ISTEXT().
Jul 10, 2025 Place Excel
77Views
0likes
2Comments
Re: How can this be resolved?
Stale Value Formatting
Jul 10, 2025 Place Excel
43Views
0likes
0Comments
Re: Counting text only once within date range
=IF(SUM(--(YEAR(Tabelle1[Year Contracted])=2024))=0,"nothing",COUNTA(UNIQUE(FILTER(Tabelle1[Clinical Area],YEAR(Tabelle1[Year Contracted])=2024)))) Or you could do it with a pivot table (distinct count). https://www.excelcampus.com/pivot-tables/distinctcount-pivot-tables/
Jul 04, 2025 Place Excel
58Views
0likes
0Comments
Re: The Dreaded "Duration" bug
Hi Any duration greater 23:59:59 will be displayed as a date-time format in the formula bar.
Jun 13, 2025 Place Excel
81Views
0likes
1Comment
Re: Organisation Linked Data Type not working
Better to use the feedback portal.
Jun 10, 2025 Place Excel
57Views
0likes
0Comments

Recent Blog Articles

No content to show