FIND has wrong data type error

masplin

Active Member
Joined
May 10, 2010
Messages
406
Another stupid question sorry

I have a column call "Product" containing data which powerpivot says is text. I want to find the position of the word "gym" in each entry. If I use a calcualted column with
Code:
=find("gym",transactions[Product])
it throws an error "an arguement of function "FIND" has the wrong data type or is invalid"
I am completely mystified as the column is text and "gym" is text so what's the problem? This is a really easy function to use in excel so tearing what is left of my hairout trying ot understand powerpivot!!!

Thanks again Mike
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

masplin

Active Member
Joined
May 10, 2010
Messages
406
Found the answer. "Gym" was with a capital and FIND is case specific. I hadn't included a "not found" arguement so threw an error.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,741
Messages
5,524,560
Members
409,584
Latest member
Devil_717

This Week's Hot Topics

Top