Loop through a column

		Microsoft Office Forums > Microsoft Excel > Excel
Loop through a column

FAQ

Thread Tools

Display Modes

09-22-2016, 12:50 PM

k7dm

Windows 7 64bit Loop through a column

Office 2007

Novice

Join Date: Sep 2016

Location: Ocean Shores, WA

Posts: 5

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

Attached Files

Forum Example.xlsx (10.2 KB, 9 views)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Timeline - loop through all dates between first and last given and add date to column if not found	carlos_cs	Excel Programming	1	05-03-2016 09:25 AM
documents saved with double column revert to single column when re-opened	danw	Word	6	04-08-2015 06:24 AM
Embedded Excel in Powerpoint - custom animation, display column by column	andytheanimal	PowerPoint	2	01-20-2015 06:30 AM
How can I temporarily break a 3 column format in order to type a single column paragraph	William P	Word	1	01-04-2015 06:40 PM
Want a quotient using a constant to show up in column c each time a number is added to column b	fibbermcghee	Excel	2	12-09-2014 05:48 PM