Please see my example. It may already be working. =XLOOKUP(TRUE,ISNUMBER(XMATCH("*"&B$2:B$14&"*",A2,2)),B$2:B$14,"")
I added the use of INDIRECT to reference the DateInput cell (for me always 1 or 2 cells left of the formula) to reduce potential for mishaps when copy/pasting the formula. I also changed the name of dscheikey's "in" to "YEARCOL" for my easier understandin...
Edge Not Opening Websites Edge not updating its Enterprise Mode site list Edge Opening New Window Instead of a New Tab Edge PDF viewer doesn't work as expected when open a PDF with check box that have same "Name" and Different "Export value" EDGE returns Bing search results instead of na...
How to Check for Null Values in CSV File for Creating New-ADUsers Script? How to check for specific event log How to check if a service exists or not, if exists start the service using powershell How to check if a service is disabled? How to check if a user has permissons on a f...
I know some formulas but within the month they are all activated at the same time including Saturday and Sunday, I would like them to be activated only on the day worked. please i hope can you help me with that
Please try this: =LET(in,XMATCH(YEAR(A19),$1:$1),XLOOKUP(A19,OFFSET($A$1,1,in-1,365),OFFSET($A$1,1,in,365))) Jun 05, 2024 Mike_OBree Hi Mike, the only two mistakes I can recognize are 1) that you have mixed up the names. The solution with offset where you don'...
I added the use of INDIRECT to reference the DateInput cell (for me always 1 or 2 cells left of the formula) to reduce potential for mishaps when copy/pasting the formula. I also changed the name of dscheikey's "in" to "YEARCOL" for my easier understanding. ...
I know some formulas but within the month they are all activated at the same time including Saturday and Sunday, I would like them to be activated only on the day worked. please i hope can you help me with that
","avatar":null,"profileSettings":{"__typename":"ProfileSettings","language":null},"parent":{"__ref":"Category:category:microsoft365"},"ancestors":{"__typename":"CoreNodeConnection","edges":[{"__typename":"CoreNodeEdge","node":{"__ref":"Community:community:gxcuf89792"}},{"__...