Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Range of Values with different column selection

I have arranged columns of data. In the first two columns I have chosen the
item to do and the supplier of the service. I need to add a value for the
service relative to the selection of the provider. My data sits in further
columns to the right each column according to the individual supplier who is
listed across the top row. I can arrange to select the supplier but am
getting lost in sorting the data ie cost per supplier.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Range of Values with different column selection


CharlieR;367261 Wrote:
I have arranged columns of data. In the first two columns I have chosen
the
item to do and the supplier of the service. I need to add a value for
the
service relative to the selection of the provider. My data sits in
further
columns to the right each column according to the individual supplier
who is
listed across the top row. I can arrange to select the supplier but am
getting lost in sorting the data ie cost per supplier.


*How to get further help with a workbook*
For further help with it why not join our forums (shown in
the link below) it's completely free, if you do join *you will have the
opportunity to add attachmnets to your posts* so you can add workbooks
to better illustrate your problems and get help directly with them. Also
if you do join please post in this thread (link found below) so that
people who have been following or helping with this query can continue
to do so. :)


--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=102877

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
Count Unique Values in 1 Column based on Date Range in another Column Brian Excel Worksheet Functions 14 May 17th 09 02:58 PM
averageif for a range of values in another column -ken Excel Discussion (Misc queries) 2 April 26th 09 02:52 AM
search from range in column 1 and print from corresponding values manu Excel Discussion (Misc queries) 1 October 23rd 08 06:05 AM
Identifying a selection of a selection of a range swimfast Excel Worksheet Functions 1 March 1st 07 02:51 AM
Counting a specific range of values within a column kenm Excel Discussion (Misc queries) 7 January 2nd 07 08:34 PM


All times are GMT +1. The time now is 05:57 PM.

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

About Us

"It's about Microsoft Excel"