chuf
Well-known Member
- Joined
- Jun 12, 2006
- Messages
- 619
morning all,
i have a huge list of data and i want to extract the cost of certain jobs, from column S, if certain text is contained within column F.
ie if it says "kitchen" anywhere within the text in column F then show the costs that relates to that row that is contained in column S.
Are you able to help please. i just can't search the whole text and get it to tell me if that one word is in there.
Many thanks,
i have a huge list of data and i want to extract the cost of certain jobs, from column S, if certain text is contained within column F.
ie if it says "kitchen" anywhere within the text in column F then show the costs that relates to that row that is contained in column S.
Are you able to help please. i just can't search the whole text and get it to tell me if that one word is in there.
Many thanks,