Re: $$Excel-Macros$$ formula base on condition

2012-08-09 Thread pawel lupinski
Don/Prince,   Thanks a lot   pawel From: dguillett1 To: excel-macros@googlegroups.com Sent: Wednesday, August 8, 2012 8:15 PM Subject: Re: $$Excel-Macros$$ formula base on condition =IF(AND(LEN(D3)<>LEN(M3),RIGHT(D3,8)=RIGHT(M3,8)),L3,""

Re: $$Excel-Macros$$ formula base on condition

2012-08-08 Thread dguillett1
=IF(AND(LEN(D3)<>LEN(M3),RIGHT(D3,8)=RIGHT(M3,8)),L3,"") Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Wednesday, August 08, 2012 12:45 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ formula base on c

$$Excel-Macros$$ formula base on condition

2012-08-08 Thread pawel lupinski
Hi All,   I'm looking for formula that will be checking cell base on the condition that last 8 digits will be match, with 8 digits from different cell. Pls see attachement.   Regards,   Pawel -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (112