Need help figuring out a formula or macro
Closed
John
-
Aug 27, 2011 at 05:06 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 28, 2011 at 09:58 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 28, 2011 at 09:58 PM
Related:
- Need help figuring out a formula or macro
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Credit summation formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
3 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Aug 28, 2011 at 03:20 AM
Aug 28, 2011 at 03:20 AM
the data from A1 is like this
name data
a a
s d
d g
f j
g w
h e
j r
k t
l
in C2 type ( copy) this formula
=IF(COUNTIF(A2:A100,B2)=1,"duplicate","")
copy c2 down
you will get
name data
a a duplicate
s d duplicate
d g duplicate
f j duplicate
g w
h e
j r
k t
l
provision made for 100 data in column A
name data
a a
s d
d g
f j
g w
h e
j r
k t
l
in C2 type ( copy) this formula
=IF(COUNTIF(A2:A100,B2)=1,"duplicate","")
copy c2 down
you will get
name data
a a duplicate
s d duplicate
d g duplicate
f j duplicate
g w
h e
j r
k t
l
provision made for 100 data in column A
Not exactly what I'm looking for. Let me try to explain it again. If a cell in column C if found anywhere in column A, then "duplicate" must be written in column B next to the cell of column A where the duplicate cell was found.
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Aug 28, 2011 at 09:58 PM
Aug 28, 2011 at 09:58 PM
the logic remains the same
can you simply put the formula in B2 with words B2 changed to C2 Try on your own and it will be a pleasure to modify a formula given by another person. if there is problem post back
can you simply put the formula in B2 with words B2 changed to C2 Try on your own and it will be a pleasure to modify a formula given by another person. if there is problem post back
