Iris Stein
New Member
Hi,
I am trying to find a formula that would automatically show the last time a salesman sent in an update about his sales. In this instance, salesmen send in their excel sheets and I collect the information and place it in a master cell. I also have a column showing the last update which I currently do manually but am assuming someone with more excel experience might have a way of doing automatically. When I do not have the information the table shows NA, but when I have the information a number appears. Can I create a formula that would show the last date for which I have a number and not NA in the cell? Please see attached example. Thanks in advance.
I am trying to find a formula that would automatically show the last time a salesman sent in an update about his sales. In this instance, salesmen send in their excel sheets and I collect the information and place it in a master cell. I also have a column showing the last update which I currently do manually but am assuming someone with more excel experience might have a way of doing automatically. When I do not have the information the table shows NA, but when I have the information a number appears. Can I create a formula that would show the last date for which I have a number and not NA in the cell? Please see attached example. Thanks in advance.