LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
bassec
 
Posts: n/a
Default Percent Complete?


I am inputting large numbers of data in vertical columns. At the bottom
of the column, I would like to put a function in that shows the percent
complete of that column.

Basically, if one of the fields have data in it, it counts towards the
overall percentage complete.

So if 250 of 500 data fields have data, the percent on the bottom
should read 50%.

So, how do I do something like that?


--
bassec
------------------------------------------------------------------------
bassec's Profile: http://www.excelforum.com/member.php...o&userid=32888
View this thread: http://www.excelforum.com/showthread...hreadid=526927

 
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
Percent Complete? bassec Excel Discussion (Misc queries) 1 March 28th 06 08:11 AM
two columns percent in third Common Rock New Users to Excel 1 February 1st 06 11:52 PM
Percent Change Ralph D via OfficeKB.com Excel Discussion (Misc queries) 1 December 8th 05 08:18 PM
Formatting a number to look like a Percent without a percent sign David Iacoponi Excel Discussion (Misc queries) 2 September 15th 05 06:35 PM
percent formulas Ron Coderre Excel Worksheet Functions 0 May 20th 05 07:21 PM


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