Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
either use a pivot table or the function SUMIF

--
Regards
Frank Kabel
Frankfurt, Germany
"Wes" schrieb im Newsbeitrag
...
I've got a list of entries in 2 columns column A has names in it, column B
has numbers. I'd like to look at trends and make a line chart of the
numbers
that correspond to certain names in column A. Is there an array formula
or
somthing to make a new list with only the values corresponding to a
certain
name?

Thanks in advance for your help.

Wes



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Zero values in a log chart Joelle_Smith Charts and Charting in Excel 2 May 8th 23 03:42 AM
Second serie doesn't use X-as values JackRnl Charts and Charting in Excel 1 January 20th 05 01:04 AM
project values based on other values Gabriele Excel Discussion (Misc queries) 1 January 7th 05 09:27 AM
Linked values turn to #REF! after clicking don't update John Perkins Excel Worksheet Functions 2 December 1st 04 07:53 PM
If I have X,Y data how do I sum the Y values using a set of bins based on x values ScottBerger Excel Worksheet Functions 1 November 16th 04 11:48 PM


All times are GMT +1. The time now is 04:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"