User Profile

Detlef_Lewin

Silver Contributor

Joined 10 years ago

2696 Posts532 Likes349 Solutions

View All Badges

User Widgets

Recent Discussions

Re: Controlling Formula Output in Excel Based on Cell Entry
=IF(A2="","",B1+25-A2)
Dec 07, 2025 Place Excel
5Views
1like
0Comments
Re: formula Excel help
=TEXTJOIN(" ",TRUE,Import!F2:H2)
Dec 05, 2025 Place Excel
26Views
0likes
0Comments
Re: Why is my =SUM equation not giving the correct total?
Your fomula adds A9*5 to every value in A1:A8. So, it is either one of these two: =SUM(A1:A8)+A9*5 =SUM(A1:A8;A9*5)
Dec 04, 2025 Place Excel
30Views
1like
0Comments
Re: Table merge no option in PQ
I guess you want to append the tables rather then merging them.
Dec 04, 2025 Place Excel
54Views
0likes
1Comment
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
72Views
0likes
0Comments
Re: Calculate Days in between Dates
=NETWORKDAYS(E68,D68,$L$6:$L$34)-1
Sep 24, 2025 Place Excel
52Views
0likes
0Comments
Re: Question on Sumifs
Remove the merged cells. Then it will become clear.
Sep 23, 2025 Place Excel
59Views
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
52Views
0likes
0Comments
Re: IF Statement Problem
=IF(NOT(OR(D21:D23)),0,D17-(D17*C24))
Sep 16, 2025 Place Excel
95Views
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
85Views
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
81Views
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
55Views
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
124Views
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
130Views
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
56Views
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
54Views
0likes
2Comments
Re: Lookup 2 values
Use COUNTIFS() or a pivot table.
Jul 29, 2025 Place Excel
70Views
0likes
0Comments
Re: Name seperation
I used Flash Fill on you sample data and it worked 100%.
Jul 25, 2025 Place Excel
80Views
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
75Views
0likes
0Comments
Re: Irregular date calculations in large spreadsheet
Either H11498 or D11498 is text. Check with ISTEXT().
Jul 10, 2025 Place Excel
85Views
0likes
2Comments

Recent Blog Articles

No content to show