#Found Duplicate & set Hyphen Symbol - via Formula based

[krunal123]

I Need Hyphen " - " Symbol via Formula,
Unique Number based Condition , Found Duplicate & set Hyphen Symbol - in D Coloumn

 

[hrayani]

Can you share your data viz xl2bb addin
What formula you are using in columns C & D right now ??

 

[krunal123]

Can you share your data viz xl2bb addin
What formula you are using in columns C & D right now ??

Not using Formula in this case kindly Send formula in this case

 

[hrayani]

Not using Formula in this case kindly Send formula in this case

Ok but where did the value in cell D2 YZ-EXM come from ???

 

[krunal123]

Ok but where did the value in cell D2 YZ-EXM come from ???

Condition :


Bill No.... Found Duplicate , D column set Hyphen Symbol , Because I need Unique Entry

Pleased make Formula

 

[hrayani]

TEST FILE.xlsm
	C	D
1	Bill No	Party
2	EXP-125	Found Duplicate
3	EXP-125	-
4	EXP-125	-
5	EXP-125	-
6	EXP-001	Found Duplicate
7	EXP-001	-
8	EXP-001	-
9	EXP-001	-
10	EXP-018	Found Duplicate
11	EXP-018	-
12	EXP-018	-
13	EXP-018	-
Sheet4

Cell Formulas
Range	Formula
D2:D13	D2	=IF(C1<>C2,"Found Duplicate","-")

 

[krunal123]

Column D Party need manually , how to remove "Found Duplicate" word , i try empty cell to Hyphen Symbol via formula

 

[hrayani]

you are still not clear with what you want or I am unable to get it

1) In which column do you need formulas
2) What is the desired result of the formula

 

[Peter_SSs]

Your requirement is not clear.

You have not answered the question

where did the value in cell D2 YZ-EXM come from ???