Why formula result difference between 365 and 2019 ?

[akaseto]

hello,
i have a sheet called region, have 2 columns :
1st column A are sub region (not unique, contain same value with different region)
2nd column B are region

and sub region search box on cell C5, region result on D5:D7

i put this formula in D5 and D6 to determine region when i searched sub region on C5:

=IF(ROWS($C$32:C32)<=COUNTIF(Kel[DESA];$B$34);INDEX(Kel[KECAMATAN];SMALL(IF(Kel[DESA]=$B$34;ROW(Kel[DESA])-1);ROWS($C$32:C32)));"")
=IF(ROWS($C$32:C33)<=COUNTIF(Kel[DESA];$B$34);INDEX(Kel[KECAMATAN];SMALL(IF(Kel[DESA]=$B$34;ROW(Kel[DESA])-1);ROWS($C$32:C33)));"")

i got different results which excel 365 shown up Region A and Region B, excel 2019 got Region C and blank
but if i copied formula from excel 365 to excel 2019, excel 2019 got same value as 365 with { and } at the beginning and the end of value, this drives me crazy cz i cant event use those symbol if i write directly to the cells.

copied form 365 to excel 2019 :

Manualy put the formula on excel 2019 :

sorry for my bad english ?, please help.

 

[Fluff]

To use that formula in 2019 you need to confirm it with Ctrl Shift Enter, rather than just Enter.
For 365 you can just enter it normally.

 

[akaseto]

To use that formula in 2019 you need to confirm it with Ctrl Shift Enter, rather than just Enter.
For 365 you can just enter it normally.

thank you so much, thats work perfectly

is this a bug in excel 2019? or do i need to ctrl shift enter to all formula on excel 2019 ? I'm so hesitant to use excel 2019 now

 

[Fluff]

No it's not a bug, 365 & 2021 versions of Xl do not need CSE entry on any formula, however 2019 & older versions do need it on some types of array formula.