thbutterflycollector_
New Member
- Joined
- Oct 29, 2015
- Messages
- 42
- Office Version
- 365
- Platform
- Windows
I have a cost ledger which is being reviewed by two parties - they can both allocate it a unique reference number.
Originally the formula was set up so that only one party could review (and I have a dynamic data validation for that):
=FILTER('Disallowed'!$C$7:$C$56,COUNTIF(Raw Data'!N:N,'Disallowed '!$C$7:$C$56)=0)
However I need to update the formula so that another party can also allocate it a reference number in Column AO on the Raw Data Sheet.
On the Raw Data Tab based on single column entry the data validation formula was working fine in Column N:
=IF(M12="False",'Disallowed'!$B$7#)
I've added in another data validation formula in Column AO
=IF($AN12="Yes",$N4, 'Disallowed Cost Register'!$B$7#)
However, Column N is now showing the same unique references twice. I suspect the problem is in the Filter / Countif Formula. Can anyone advise as to how I can capture the second set of unique reference numbers in Column AO?
Originally the formula was set up so that only one party could review (and I have a dynamic data validation for that):
=FILTER('Disallowed'!$C$7:$C$56,COUNTIF(Raw Data'!N:N,'Disallowed '!$C$7:$C$56)=0)
However I need to update the formula so that another party can also allocate it a reference number in Column AO on the Raw Data Sheet.
On the Raw Data Tab based on single column entry the data validation formula was working fine in Column N:
=IF(M12="False",'Disallowed'!$B$7#)
I've added in another data validation formula in Column AO
=IF($AN12="Yes",$N4, 'Disallowed Cost Register'!$B$7#)
However, Column N is now showing the same unique references twice. I suspect the problem is in the Filter / Countif Formula. Can anyone advise as to how I can capture the second set of unique reference numbers in Column AO?