In the attached sample, which is only a snippet of a large worksheet, the goal is to have the player name with his total MLB stats for the season and the current team name. So in a nutshell, the first occurence of the player name is row i need, but I have to replace the string "TOT" with the team name in the last occurence of the player name. And delete all other rows with the matching player name
One problem that occurs in the data set is that two or more players may have the same name. So my thinking was Col B (Name) and Col C (Age) could be used as a reference. It's hard to verbalize this and I'm probably making it more complicated than it needs to be. Thanks in advance for any help offered -- 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 post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
create one occurence only.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
