curly

  1. D

    Last number lookup help

    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...
  2. F

    A formula inside Curly braces inside Vlookup does not work, but seems good in theory

    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...
  3. A

    Curly Brackets but not an array?

    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...
  4. C

    Date outputs in curly braces and causes #VALUE! error

    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...
  5. L

    {=LINEST(E4:E43,F4:F43^{1,2,3},FALSE)} is strangely formatted

    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...
  6. C

    #name?

    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...
  7. R

    Curly Brackets, finding text,,, must be Simple

    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?
  8. R

    Simple Tricks with your curly brackets not working

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top