occurrence

I'm working with a long string and need to, by formula if possible, remove all text prior to the final occurrence of a colon (:) ... and the colon. Example string below though not all strings follow same format with the exception of what I need being at the end. MANUFACTURING, INC@2343 Hoover...

Hi all, Suppose I have a spreadsheet that looks something like this <tbody> File1004 "Input Cell" -> 1006 File1005 "Return Occurrence" -> 3 File1006 File1007 etc. </tbody> I need a formula in C2 that looks through column A to find the cell that contains "File"&C1. This can be...

Hello! I want to check the number of unique text occurrences in two separate columns, right now i am only able to do it with one as such: =SUMPRODUCT((Table1[col1]<>"")/COUNTIF(Table1[col1];Table1[col1]&""))</pre> Is there any way to do that simply? thanks

Hi, I would like to be able to delimit or trim data by the number of occurrences of a special character. I want to be able to extract the file path but not the file names. this is what I want it to do: \home drive\Data\Web stuff\test.xls -> \home drive\Data\Web stuff \home drive\Data\Web...

Hey all, I have the two formulas I want to apply if the condition is true or false. Problem is I need to determine whether there's a comma after the second ampersand in a cell. For example, if the field looks like this: HernaraMartin,Harry & Marie Anne & Ann Sally then I want to execute this...

In column 'A' I have a list of 10 different people, but there are 130 entries, so a lot of repeating. In column 'B' I have a list a items each person has chosen (nothing repeating) Now in, say, column 'C' I want to list all items chosen by one particular person. I can search for a name and...