I have a colmun of names in 12 worksheets, Jan.-Dec.,as random entries, with duplications. I want to pull each duplicate name as a "single name" entry into a separate sheet, col., as a recap sheet. I have each name uniquely coded and the "data range" uniquely named for each month.
I should be able to pull these names from all 12 sheets. I could do it by month if necessary.
Can anyone give me the correct function to pull "text" for this purpose.
A function that does the job similar to Dsum for numbers.
I understand Dsum function.
I plan then to use Dsum in order to pull numerical data for each name.
Damn, I knew Lotus 123 inside and out. Long ago.
Haven't done this in Excel. HELP is confusing me.
2006-07-25
09:26:20
·
3 answers
·
asked by
ed
7
in
Software