| Online: | |
| Visits: | |
| Stories: |
Now you have a list of unique customer numbers each with a unique customer name and you’re done with Sheet1. Go back to the original sheet and in cell F2 type =VLOOKUP
Friday, May 15, 2015 15:52
% of readers think this story is Fact. Add your two cents.
style="display:inline-block;width:336px;height:280px"
data-ad-client="ca-pub-9536153142272656"
data-ad-slot="9745356732">
I BOUGHT A NEW PONTIAC FOR MY GIRLFRIEND ONCE,
Ping K15 Sale, PAID CASH. BIG MISTAKE. WHEN I BROUGHT THE CAR IN FOR REQUIRED MAINTENANCE THEY TREATED ME LIKE CRAP.
Now you have a list of unique customer numbers each with a unique customer name and you’re done with Sheet1. Go back to the original sheet and in cell F2 type =VLOOKUP($D2,
TaylorMade R11 Sale,customer_name_ID,
Ping G25 Sale,2,
TaylorMade SLDR Sale,FALSE) and then copy that formula down for however many rows as there are data. The results in column F should be the unique and non duplicated names that are in the ‘customer_ID_name’ range.
style="display:inline-block;width:300px;height:250px"
data-ad-client="ca-pub-9536153142272656"
data-ad-slot="2222089936">
Related Posts:
Source: http://top-10-list.org/2015/05/15/now-you-have-a-list-of-unique-customer-numbers-each-with-a-unique-customer-name-and-youre-done-with-sheet1-go-back-to-the-original-sheet-and-in-cell-f2-type-vlookup/
