LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
fomula problems
 
Posts: n/a
Default Worksheet problem

I have a worksheet which I would like to be able to use, but dont know how to
put a formula in to give me the info. have tried to enclose a sample hope it
works.
Would like to enter a 1 or 0 or A in the adjacent colum as soon, but would
like to be able to gather and show all 1 or 0 or A with the adjacent cell,
and would like the totaol number of cells to equal 100% when complet but to
be able show the percetage of cells completed. Can someone help me.
FC FC FD FD FE FE
FC002020 1 FD002020 1 FD002020 1
FC002030 FD002030 1 FD003020 1
FC002040 1 FD002040 0 FD004020
FC002050 1 FD002050 1 FD005020 1
FC002060 1 FD002060 1 FD006020 1
FC002070 0 FD002070 1 FD007020 A
FC003020 1 FD003020 A FD003020 1
FC003030 1 FD003030 1 FD003030 1
FC003040 FD003040 1 FD003040 1
FC003050 1 FD003050 1 FD003050
FC003060 0 FD003060 0 FD003060 1
FC003070 1 FD003070 1 FD003070 1

 
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
Offset to different worksheet problem edwardpestian Excel Worksheet Functions 3 May 5th 06 03:46 PM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM
Updating database worksheet problem (Template Wizard) grasping@straws Excel Discussion (Misc queries) 1 December 17th 04 02:26 PM
Indirect reference from one worksheet to another Bill Sturdevant Excel Worksheet Functions 2 December 17th 04 01:23 PM
Reference Data in Moved Worksheet tommcbrny Setting up and Configuration of Excel 1 December 1st 04 06:49 PM


All times are GMT +1. The time now is 12:23 AM.

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"