JoshuaFreeman
New Member
- Joined
- Jan 23, 2014
- Messages
- 4
I have a table where the text "pit1" appears in multiple different rows and columns (ex: "pit1" is in c7, j6, and p16). In the 3 columns next to each of these, there are time values. Ex: c7=pit1, d7= 03:15, e7=05:45, f7=8:15. I'm trying to write a formula that will search the entire spread sheet for "pit1" and then test if a time value appears in one of the 3 next columns and return some misc. value if true, and leave blank if false. Basically, something to the effect of: if "pit1" exist and has a value of time xx:xx then display misc info, else blank.