LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 192
Default Excel programming - scanning values, populating cells - please hel

Hello

Please help.

I'm trying to program Excel to run down a column of values, taking values
that are over average(values) + stdev(values) and populating another
worksheet with the adjacent reference for these values.

for example

If I have company registration numbers in one column and their credit risk
rating in another column. I want excel to populate another worksheet with the
company names that have a credit risk rating which is above average(values) +
stdev(values).

I can do this manually, but I want add a button so that my colleagues can
perform the same action with exactly the same result.

Any hints would be much appreciated and I would be will to make a donation

Many thanks in advance, Nick
 
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
populating a cell based on another range of cells in excel Chris O'Neill Excel Discussion (Misc queries) 2 July 16th 07 10:20 PM
Not ALL values are populating to Combobox for some reason. Why ? Corey Excel Programming 4 February 19th 07 10:08 PM
check for non-blank cells in Microsoft Excel VBA Programming [email protected] Excel Programming 2 January 22nd 06 01:49 PM
Populating a listbox with values from a sheet. shenlingstyle[_2_] Excel Programming 5 November 22nd 05 08:19 PM
Scanning cells to get their value Gnappo Excel Programming 3 June 1st 04 05:55 PM


All times are GMT +1. The time now is 12:22 PM.

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"