I need a macro that compares a list of words
Closed
dcfyi
-
Sep 5, 2010 at 05:19 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 6, 2010 at 06:21 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 6, 2010 at 06:21 AM
Related:
- I need a macro that compares a list of words
- My contacts list names - Guide
- Counter strike 1.6 cheats list - Guide
- How to change your best friends list on snapchat to 3 - Guide
- Whatsapp country code list - Guide
- Amd crossfire compatibility list - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Sep 6, 2010 at 06:21 AM
Sep 6, 2010 at 06:21 AM
i do not know the purpose of this . you need not have a macro suppose colulmn C
from c1 down is like this
s
f
d
a
g
h
j
k
In column F is the list
s
f
j
in D1 type this formula
=COUNTIF($F$1:$F$3,C1)
copy D1 down.
the C value in the row where you get the first 0 you get column D is your cell
for e.g. in the above case it is C3.
from c1 down is like this
s
f
d
a
g
h
j
k
In column F is the list
s
f
j
in D1 type this formula
=COUNTIF($F$1:$F$3,C1)
copy D1 down.
the C value in the row where you get the first 0 you get column D is your cell
for e.g. in the above case it is C3.
