snow

I am tracking snow data for skiing. In column D I have the snow that fell in the last 24hrs. I want to count how many consecutive times the value over 10 occurs in the column. I thought I had it with =MAX(FREQUENCY(IF(D2:D153,">10",ROW(D2:D153)),IF(D2:D153,">10",ROW(D2:D153))))) A B C D E...

Hi Everyone, I have a table where I'm trying to lookup a transaction ID for a particular sales member. I'm not sure how to approach this and my efforts around an IF( AND( VLOOKUP( formula have proved futile. The following tables show what I'm trying to accomplish. TABLE 1 <tbody>...

Hello Everyone, I was hoping someone could help me with a formula for a similar situation to what I have below. I know I can use an index/match formula to match B2 to column A and pull "The Snow is white". But I can not seem to find a way to do it the other way around. <tbody> A B C 1...

Hi all I have some data in the following layout: <tbody> Date Region Snow 01/02/17 Scotland 1 02/02/17 Scotland 1 03/02/17 Scotland 0 08/02/17 Scotland 1 02/02/17 Wales 0 08/02/17 Wales 1 </tbody> I need a formula which will will give me the total number of unique regions which...