find unique value

[udprocks]

Hallo AGain Masters,

Can anyone please how to find a unique value in given column,,,

suggest please: which formula i can use for it,,

i have uploaded a sample file for reference... with result column.

 

[Mike H..]

Hallo AGain Masters,

Can anyone please how to find a unique value in given column,,,

suggest please: which formula i can use for it,,

i have uploaded a sample file for reference... with result column.

Hi,

I don't follow the bit about unique but have a look at your workbook column K.

 

[udprocks]

Hi,

I don't follow the bit about unique but have a look at your workbook column K.

Hi mike.

Glad to see this its great , exact result i found with it,

If possible can u please define this formula for me if u have time , i want to know how its works,,,,

thanks a lot,,,,,,

 

[Mike H..]

Hi mike.

Glad to see this its great , exact result i found with it,

If possible can u please define this formula for me if u have time , i want to know how its works,,,,

thanks a lot,,,,,,

Hi,

Glad that worked and of course I'll explain have a look at the attached workbook

 

[Somendra Misra]

Hi Jitendra,

If all your web address going to contain "newdelhi" than you can also try below formula in J2 and copy down:

=MID(F2,FIND("newdelhi",F2)+9,FIND("|",SUBSTITUTE(F2,".","|",2))-FIND(".",F2)-1)

Regards,

 

[udprocks]

Hi Jitendra,

If all your web address going to contain "newdelhi" than you can also try below formula in J2 and copy down:

=MID(F2,FIND("newdelhi",F2)+9,FIND("|",SUBSTITUTE(F2,".","|",2))-FIND(".",F2)-1)

Regards,

Hi somendra sir,

thank you for response, here little bit update in this "no all web address not going to newdelhi here the cirties are mixedup"

 

[Somendra Misra]

That's why I said if newdelhi

Regards,

 

[udprocks]

Hi,

Glad that worked and of course I'll explain have a look at the attached workbook

thanks a lot Milke sir, for description of formula, it helps me lot in future..

thanks again.

and somendra sir,

thank you for sahring your formula also its helps me for my daily routine.

many thanks Both sir's....