User Profile

Detlef_Lewin

Silver Contributor

Joined Jul 16, 2016

2705 Posts538 LikesLikes received350 Solutions

View All Badges

User Widgets

Recent Discussions

Re: PLEASE HELP ME. Excel Time Formatting Not Working?
Why choose h:mm when you want to key in minutes and seconds? Set hh:mm:ss and key in 0:28:44 and 0:20:0.
Jan 09, 2026 Place Excel
63Views
1like
0Comments
Re: Simplifying cost calculation using array instead of IF statement
I wasn't refering to A1:E10 but to H:M.
Dec 30, 2025 Place Excel
38Views
0likes
0Comments
Re: Simplifying cost calculation using array instead of IF statement
I wonder if your logic is correct. In P4 (Ag) you are getting the values attributed to Ag (J4/J8). That seems okay. In Q4 (Au) you are getting the values attributed to Ag (J4) and Au (J8). That seems not okay. Your mixing values from Ag/Au. In R4:V4 you are getting the values attributed to Ag (J4). That seems not okay. The processes are not related to Ag specifically.
Dec 30, 2025 Place Excel
52Views
0likes
2Comments
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
147Views
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
85Views
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
140Views
0likes
3Comments
Re: "Getting Name" bug on my worksheet
Yes, it may be a bug related to this feature.
Dec 12, 2025 Place Excel
148Views
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
87Views
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
199Views
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
37Views
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
49Views
1like
0Comments
Re: Table merge no option in PQ
I guess you want to append the tables rather then merging them.
Dec 03, 2025 Place Excel
106Views
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
57Views
0likes
0Comments
Re: IF Statement Problem
=IF(NOT(OR(D21:D23)),0,D17-(D17*C24))
Sep 16, 2025 Place Excel
102Views
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
92Views
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
85Views
1like
0Comments

Recent Blog Articles

No content to show