Feedback by UserVoice

Anil

My feedback

  1. 746 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anil commented  · 

    I guess I'm not getting it, Wyn.

    How are the 'MatchColumn/Row' and 'GetColumn/Row' arguments being generated?

    I am not understanding how they would be defined
    without using the 2 MATCH functions normally used.

    Are they new nested functions?
    If they are just functional arguments, how are you determining the values?

    Perhaps if you can write out a full sample formula, the light will go on....?

    Anil commented  · 

    I do not see a significant difference between your example
    and the INDEX function I normally use.

    My typical formula is

    =IFERROR(INDEX(Data!$A:$AA,
    MATCH(CurrentDate, Data!$1:$1, false),
    MATCH("abc", Data!$A:$A, false)), 0)

    Other than the terminology, what is the added benefit...?

    Anil supported this idea  · 
  2. 5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anil shared this idea  · 
  3. 773 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks to Graham for starting this conversation. If you would also like Excel to maintain named range references and structured table references in the “applies to” field for Conditional Formatting rules, please add your comments and vote this one up. We will prioritize accordingly.

    Thanks,
    Steve (MS Excel)

    Anil supported this idea  · 
  4. 898 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks again for all the passion on this issue – we hear you and we’ll get someone on the team to dig in to the issue. I’ve seen a few related sub-issues while scanning over the comment section for this one, so we may reach out to a few of you for clarifications. Thanks again for all the votes, and keep them coming for the issues you care about!

    John, Excel

    Anil supported this idea  · 
  5. 47 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anil supported this idea  · 
  6. 519 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anil commented  · 

    Better would be just to get rid of the button.
    Bury the "feature" really deep somewhere,
    so if we DO actually need it,
    we will have to look for it.

  7. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Excel for Mac » Formatting  ·  Flag idea as inappropriate…  ·  Admin →
    Anil commented  · 

    You can do so with one click:
    Select the range
    RightClick to drag elsewhere;
    WITHOUT letting go, bring it back to original location.
    Shortcut menu has a "Copy here as values only" choice.

Feedback and Knowledge Base