curly

Hello, In column B I have case numbers and some of them are duplicate. I need to have it find the last duplicate number (furthest down in the column) and have it return the corresponding name associated to that row in Column H. Example: If I put the formula in cell I2, number 14019509 would...

Thank you for reading. I started wanting to set up a report to in excel to go find data for a month period (single cell), quarter to date period (multiple cells) and year to date period (multiple cells). Using curly braces in the VLOOKUP helped = sumproduct(vlookup(a1,'sheet1'!a1:z200...

Hi I've been given a spreadsheet to work through and there's a formula that I've never seen before. It's =IF(SUM(COUNTIF(E3,{"*M*","*T*","*W*","*F*"})),"O","") The curly brackets are there whether Ctrl Shift and Enter is used or not. The only time I've seen curly brackets are for arrays...

Hello I'm setting up a name to output a date. The date is pulled from cell A3 using Mid/Substitute/Find/Len and turned into a number with Value. By itself, the formula works fine to output a date, but when I put the name representing this formula into another formula, the date ends up being...

I have not seen this format in a formula before. i understand the formula LINEST(), I've used it before what i dont understand are- -the curly brackets before and after the formula -the carrot with the numbers in curly brackets. can someone explain their purpose? Excel help is worthless for...

Don't why there is #NAME ? error using the Morefunc (MCONCAT)? Book1NOPQR21[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=NAME]#NAME[/URL] ?[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=NAME]#NAME[/URL&rsqb...

Hi Mr. Excel users, Is it possible for Curly brackets to produce a Cell Value answer? Example.. In this case, a:a values are unique numbers, therefore, 1 is the only answer I can get in b:b ={if(a:a=1,b:b)}... now, what formula should I use to get the value align in b:b?

Hi Mr. Excel users, Good day! 2 samples below (BOTH WORKING) -Original: =OR(WEEKDAY(A10)=1,WEEKDAY(A10)=7) -Curly =OR(WEEKDAY(A10)={1,7}) I'm using Curly because of lesser LEN. Curly #2 not working -Original: =OR(B10="richard",B10="phoebe") -Curly #1: =OR(B10={"richard","phoebe"}) -Curly...