User Profile

Detlef_Lewin

Silver Contributor

Joined 10 years ago

2688 Posts530 Likes347 Solutions

View All Badges

User Widgets

Recent Discussions

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
15Views
0likes
0Comments
Re: IF Statement Problem
=IF(NOT(OR(D21:D23)),0,D17-(D17*C24))
Sep 16, 2025 Place Excel
61Views
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
59Views
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
64Views
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
48Views
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
102Views
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
90Views
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
41Views
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
44Views
0likes
2Comments
Re: Lookup 2 values
Use COUNTIFS() or a pivot table.
Jul 29, 2025 Place Excel
59Views
0likes
0Comments
Re: Name seperation
I used Flash Fill on you sample data and it worked 100%.
Jul 25, 2025 Place Excel
71Views
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
54Views
0likes
0Comments
Re: Irregular date calculations in large spreadsheet
Either H11498 or D11498 is text. Check with ISTEXT().
Jul 10, 2025 Place Excel
72Views
0likes
2Comments
Re: How can this be resolved?
Stale Value Formatting
Jul 10, 2025 Place Excel
39Views
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
54Views
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
75Views
0likes
1Comment
Re: Organisation Linked Data Type not working
Better to use the feedback portal.
Jun 10, 2025 Place Excel
53Views
0likes
0Comments
Re: Pivot Not Grouping
SergeiBaklan texts will be trimmed automatically while loading to data model, thus no additional actions are required I didn't know that. Is this docmented somewhere?
Apr 30, 2025 Place Excel
67Views
0likes
1Comment
Re: Complex sum function
Please provide a sample workbook with the desired ouput.
Feb 27, 2025 Place Excel
59Views
1like
0Comments
Re: functions in power query do not work
Try closing the PQ window and open it again. If that does not help close Excel and open it again.
Feb 06, 2025 Place Excel
123Views
0likes
1Comment

Recent Blog Articles

No content to show