Hi folks
In the attached workbook I have groups of numbers in Col G
In col H I would like to trim col G to just one each of the numbers where there are duplicates (as shown).
Each group of numbers will have a blank row between.
Cheers
Hammer
Hi folks
In the attached workbook I have groups of numbers in Col G
In col H I would like to trim col G to just one each of the numbers where there are duplicates (as shown).
Each group of numbers will have a blank row between.
Cheers
Hammer
Insert the formula in H2 =MAX($G$2:$G$14) and
insert =LARGE(IF(G$2:G$14<H2,G$2:G$14,0),1) in H3
Note: This is an array formula hence select the cell H3, Press f2 and Ctrl + Shift + Enter
and copy the formula towards down
Many thanks nflsales!
Hammer
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks