Wrekin
New Member
- Joined
- Jan 31, 2022
- Messages
- 3
- Office Version
- 2010
- Platform
- Windows
Hi All,
I have a query relating to a formula that has been giving me a problem.
What I need is the column 'Review Number' to return a repeatable sequential count based upon the Date (Col B) and ID Number (Col D) entries, in other words the first ID 1234 (never to be duplicated again) has four entries, is the first ID Number checked and is therefore the Review Number (Col C) should return '1'. Likewise the second ID 5678 has three entries, is the second ID Number checked and is therefore Review Number '2' and so on upto Review Number '5', and a new Date is reached here the whole process of numbering from 1 should start again.
In column A I have the formula =countif($B$4:$B4,B4) this returns a sequential number which starts at 1 again once ROW 20 is reach (change of Date). I tried to adopt the same type of formula but just can't get it to work.
So please can anybody help with the formula in 'Review Number' Col B, TIA.
I have a query relating to a formula that has been giving me a problem.
What I need is the column 'Review Number' to return a repeatable sequential count based upon the Date (Col B) and ID Number (Col D) entries, in other words the first ID 1234 (never to be duplicated again) has four entries, is the first ID Number checked and is therefore the Review Number (Col C) should return '1'. Likewise the second ID 5678 has three entries, is the second ID Number checked and is therefore Review Number '2' and so on upto Review Number '5', and a new Date is reached here the whole process of numbering from 1 should start again.
In column A I have the formula =countif($B$4:$B4,B4) this returns a sequential number which starts at 1 again once ROW 20 is reach (change of Date). I tried to adopt the same type of formula but just can't get it to work.
So please can anybody help with the formula in 'Review Number' Col B, TIA.