Share via

Add argument to Vstack or Hstack function

Anonymous
2022-07-24T17:20:35+00:00

Add argument to Vstack or Hstack function for example.

=HSTACK(Table1[Name],counta(Table1[Name]))

Array1=Table1[Name]

=HSTACK(Table1[Name],counta(Array1)) or

Create new Function

Return_Hstack(HSTACK(Table1[Name],counta(Array1))

Return_Hstack(VSTACK(Table1[Name],Table1[Value],sum(Array2))

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

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-07-25T06:14:39+00:00

    Apologies, I thought you were having trouble with the function, not suggesting an improvement.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-07-25T03:02:23+00:00

    Hi Kev Hacker.

    I meant that, for example, the second argument can be used in the third argument.

    argument1=array1

    argument1=array2

    argument1=array3

    =HSTACK(array1,array2,counta(array2))

    I would like to suggest that Microsoft add an argument to this function. Do you think it is possible to add this argument or not?

    Was this answer helpful?

    0 comments
  3. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  4. Anonymous
    2022-07-24T17:56:28+00:00

    Hi Arastoueian,

    Thank you for reaching out to us today. I’m Kevin and I’m happy to to help you out with your question today.

    Please can you let me know what you need assistance with regarding your message.

    This may help:

    https://support.microsoft.com/en-us/office/vstack-function-a4b86897-be0f-48fc-adca-fcc10d795a9c

    I hope this information is helpful. If you have any further questions or need additional assistance, please reach back out and I will be more than happy to assist you.

    Best Regards,
    Kevin

    Give back to the Community. Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below.

    Was this answer helpful?

    0 comments