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

Trim Function and duplicate entries

S

Shabbo

Member
Dear Sir,

I have below formula to find entry numbers from lookup lists, but its not working because there is a space after vehicle number in lookup list I wanted to include trim function to remove space automatically instead of doing it manually every time.

=INDEX(LookupLists!C:C,MATCH(1,IF(LookupLists!A:A=Sheet1!$C2,IF(LookupLists!B:B=Sheet1!$E2,1)),0))

My second question is that I wanted to highlight duplicate entries based on type of expenses

If the entries are coming twice for same expenses then entry number should be highlighted red.

If the entries are coming twice but expenses are difference type then it should look normal.
 

Attachments

  • Cash and Bank report question.xlsx
    53.4 KB · Views: 2
Dear Sir,
Thanks Its worked, but can you please apply conditional formatting for duplicate entries with same nature of expenses.
 
Dear Sir,
Conditional formatting is not working on the basis of nature of expenses it just working on the basis of entry number only.
 
Dear Sir,
Column C, Column E, and Column G together if coming twice then Column B should highlight as double entry.
 
Dear Sir,
Its not working, if I put same vehicle twice instead of getting highlighted I am getting NA please refer yellow highlighted cell.
 

Attachments

  • Example 11.xlsx
    38.8 KB · Views: 2
You must log in or register to reply here.
Back
Top