Hello!
Been scratching my head with this for a while and need some help.
Attached is a file of sample customers and the cars they own. I want to make a list of only the unique names for each car.
As you can see, the formula is spitting out these names in order (with duplicates).
What can I do to just show the names only once?
A million thank yous
How do you feel about using a Pivot Table for this?
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
Hi Ben! Thanks for looking at this:
Would love nothing more, however, the actual application is a standardized report, so the solution would have to be formula based.
This example with the cars/owners is a simplified version, but if it's TOO simple, I can "whitewash" the actual and send it over.
Hi all. Standard formula, in E2, copied across and down:
Please Login or Register to view this content.
Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee
leelnich THANK YOU!
Yep! Thank you for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks