reagr
New member
- Joined
- May 1, 2021
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 2016
=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-fo...irst-column-with-values-in-second-column.html, https://www.quora.com/unanswered/In...-in-the-corresponding-cell-in-the-next-column
=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-fo...irst-column-with-values-in-second-column.html, https://www.quora.com/unanswered/In...-in-the-corresponding-cell-in-the-next-column