User Profile

Detlef_Lewin

Silver Contributor

Joined 10 years ago

2702 Posts537 Likes350 Solutions

View All Badges

User Widgets

Recent Discussions

Re: Index and match mystery (for me that is...)
=INDEX(C21:C36;MATCH(C48;A21:A36);1) or =XLOOKUP(C48;A21:A36;C21:C36;;-1;1)
Dec 26, 2025 Place Excel
76Views
0likes
0Comments
Re: Finding time duration between a start date & time with end date & time
Please provide a sample workbook with the expected results.
Dec 18, 2025 Place Excel
71Views
0likes
1Comment
Re: Finding time duration between a start date & time with end date & time
=MOD(enddate+endtime-(startdate+starttime),1)
Dec 15, 2025 Place Excel
119Views
0likes
3Comments
Re: "Getting Name" bug on my worksheet
Yes, it may be a bug related to this feature.
Dec 12, 2025 Place Excel
95Views
1like
0Comments
Re: Advanced Excel Formula discussion - Problem with dynamic range
Instead of CHOOSECOLS(E2:E5,1) it also works with +E2:E5 or T(E2:E5) or E2:E5&"". XLOOKUP() is expecting a single cell/value and using a range would not work, but using an array does.
Dec 12, 2025 Place Excel
82Views
1like
0Comments
Re: "Getting Name" bug on my worksheet
It could be Excel trying to retrieve the user name of the person who is operating/editing in this cell.
Dec 12, 2025 Place Excel
134Views
2likes
0Comments
Re: Controlling Formula Output in Excel Based on Cell Entry
=IF(A2="","",B1+25-A2)
Dec 07, 2025 Place Excel
62Views
2likes
0Comments
Re: formula Excel help
=TEXTJOIN(" ",TRUE,Import!F2:H2)
Dec 05, 2025 Place Excel
36Views
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
47Views
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
101Views
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
77Views
0likes
0Comments
Re: Calculate Days in between Dates
=NETWORKDAYS(E68,D68,$L$6:$L$34)-1
Sep 24, 2025 Place Excel
54Views
0likes
0Comments
Re: Question on Sumifs
Remove the merged cells. Then it will become clear.
Sep 23, 2025 Place Excel
61Views
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
55Views
0likes
0Comments
Re: IF Statement Problem
=IF(NOT(OR(D21:D23)),0,D17-(D17*C24))
Sep 16, 2025 Place Excel
100Views
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
88Views
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
83Views
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
69Views
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
131Views
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
142Views
0likes
1Comment

Recent Blog Articles

No content to show