G
gizmo
Hi guys,
I'm currently looking for the most efficient way to verify, if the value
that is just introduced to the excel file exists already somewhere on the
same worksheet.
I've thought already about some intuitive visualisations. F. ex.: once the
value is introduced, and if another value equal to this one already exists,
the conditional formatting makes all concerned cells change the color (f.x.
for blue if there are only 2 such values, green if 3, yellow if 4 or above).
Second idea: the amount and addresses of concerned cells apprear in an
additional column.
In case these ideas are easy to put in place, pls indicate me the way how
should I proceed.
But maybe I'm missing some way that is more professional, more
straighforward and less "childish"?
Pls let me know your ideas on this.
Thanks in advance!
Gizmo
I'm currently looking for the most efficient way to verify, if the value
that is just introduced to the excel file exists already somewhere on the
same worksheet.
I've thought already about some intuitive visualisations. F. ex.: once the
value is introduced, and if another value equal to this one already exists,
the conditional formatting makes all concerned cells change the color (f.x.
for blue if there are only 2 such values, green if 3, yellow if 4 or above).
Second idea: the amount and addresses of concerned cells apprear in an
additional column.
In case these ideas are easy to put in place, pls indicate me the way how
should I proceed.
But maybe I'm missing some way that is more professional, more
straighforward and less "childish"?
Pls let me know your ideas on this.
Thanks in advance!
Gizmo