Need formula to bring data (If or any conditions)
Hi All,
Attahced pls find file, need help on conditions formula to bring data.
I have customers name in file & want customer with the begining name Pentair to be called "Intercompany" in column "F" and rest of classed as "Direct".
I used "if" formula but it only works if i put whole customer name in formula instead of begining 1st word. Any formula to work for required request will be appreciated.
Thanks for help
Regards
=IF(LEFT(B2,7)="Pentair","Intercompany","Direct")
and copy down the column
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Hi,
In column F, try,Formula:
Please Login or Register to view this content.
Edit : Note the change in above formula, added a *, inorder to check if the word Pentair occurs inbetween in a customer name in column B.
Last edited by Saarang84; 07-18-2014 at 05:22 AM.
If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.
If your requirement has been solved please mark your thread as Solved.
In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".
Kindly use [FORMULA] or [CODE] tags when posting your code.
Regards,
Sarang
Your are gr8, Thanks for help
Thanks for help genius
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks