Excel 2003 - VBA - Many Cell Compare

  • Thread starter Thread starter Craig Brandt
  • Start date Start date
C

Craig Brandt

Hi Guys:

I have a spreadsheet where I am pulling Account data from several sources.
One thing that I am looking for is to see if a given account has been on the
same strategy for the duration of the period under test.
Visually I would determine this by scanning a row of data to see that the
strategy code (Alpha Code) was consistent throughout the period.

Is there a quick way of looking at a range of cells and determining if they
are all the same? The period could be several hundred cells long.


Craig
 
Dave,

The solution was easier the you thought. I was looking for accounts that
were exclusively one strategy throughout the test period. I knew how many
days were in the test period, therefore the simple application of the
COUNTIF did the trick.

Thanks,
Craig
 
Back
Top