I'm using Excel 2010 Home and Student edition.
I've created a column, B, of questions which need to be answered on a
scale from 0-5. Columns C-H are to be checked with an "X" or whatever character they see fit to indicate which answer they have chosen.
For example, one of the questions in column B says, On a scale of 0-6,
how painful is it for you to climb one flight of stairs?" The choices
are, 0, column C, "not difficult," 1, column D, "minimally difficult,"
etc. all the way up to 5, column H "unable to do." The end result is
that column I figures out which column the "X" was placed and enters the numerical result.
Hi David,
Am Sat, 22 May 2021 11:52:58 -0700 schrieb David Farber:
I'm using Excel 2010 Home and Student edition.
I've created a column, B, of questions which need to be answered on a
scale from 0-5. Columns C-H are to be checked with an "X" or whatever
character they see fit to indicate which answer they have chosen.
For example, one of the questions in column B says, On a scale of 0-6,
how painful is it for you to climb one flight of stairs?" The choices
are, 0, column C, "not difficult," 1, column D, "minimally difficult,"
etc. all the way up to 5, column H "unable to do." The end result is
that column I figures out which column the "X" was placed and enters the
numerical result.
try:
=MATCH("x",$C21:$H21,0)
Regards
Claus B.
Hi David,
Am Sun, 23 May 2021 09:19:41 -0700 schrieb David Farber:
That works fine. Thank you. Do you have any idea why Excel glitches on
my formula?
for me your formula works fine.
Regards
Claus B.
That works fine. Thank you. Do you have any idea why Excel glitches on
my formula?
Does it work for you (meaning Excel doesn't modify the formula in column
"I") even if you enter an "X" in one cell, and then change your answer
by cutting and pasting "X" into another cell? Maybe a later version of
Excel has fixed the problem?
On 5/23/2021 9:53 AM, Claus Busch wrote:
Hi David,Does it work for you (meaning Excel doesn't modify the formula in column
Am Sun, 23 May 2021 09:19:41 -0700 schrieb David Farber:
That works fine. Thank you. Do you have any idea why Excel glitches on
my formula?
for me your formula works fine.
Regards
Claus B.
"I") even if you enter an "X" in one cell, and then change your answer
by cutting and pasting "X" into another cell? Maybe a later version of
Excel has fixed the problem?
On 5/23/2021 12:05 PM, David Farber wrote:
On 5/23/2021 9:53 AM, Claus Busch wrote:
Hi David,Does it work for you (meaning Excel doesn't modify the formula in
Am Sun, 23 May 2021 09:19:41 -0700 schrieb David Farber:
That works fine. Thank you. Do you have any idea why Excel glitches on >>>> my formula?
for me your formula works fine.
Regards
Claus B.
column "I") even if you enter an "X" in one cell, and then change your
answer by cutting and pasting "X" into another cell? Maybe a later
version of Excel has fixed the problem?
That's by design; it's typically the desired result to have the formula adapt to the data; your case is an exception but there's no way in Excel
to change the behavior.
I've learned the hard way, too, in some cases in which I also did not
want the behavior. It also follows with sort() in which reordering the data can cause formulas to change their targets as well, sometimes with disastrous results.
--
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 302 |
Nodes: | 16 (2 / 14) |
Uptime: | 191:11:04 |
Calls: | 6,779 |
Calls today: | 4 |
Files: | 12,308 |
Messages: | 5,388,262 |
Posted today: | 2 |