Bill DeWitt

My feedback

  1. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
    Bill DeWitt commented  · 

    =CONCATENATE($a2,b$1)
    a b
    a aa aab
    b baa baaaab

    Bill DeWitt commented  · 

    Perhaps more detail might get a response:
    I want -
    _ a b
    a aa ab
    b ba bb
    so I use concatenate($a2,b$1) which gives me aa in cell b2, but when I drag it out to fill I get (b2,c1) instead of (a2, c1) in cell b3 so that I get

    _ a b
    a aa aab

    when I drag it down I get a circular reference error warning.
    However -
    Going back to Google Sheets I was able to make the setup and download it as xls and import it and make it work, It seemed to read the "$" then.

    Bill DeWitt shared this idea  · 

Feedback and Knowledge Base