Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Howard Dixon   on Nov 18 In MS Office Category.

  
Question Answered By: Corbin Jones   on Nov 18

I designed today a formula how does just that and even uses a dynamic range
for itself to function...

=AANTAL.ALS(VERSCHUIVING($A$2;0;0;AANTALARG($A:$A)-1;AANTALARG($A$2:$B$2));A
2)>1

where:
AANTAL.ALS = COUNTIF
VERSCHUIVING = OFFSET
AANTALARG = COUNTA

Be sure to be on A1 of the range  (= A2 in my example because row 1 contains
labels). Notice that it takes all the rows in account and only two columns
so

=AANTAL.ALS(VERSCHUIVING($A$2;0;0;AANTALARG($A:$A)-1;2);A2)>1

does the same as the formula above.

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Finding duplicates in a range Or get search suggestion and latest updates.


Tagged: