Can someone help with this?
In cell AB1 I have the formula =COUNTIF(AA:AA,1)
If I drag the cell down I get the same formula, what would I need to add to AB1's formula so that when I drag down I get 2 instead of 1.
Thanks
Can someone help with this?
In cell AB1 I have the formula =COUNTIF(AA:AA,1)
If I drag the cell down I get the same formula, what would I need to add to AB1's formula so that when I drag down I get 2 instead of 1.
Thanks
Try this:
=COUNTIF(AA$1:AA1,1)
Dag copy down.
If you are not starting in row 1, change the 1 to the appropriate row number.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
If I've understood correctly, try this:
=COUNTIF(AA:AA,ROWS($1:1))
or
=COUNTIF(AA:AA,ROW())
BSB
Last edited by BadlySpelledBuoy; 10-19-2021 at 06:47 AM.
In cell AB2
=AB1+1
then drag that formula down instead of AB1
Thanks for the replies guys.
95% of the formulas when dragged down will return 1 so I wanted an easy way to find the location of greater than 1's.
Aligw don't know why but your formula didn't find them for me.
BSB yours worked for me.
I haven't try the third one.
Thanks to you all.
Because we were all having to guess!!!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.
I know it was vague Aligw.
I have marked as solved
Ta
Mate, I think you need to better describe your question.
=--(COUNTIF(AA$1:AA1,AA1)>1) to only mark once a duplicate occurs.
=--(COUNTIF(AA:AA,AA1)>1) to also mark the first occurrence of any duplicate.
Provided I have understood your questions correctly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks