i have column E with downwards multiple entrys of wich some is repetetive in other words e13 a e14 b e15 a e16 c e17 a e18 b e19 a e20 c e21 a e22 b
and in g i have amounts thats corresponding/refering to E for example g13 100 g14 101 g15 204 g16 20 g17 50 g18 10 g19 100 g20 101 g21 30 g22 47 i need in column L to only show L13 a L14 b L15 c and in column M i will need the sum of all the a's in M13 and sum of b's in M14 and sum of c's in M15 for example M13 484 M14 158 M15 121 there will be on different sheets different amounts of rows so it could be on one sheet 23 unique items in column E and on another sheet 100 unique items thank you!!! can send sample of the workbook -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/excel-macros/2cf092f0-a355-402a-95bf-48f3c8a6ec2co%40googlegroups.com.
