ukbulldog001
New Member
- Joined
- Jul 8, 2015
- Messages
- 23
- Office Version
- 2021
- Platform
- Windows
Hi,
I'm looking for a solution or a formula which could solve my problem.
[/URL][/IMG]
I want the "STATUS" column to be populated as per the value available in "COUNT" column which is always a numerical.
All the "STATUS" should state "PR" if any of the cells in range "COUNT" corresponding to the Sl.No. group is more then zero.
Table A should be turned into Table B.
Hope above image is easy to understand.
Any formula or a method would be helpful.
At present I'm using =IF(D3>0,"PR","") in A3 and then populate manually.
Thanks.
I'm looking for a solution or a formula which could solve my problem.
I want the "STATUS" column to be populated as per the value available in "COUNT" column which is always a numerical.
All the "STATUS" should state "PR" if any of the cells in range "COUNT" corresponding to the Sl.No. group is more then zero.
Table A should be turned into Table B.
Hope above image is easy to understand.
Any formula or a method would be helpful.
At present I'm using =IF(D3>0,"PR","") in A3 and then populate manually.
Thanks.