In the Summary Sheet: ColumnA seems to show the row of each new name (of
each client); seems fine. ColumnB displays all names, and just uniques, no
dupes; fine there too. ColumnC seems to get a little weird. I see a 14 on
row 14, and down a little, I see a 65 on row 65 and a 66 on row 66. This
didn't seem to correspond to anything particular on the main data sheet, but
when I looked into it a little further, i noticed that these numbers
correspond to rows of client names that have no #N/A at all!! All other
names have a combination of #N/A and company names!! This seems to be the
problem. The function only shows client names where no client has a single
#N/A. I fiddled with those #N/A things and forced one client to have company
names (copy, paste-special-value; no #N/As for this client) €“ that clients
name showed up on the Summary Sheet. When I did this, I got four names have
no #N/A at all. Ugh!!!!!!


Thanks for everything up to this point! I learned a thing or two through
this exercise!

Any ideas or just stop here?


Ryan---


--
RyGuy


"Max" wrote:

Could you test over there and confirm whether col D does return the required
list of uniques cust and col E their corresponding totals ?
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---