Solved How to enter an array formula

DerbyDad03 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

Brian W 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

DerbyDad03 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

Brian W January 18, 2021 at 13:05:48

DerbyDad03, Thank you for your suggestion; it worked as desired. Brian W