Question description:
This user has given permission to use the problem statement for this
blog.
I have a formula in Column G: =COUNTIF(B19:B38, "M") and I want to copy it to Column J, but I want it to say =COUNTIF(C19:C38, "M"), NOT =COUNTIF(E19:E38, "M"). Is there an easy way to do this? I have a whole spreadsheet to do.
Solved by V. S. in 8 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
20/06/2018 - 02:45
HI
Excelchat Expert
20/06/2018 - 02:46
Welcoem to got i tpro!
User
20/06/2018 - 02:46
Hello, thank you!
Excelchat Expert
20/06/2018 - 02:47
COUNTIF(B19:B38, "M")
Excelchat Expert
20/06/2018 - 02:47
For your question, the best way to do this is to change it manually
Excelchat Expert
20/06/2018 - 02:48
for example,B19:B38,
Excelchat Expert
20/06/2018 - 02:48
You can change this part to the column that you need
Excelchat Expert
20/06/2018 - 02:48
And this is the best/fastest way to do it
User
20/06/2018 - 02:49
that's what I was afraid of. That's what I've been doing, I just have over 100 places I need to do this. I was hoping there was a better solution
Excelchat Expert
20/06/2018 - 02:50
Unless you could line other the column that you need at the first place
Excelchat Expert
20/06/2018 - 02:50
for example, when you switch the column, the next column is always be the column you want to search for
Excelchat Expert
20/06/2018 - 02:51
If you need to specify very specific columns, then you need to change them one by one
User
20/06/2018 - 02:51
alright, well thank you, I appreciate your time. i figured it was a long shot, but you never know.
Excelchat Expert
20/06/2018 - 02:52
We do hope that this solved your question but due to the nature of your problem there are the only 2 way to solve it
User
20/06/2018 - 02:53
not a problem, thank you so much
Excelchat Expert
20/06/2018 - 02:54
Well, hope you have a great night !
User
20/06/2018 - 02:54
you too!
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.