Please help me to indentify the particular data cell.

[sampath]

Hello,

Need to identify the particular data cell from huge data. here i have attached the example file. In that example, marked cell only need identify.

Kindly help me for the same.

Regards,
Sampath.S

 

[Khalid NGO]

Hi Sampath,

See if it is okay:

i have used CF:
=OR(A1="152 SE3105 - R - DD",A1="R2 SE3105 -",A1="R2 SE3105 - R - DD",A1="R376 SE3105 - R",A1="1218 SE3105 - R",A1="938 SE3105 -")

Regards,

 

[sampath]

Hi Khalid NGO,

Thanks for your reply,

I have lot of files as example file, and "SE" character only standard for all the files,

I need to identify the cell, which has any character before "SE".

please consider my point.

Regards,
Sampath.S

 

[Khalid NGO]

Ok, can you confirm the result with this CF:
=SEARCH("SE",A1)>SEARCH("*SE",A1)

Regards,

 

[sampath]

Hi Khalid NGO,

My request is macro for searching "*SE" for the range A1 - NZ200 and highlighted by any color in cells.

Kindly consider my request.

Regards,
Sampath.S

 

[Khalid NGO]

Hi Sampath,
Question: Macro necessary ?

Above CF will highlight the same, you just need to update CF range: =$A$1:$AK$37 to =$A$1:$NZ$200

Regards,

 

[sampath]

yes. It's necessary for above request and need one more condition for this macro.

Need to delete "N°" and remove second row in order wise.

Thanks with regards,
Sampath.S

 

[Khalid NGO]

yes. It's necessary for above request and need one more condition for this macro.

Need to delete "N°" and remove second row in order wise.

Thanks with regards,
Sampath.S

Sorry sampath,
Wait for someone for the macro.