Loop through a column

jeffreybrown · #1 09-22-2016, 03:57 PM

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.

k7dm · #2 09-22-2016, 06:27 PM

Hi Jeff,

Thanks for your reply. Attached is an updated Excel file with four columns, all of which have headers now. Is the code you sent a macro andif so, how do I execute it?

Thanks again.

Don

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