Click here for important information about Computing.net.

Solved How to enter an array formula

Dell / Inspiron 17r
January 17, 2021 at 10:15:06
Specs: windows 10, 2.3/8
I tried copying and pasting (formula) an existing array formula into a different cell and that did not work. I then pressed Control-Shift-Enter and retyped the array formula and that didn't work. I then retyped the array formula and then pressed Control-Shift-Enter and that didn't work. What am I doing wrong?

Thank you.
Brian W


See More: How to enter an array formula


#1
January 17, 2021 at 10:45:20
re: "I tried copying and pasting (formula) an existing array formula into a different cell and that did not work."

What does "that did not work" mean?

re: "I then pressed Control-Shift-Enter and retyped the array formula and that didn't work."

Why would you press Ctrl-Shift-Enter before typing the formula? That needs to be after the formula has been typed in. That is what tells Excel that it is an array formula.

re: "I then retyped the array formula and then pressed Control-Shift-Enter and that didn't work."

What does "that didn't work" mean?

re: "What am I doing wrong?"

We can't tell you what you are doing wrong until you tell us something more than it "didn't work"

message edited by DerbyDad03


Reply ↓  Report •

#2
January 17, 2021 at 14:15:03
DerbyDad03,

Thank you for your response. The problem was caused by my entering "w" instead of "W" in the formula below:

=SUM(IF(ISNUMBER(FIND("W",U3:BE3)),VALUE(RIGHT(U3:BE3,LEN(U3:BE3)-2)),0))

Can the formula be rewritten so that it accepts either "w" or "W"?

Thanks again,
Brian


Reply ↓  Report •

#3
January 17, 2021 at 14:43:57
✔ Best Answer
Try SEARCH instead of FIND.

FIND is case sensitive, SEARCH is not. SEARCH also allows the use of certain wildcards.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •

Related Solutions

#4
January 18, 2021 at 13:05:48
DerbyDad03,

Thank you for your suggestion; it worked as desired.

Brian W


Reply ↓  Report •

Ask Question