For users of

microsoft excel

Re: Urgent help needed Yes, you are taking one item in one list, and Matching it to the entire column. If there is a duplicate the formula will return a number which is the row Posted - Tue Nov 24, 2009 2:28 pm	Spear, Ted (US - MGTTS) ted_spear Offline Send Email
bar chart trendline overflow into other range http://www.flickr.com/photos/johnbullas/4131131154/sizes/l/ any way to make the trendline extend only over the bars representing the values for that range Posted - Tue Nov 24, 2009 2:23 pm	Dr John C Bullas johnbullas Offline Send Email
Re: Urgent help needed ... PS. If the data list is large it might be better to use a real database such as Access where you can set input values to be unique. -- Neil Ives A: Because Posted - Tue Nov 24, 2009 2:05 pm	Neil Ives neilivesathome Offline Send Email
Re: Urgent help needed ... A quick solution that may work for you: Sort both columns into Product code order, (this will bring all identical numbers together). In the next free Posted - Tue Nov 24, 2009 1:56 pm	Neil Ives neilivesathome Offline Send Email
Re: Urgent help needed Thank you Ben for your help ! Would this still work if the product code and product names are being repeated in the list. Thanks ! Kashan Sent From My Windows Posted - Tue Nov 24, 2009 1:28 pm	Kashan adeem_kashan Offline Send Email
Add ms_excel to your personalized My Yahoo! page What's This?

Related Link:	http://office.microsoft.com/en-us/excel/default.aspx
Post message:	ms_excel@yahoogroups.com
Subscribe:	ms_excel-subscribe@yahoogroups.com
Unsubscribe:	ms_excel-unsubscribe@yahoogroups.com
List owner:	ms_excel-owner@yahoogroups.com

Questions in Computers & Internet > Software