Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Need data counted when changes are made

Hi,

I am working on an excel document right now and I am wondering if there is a
formula or table that I can used to help speed up my manual process I am
doing at the moment.

I currently track issues that come through our systems in rows we have the
issue the client may or may not have and then in the columns we have the
client name and the version of software they are on. As we test for the
defects we update the columns with our initials and results and track from
there. Currently I am counting the changes manually but I want to automate
it. The problem is that several people are in the spreadsheet and there is
no standard identifier we use in the columns. Sometimes you can have complex
set of numbers for tracking in the column.

What I am needing is for Excel to track the number cells that have no data
in them, the ones that have data in them, and then auto count the changes
that are made to each cell as the blanks fill up.

Any help would be greatly appreciated.
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
How do I COUNTIF from previously counted data? John Excel Worksheet Functions 1 September 13th 06 12:47 AM
i made a list box but i need to link data to it Marie Excel Worksheet Functions 2 February 20th 06 03:49 PM
how do I enter more data to an already made pull down menu Queenyvix Excel Discussion (Misc queries) 1 February 16th 06 08:10 PM
I've put data to columns - counted - need dropdown filter vic 2005 Excel Discussion (Misc queries) 0 September 1st 05 12:31 PM
How do I find an unknown value on a line made from known data? brendas182 Excel Discussion (Misc queries) 2 June 30th 05 03:33 AM


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