everton1878
New Member
- Joined
- Jul 27, 2010
- Messages
- 2
Hi All,
I have a spreadsheet used for tracking product. To simplify it basically i have a list of product in column a. Column b is known as my issue column. Items that don't have an issue stay blank. Items that have an issue have a "1" entered into this column. When an issue is resolved, this is then changed to a zero via manual input. What i need to do is:
In just one cell i need it to display the date that last time an issue was resolved.
So in essence i need: when a 0 is entered anywhere in column b, cell ?? needs Now() inserting into the cell.
I was hoping to do this somehow without a macro but can't think how. If anyone has any ideas either way would be fantastic.
Thanks
I have a spreadsheet used for tracking product. To simplify it basically i have a list of product in column a. Column b is known as my issue column. Items that don't have an issue stay blank. Items that have an issue have a "1" entered into this column. When an issue is resolved, this is then changed to a zero via manual input. What i need to do is:
In just one cell i need it to display the date that last time an issue was resolved.
So in essence i need: when a 0 is entered anywhere in column b, cell ?? needs Now() inserting into the cell.
I was hoping to do this somehow without a macro but can't think how. If anyone has any ideas either way would be fantastic.
Thanks