User Profile
Harun24HR
Bronze Contributor
Joined Nov 07, 2020
User Widgets
Recent Discussions
Re: Cell drop list of workbook sheets
Use the following formula to a name manager then use that name to data validation list. =TOCOL(TEXTAFTER(GET.WORKBOOK(1)&T(NOW()),"]")) See the below article for more details. https://techcommunity.microsoft.com/discussions/excelgeneral/rename-cell-to-various-different-sheet-titles/4430814/replies/4431560Re: Using a combination of IF Statement and LET function
Do you mean date range to ignore or just those two dates? To ignore two date range try- =IF(AND(A2>=$G$3,A2<=$G$2),"Ignore",LET(x,"Your formula here",x)) To ignore only those two date, try- =IF(OR(A2=$G$2,A2=$G$3),"Ignore",LET(x,"Your formula here",x))Re: name manager rejecting lambdas
What is LET(...) here? May be issue with LET functions parameters. Below formula works fine with name manager. For a simple calculation I have just used SUM() inside LET() function. =LAMBDA(array,slice1,[index1],[return_index_slice2],[index2],[return_index],[if_not_found],[logic],[headers],[function],LET(x,array,y,slice1,SUM(x,y)))
