I would like to have a formula that can tell me what the next value is in a column that is different than a known value. If I have a column that has some value "A" and then later in the column changes to "B" (which could happen anywhere in the column), I would like to have two boxes that can tell me the values "A" and "B". I know how to get the value for "A" since I can look at the first cell of that column but I don't know how to get it to look for "B". It can't be that hard but I am just not finding it.
Thanks,
Bookmarks