• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Please help me to indentify the particular data cell.

sampath

Member
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
 

Attachments

  • sample for indetify.xlsx
    15.4 KB · Views: 3
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,
 

Attachments

  • sample for indetify.xlsx
    16 KB · Views: 2
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
 
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
 
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,
 
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
 
Back
Top