fish

Hi, I have 10 text-joined rows, A1-A10, each with up to 12 items and separated by a " / " as the delimiter. Is it possible to flag duplicates with a color, including when the order might different? i.e if A1 has bear / fish / cat and A2 has fish / bear / cat then they will be considered...

Hi, I'm a beginner in VBA and I'm not familiar with most of the code here. I read up on several threads about Worksheet_Change() and can't find something that suits to my need. Currently, I'm doing a project and let's assume that I changed the price of fish from $2 to $4. Sheet 1 (Original...

I am totally stuck with this. I have tried helper cells, substitute and sumif formulas but I cannot get what I want. So, I have a list with values. There is a text and if a word in the text matches a word in the list then it has to be replaced with a word that is in a cell next to the cell in...

I am a complete rookie. I have searched Google extensively to no avail to a question that I feel like surely has a straightforward answer. I am attempting a pair wise comparison of location of fish during a 60 day period. The dates are the column headings and the fish ID's are the rows. I will...

All, I have a large spreadsheet with fishing data on it. Dates, times, tides, water temperature, fish caught, fish targeted etc. It is all in one line by date. Basically it is results (fish) and variables. What would be the easiest way to see which variables are the most important in the...

Hello, I am trying to create a pivot table using data from multiple tabs but am having some issues. If anyone could assist it would be greatly appreciated. Here is the information: I have multiple worksheets (on different days) with the same headers. For example, let's say each worksheet has...

I have a situation where I have 3 different categories but 4 different formulas. For example, let’s say my categories are Dogs, Cats, and Fish. I will always have Dogs. Sometimes with the Dogs I’ll have Cats; sometimes I’ll have Fish with my Dogs, and sometimes I’ll have Cats AND Fish with my...

<tbody> A B C D 1 Apple Fig Peach 2 Fish 1 2 3 3 Mole 4 5 6 4 RAT 7 8 9 5 </tbody> Hello Excel Wizards In the above example, I'm looking for a formula in cell A5 that would contain one fruit and one animal and return the intersecting value. For...