LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
william4444
 
Posts: n/a
Default Extracting Top 5 & Bottom 5 Variance for Revenu/Expendenture & Net Position


Hi All,

if i had coloumns that had the title Revenue, Expenditure & Net
Position & under neath these Headings a row for each Revenue,
Expendenture & Net Position called Actuals then Budget then Variance.
My Question is what i would like is to be able to only have the Top 5 &
Bottom 5 Variances in all 3 Headings Revenue, Expendenture & Net
Position. How can i achieve this please. Would appreciate all the
help.
Thank you. Also each time i try to insert an attachment in this letter
being excel it comes up as failure, why is this


--
william4444
------------------------------------------------------------------------
william4444's Profile: http://www.excelforum.com/member.php...o&userid=33991
View this thread: http://www.excelforum.com/showthread...hreadid=553643

 
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
Extracting Top 5 & Bottom 5 Variance for Revenu/Expendenture & Net Position william4444 New Users to Excel 0 June 20th 06 03:38 PM
XL97: Position text boxes (or data labels) w/out VBA LeAnne Charts and Charting in Excel 1 December 1st 05 09:07 PM
Pivot Tables - Variance and % Variance fields CraigS Excel Discussion (Misc queries) 5 January 6th 05 12:22 AM


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