I created a table with the dealer number and state they are licensed in. I have added a column with the REPT function so that it creates a list of all the states the dealer is licensed in. However, when there is a change in dealer number and the state licensed is the same as the previous dealer, it leaves a blank cell as seen in C8. I need to find a way to eliminate the blank cells and make the state visible.
Does this work?
Formula:
Please Login or Register to view this content.
Please click the * icon below if I have helped.
C2: =if(a2=a1,if(b2=b1,c1,c1&" / "&b2)," / "&b2)
Josie
if at first you don't succeed try doing it the way your wife told you to
Yes, this works. I appreciate the help.
please don't forget to mark the thread solved (click the thread tools link near the top of the page)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks