User Profile
Detlef_Lewin
Silver Contributor
Joined Jul 16, 2016
User Widgets
Recent Discussions
Re: How XLOOKUP arguments apply in this case
MollyKitti Here is my solution. If there are ties then make sure there are enough empty cells below the formula. =LET( data,B2:AF13, columns,COLUMN(data)-1, rows,ROW(data)-1, year,A1, searchvalue,MAX(data), matches,(data=searchvalue)*(rows+columns%%), matches_list,TOCOL(matches), filtered_matches,FILTER(matches_list,matches_list>0), matches_count,COUNT(filtered_matches), months,QUOTIENT(+filtered_matches,1), days,MOD(filtered_matches,1)*10^4, years,WENN(SEQUENCE(matches_count),year,0), result,DATE(years,months,days), result)26Views0likes0Comments- 50Views0likes0Comments
- 49Views0likes0Comments
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.56Views0likes2Comments
Recent Blog Articles
No content to show