Hi
i need a formula to extract duplicate number from range
2 7 4 7 3 5 result 7
or if 2 duplicate numbers
3 5 3 6 9 6 result on column G=3 (the small duplicate number) result on column H=6 (the large duplicate number from range)
Hi
i need a formula to extract duplicate number from range
2 7 4 7 3 5 result 7
or if 2 duplicate numbers
3 5 3 6 9 6 result on column G=3 (the small duplicate number) result on column H=6 (the large duplicate number from range)
Column G:
=MIN(IF(COUNTIF(A1:F1,A1:F1)>1,A1:F1,""))
Column H
=MAX(IF(COUNTIF(A1:F1,A1:F1)>1,A1:F1,""))
BOTH confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Quang PT
thank you mr. bebo021999
Last edited by pedersenn; 08-22-2016 at 01:52 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks