I have two columns of data and need to find the beginning and end info for a criteria.
In column A are weekly dates going downward.
In column B rows 2 to 10 are Type A, rows 11 to 20 type B, rows 21 to 30 type C etc. The date of the types changes but they are always together. How do I find the starting and end dates?
Thanks!
In column A are weekly dates going downward.
In column B rows 2 to 10 are Type A, rows 11 to 20 type B, rows 21 to 30 type C etc. The date of the types changes but they are always together. How do I find the starting and end dates?
Thanks!