Is there a way to perform an operation on a range as part of another formula? I have a column of text. I want to search that column to see four characters match the last four characters of any cell in the range. So, my formula would look something like this: =COUNTIF( RIGHT(A1:A8, 4), "ABCD") This gives me an error.
Now, I know that I can create another column and use the RIGHT formula to get the last 4 characters and then search that column. However, I am wondering if there is a way to do the search without creating a new column.
Thanks for any help,
Now, I know that I can create another column and use the RIGHT formula to get the last 4 characters and then search that column. However, I am wondering if there is a way to do the search without creating a new column.
Thanks for any help,