Microsoft Office Forums - View Single Post - [Solved] Calculate differences between text cells?

Thread: [Solved] Calculate differences between text cells?

View Single Post

Old

05-18-2012, 03:39 PM

Colin Legg Colin Legg is offline

Colin Legg is offline

Colin Legg uses Windows 7 32bit

Windows 7 32bit Colin Legg uses Office 2010 32bit

Colin Legg uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Colin Legg will become famous soon enough

Default

Hi,

If they're always 6 characters long then the usual, native formula approach can be simplified to this:

Code:

=SUM(--(MID(A3,{1,2,3,4,5,6},1)=MID(A2,{1,2,3,4,5,6},1)))

Reply With Quote