Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Use one column to identify values in adjacent column.

I would like to average 6 sets of columns. Each set has
one descriptive and one value column. ex: A3=5 B3=12%,
C8=5 D8=21%, E14=5 F14=9%, etc. I want to ID all the
columns with 5, but average their percentage. I dont want
to re-sort each list so that all fives and values are on
the same row. How do I write the formula? Thanks, Ken F.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Use one column to identify values in adjacent column.

I'm not a real expert so someone may have a more elegant
solution but I had to do something like this beore.

Write a macro which loops through all the cells in your
range and use a distinct variable to accumulate all the
values in each column using an IF statement (ie. IF
celColA=5 then sumColB= sumColB + value in B). If there
are different numbers of percentages you may have to add
a variable to count up the number of cells to compute
your average. Remember you have to initilize your
variables to = 0 before you start.

Hope this helps.

Jack
-----Original Message-----
I would like to average 6 sets of columns. Each set has
one descriptive and one value column. ex: A3=5 B3=12%,
C8=5 D8=21%, E14=5 F14=9%, etc. I want to ID all the
columns with 5, but average their percentage. I dont

want
to re-sort each list so that all fives and values are on
the same row. How do I write the formula? Thanks, Ken

F.
.

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
i wish to lookup values in column A, & add adjacent values in colu Browny Excel Discussion (Misc queries) 4 September 26th 08 05:00 PM
how can i identify three highest values in a column (not sort) Mistysweep Excel Discussion (Misc queries) 3 July 29th 06 12:58 PM
summing values from adjacent column with refrence from adjacent column Pivotrend Excel Discussion (Misc queries) 6 March 4th 06 12:24 PM
Sum up values from adjacent column Pivotrend Excel Discussion (Misc queries) 4 February 21st 06 12:08 PM
To copy values in a column relevant to text in an adjacent column? Guy Keon Excel Worksheet Functions 2 November 15th 05 09:10 PM


All times are GMT +1. The time now is 12:53 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"