Results 1 to 4 of 4

Thread: Replace a term in one column with value in next column

  1. #1
    Neophyte reagr's Avatar
    Join Date
    May 2021
    Posts
    2
    Articles
    0
    Excel Version
    Excel 2016

    Replace a term in one column with value in next column



    Register for a FREE account, and/
    or Log in to avoid these ads!

    =COUNTIF(A1:A347, "Alabama") Alaska
    =COUNTIF(A1:A347, "Alabama") Arizona
    =COUNTIF(A1:A347, "Alabama") Arkansas
    =COUNTIF(A1:A347, "Alabama") California

    How can I replace the "Alabama"s in the first column with "Alaska", "Arizona", "Arkansas" and "California" such that it becomes

    =COUNTIF(A1:A347, "Alaska") Alaska
    =COUNTIF(A1:A347, "Arizona") Arizona
    =COUNTIF(A1:A347, "Arkansas") Arkansas
    =COUNTIF(A1:A347, "California") California

    I have tried posting this in other places without luck: https://www.excelforum.com/excel-for...nd-column.html, https://www.quora.com/unanswered/In-...he-next-column
    Attached Files Attached Files

  2. #2
    Conjurer Fluff's Avatar
    Join Date
    Sep 2018
    Posts
    120
    Articles
    0
    Excel Version
    O365
    Just change the B11 in the formula John gave you to B12

  3. #3
    Neophyte reagr's Avatar
    Join Date
    May 2021
    Posts
    2
    Articles
    0
    Excel Version
    Excel 2016
    As I told John, that doesn't work because I need to put quotation marks around "B11", and when I do it looks up literally "B11" instead of what's in the cell B11.
    Last edited by reagr; 2021-05-03 at 01:54 PM.

  4. #4
    Conjurer Fluff's Avatar
    Join Date
    Sep 2018
    Posts
    120
    Articles
    0
    Excel Version
    O365
    What makes you think you need to use quotes?
    Have you actually tried the formula?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •