Loop through a column

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

FAQ

Thread Tools

Display Modes

09-22-2016, 03:57 PM

jeffreybrown jeffreybrown is offline

Windows Vista Loop through a column

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

Hi Don,

Let's start with this.

=IF(A1<>A2,COUNTIF($A$2:$A$14,A2),"")

I'm guessing you are looking for a macro? You show in your file data starting in row 1, but is row 1 a header row? It would make things a little easier maybe as the formula above starts in B2.

Without seeing the actual full layout, I had to take a guess on your layout. Just press the button and tell me what you think.

Attached Files

Forum Example.xlsm (17.6 KB, 8 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