coconut

Hi The data I'm trying to consolidate has this structure. I found pieces of code around the forum but i just can't make it work, is there a way using VBA or a formula I can do this? Make this: <tbody> A B John 1 apple 2 apple 1 orange Peter 1 Lemon 1 Orange 2 Lemon 3...

Hello everyone, I have got problem with conditional formatting. In Column A and B a have got some values. I'm looking for some way to hightlight duplicates values per columns. Of course I can create manually rules per column but finally file will be have over 1000 columns. I need range where...

Hi all, I am having some trouble summing up some data from the dynamic range B2:C15. All the fruit names that populate $B$2:$B$15 belong to to either of the 4 groups. These 4 groups are also dynamic lists. They are: Group1: Range $E$3:$E$15, Group2: Range $F$3:$F$15, Group3: Range...

Hello i'm trying to group the CODE values and get a total of the count based on certain instances. i cant use a pivot table when doing this so VBA code is preferred Then i would like to do the same but for "Coconut" only in the FRUIT2 Column using certain instances Then i would like to know...