First, thanks for any help you can provide...
This is tricky for me, so any advice or direction will help a great deal in automating this procedure.
I have thousands of rows of data.
Every 2 rows produce one set of information. (IE Row 11 and row 12 is one person's data. Row 13 and 14 is another person)
Let's say rows 11 through 18 produce data for 4 people all in the same building.
Then rows 19 through 24 produce data for 3 people, all in another building.
The 1st cell of the 2nd row identifies the person's number, and therefore how many people are in the building.
(ie: cell A12 = 02211, then cell A14 = 02212, A16= 02213, A18= 02214, then A20 = 02221)
Since the last number of A18 is "4" we know that previous 4 people were all in the same building, and starting with A19, we have a new group of people in a new building.
I need to a formula that will run down and check ONLY the last number of that cell, to tell me how many people are in the building, and produce the number for the previous pairs.
So we know A11-A18 produces data for 4 people in one building. Let's put the results in V12,V14, V16 and V18 (they would all equal 4).
Does this make sense?