Forum Discussion
Choosecols function in Office 2024 PRO
I have just upgraded to Office 2024 Pro 32 bit and tries to use the Choosecols function together with the Filter and Sort function. Everything works fine as long as I not include the Choosecols step.
Using Swedish language the corresponding function is VÄLJKOL and I have seen Youtube examples where VÄLJKOL works as expected.
If I start with =VÄ 4 examples show up as valid continuations but not after VÄL and I assume that the function VÄLJKOL is not supported in my new Office 2024 PRO software.
Is this problem just for my Swedish 32 bit version or for all Office 2024 versions?
Regards
Staffan Westbeck
3 Replies
The problem is that I am still running Office 2021. I used this file Office_2024_EN_64Bits.exe for the installation but my Control Panel show this:
My Account for my Office files shows this:
Do the used installation file point actually point to Office 2021 products or is the Microsoft installation processor screwing up the installation because that was the last installed and removed Office product?
Stawes
Kind of a solution.
After much work I think that running an Online Office repair session hade done the critical job. The repair function actually do a complete removal of all Office products including activations and cleaning language setup. If you have several installed Office products you can get the following message.
You then need to do the reinstallation yourself including activating your products.
The Microsoft 365 and Office installation process seems to apply its own rules and 2 times it uninstalled Visio 2024 during the process of adding a second language on another product. I also had problems with the Publish 2019 that was bought from Microsoft Store due to the fact that during 2026 it is no longer supported.
1.CHOOSECOLS function basic usage
excel
=CHOOSECOLS(data area, column number 1, column number 2... to be returned)
Example: extract A: C region of the first and third columns
=CHOOSECOLS(A:C, 1, 3)
2. High-frequency problem solution
Function invalid error
Checking steps:
File → Account → About Excel to check the version number.
Below this version need to be upgraded through the Office update channel
3. Return results abnormal
Dynamic array overflow issue:
Add @ in front of the formula to force the return of a single value:
=@CHOOSECOLS(A:C, 2)
Column number out of range:
Dynamic control with COLUMNS function:
=CHOOSECOLS(A:C, 1, COLUMNS(A:C))
4. and FILTER and other function combinations
Extract the specified columns to meet the conditions:
excel
=CHOOSECOLS(
FILTER(A:D, B:B>100),
1, 3
)
5. Efficiency optimisation techniques
Instead of INDEX+MATCH:
excel
// Old method
=INDEX(A:C, MATCH(‘Conditional’,A:A,0), 3)
// New method
=CHOOSECOLS(FILTER(A:C, A:A=‘condition’), 3)
