T
Tmeck
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.
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.