Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I COUNTIF from previously counted data? | Excel Worksheet Functions | |||
i made a list box but i need to link data to it | Excel Worksheet Functions | |||
how do I enter more data to an already made pull down menu | Excel Discussion (Misc queries) | |||
I've put data to columns - counted - need dropdown filter | Excel Discussion (Misc queries) | |||
How do I find an unknown value on a line made from known data? | Excel Discussion (Misc queries) |