Loop through a column
I have a ten-column worksheet and each column is a list of ham radio call signs that is sorted alphabetically A to Z. Each of the calls may be repeated any number of times and there are a total of 384 entries in each column. I’d like to be able to loop through the columns and count the number of times a given call appears in a column using the COUNTIF function. A sample column is shown in the attached Excel 2007 file. I’d very much appreciate any help on this.
Thanks.
Don, K7DM
|