If you just don't want to see the value, you could use conditional formatting over A1:A11 with a formula of =COUNTIF($A$1:$A1,$A2) and set the font colour...
Bob Phillips Yesterday, 05:22 PMHi and welcome
Please,do not crosspost your question on multiple forums without including links here to the other threads on other forums. ...
Hi,
I'm currently creating a macro for allocation base on worker's skills matrix set.(determined by Y or N). So if the member is Y, worker...
workload allocation w/ skills matrix
Cross-posted (and answered) at: https://chandoo.org/forum/threads/wo...-matrix.43173/
macropod Yesterday, 09:40 PMAlso cross-posted at:
https://www.excelforum.com/excel-pro...ls-matrix.html...