• 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.

Excel output error

farleymartinez

New Member
Hi

I have an excel outpout showing who transfered data.
There is an owner to the task to transfer and there are also sub task.

I need to identify cases where the MASTERTASK (column B) is repeating itself (can be many times) & the owner column (I) have different names.

In column J to add word exception.

Thanks in advance!!!
 

AlanSidman

Well-Known Member
Really! How about a sample file with clear instructions as to what you want. Also show a mocked up solution so that we can follow your needs. No pictures as we can not manipulate data in a picture. 8-10 records in your file is sufficient
 

petergroft

New Member
Select referenced cells. Find cells that your formula is referencing and select them.
Find and replace.
Replace spaces with nothing.
Replace or Replace all
Turn on the filter.
Set the filter.
Select any unnamed checkboxes
Select blank cells, and delete.

Hope This Works,
Peter
 
Top