Thread: Excel Help please. Group by columns? not sure of the correct
View Single Post
jyl jyl is online now
Registered
 
jyl's Avatar
 
Join Date: Jan 2002
Location: Nor California & Pac NW
Posts: 24,863
Garage
OK, I flamed out, my way doesn't work because in the actual data, the values in each column are not unique, so VLOOKUP won't know which value to return.

I couldn't think of a way to do what Neil wants w/o using VB code. Can anyone else help?
__________________
1989 3.2 Carrera coupe; 1988 Westy Vanagon, Zetec; 1986 E28 M30; 1994 W124; 2004 S211
What? Uh . . . “he” and “him”?
Old 01-22-2010, 02:24 PM
  Pelican Parts Catalog | Tech Articles | Promos & Specials    Reply With Quote #8 (permalink)