Share via

Using CHOOSECOLS and Filter function how do I return specific columns of data and select/highlight those results.

Anonymous
2024-08-21T12:59:56+00:00

I know how to use the CHOOSECOLS and FILTER function to return specific columns of data.
Is there a way to highlight those results like using your mouse or keyboard, so that I can save it as a .csv file within the same formula?
Hope that is understandable. Thanks for any help.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Rory Archibald 18,965 Reputation points Volunteer Moderator
2024-08-22T10:13:29+00:00

I'm afraid a formula cannot do that either.

Was this answer helpful?

1 person found this answer helpful.
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-08-21T17:26:20+00:00

    I do not want to save the file as a .csv file within the formula. I want to mimic the keyboard shortcut of CTRL + A, to select the output of the formula. Now do you understand what I am looking for? Just trying to save the step of doing the keyboard shortcut of CTRL + A to select the output.

    Was this answer helpful?

    0 comments
  2. Rory Archibald 18,965 Reputation points Volunteer Moderator
    2024-08-21T13:12:37+00:00

    A formula cannot save a workbook, so I don't really understand what you want?

    Was this answer helpful?

    0 comments