Hi,
I am trying to use the CHOOSECOLS formual but I want to add a blank column in between 2 populated columns. Anyway to do that?
I tried just putting in nothing in between commas but it didnt work.
CHOOSECOLS(Table4[#All],1,3,6,7,8,9,,10,2,4,5,8,11,12)
Thanks!
A couple of ways, for example:
Formula:
Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
Change the range A2:A8 to refer to your Table.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hi to both!
Another option is just putting 13 where you want a blank column:
Blessings!
Please Login or Register to view this content.
Last edited by John Vergara; 04-16-2023 at 09:40 PM.
You do realise, that the blank column, however you insert it, can NEVER contain ANYTHING. If you type into the blank column, you'll get a #SPILL error.
If you want to be able to enter something, there, you'll need TWO CHOOSECOL formulae, with an empty column between them.
Last edited by Glenn Kennedy; 04-17-2023 at 02:30 AM.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Yes, indeed, you are right, I also in search of same solution so I can write in blank column, but unfortunately unable to find any solution and in the end I use choosecols multiple times after leaving blank columns in between.Originally Posted by Glenn Kennedy
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks