forest

I need a formula to match words contained in a phrase (B) to values in a list (A1:A5) and copy the matched values into a cell (C) e.g: <tbody> List Phrase Matched words break hot tub forest break break, forest cabin log cabin cabin cottage cottage break cottage, break forest forest hot...

I have 6 columns (cells L3 and O3 are labeled "Name", cells M3 and P3 are labeled "ID", and cells N3 and Q3 are labeled "Location"). I have a button named "Sort". I would like to create a macro that would sort the names alphabetically when pressed. I also need the information in the neighboring...

As you can see in the column sumif I have duplicate values for in row 2 and 3. What I am looking to do is remove that duplicate value so I can get an average of the Sum total for each document number. I need to leave all data intact for a pivot table. Running the pivot table in rows as...

Why can't I figure this out? =IF(F402,IF(LEN(B402<9),IF(C402<501,C402*0.01,5+(C402-500)*0.006),33),"") When LEN(B402<9 is FALSE, I want 33 as the result but I'm getting "". Thanks for your assistance.

Would anyone know how to work out the weighted average P Year based on the Area field for any given Species in the table below where Land Use can be either High Forest or Windblow and Forecast can only be F? I can do this with sumproduct but am not sure how to have more than one allowable...