Calculate differences between text cells?

		Microsoft Office Forums > Microsoft Excel > Excel
Calculate differences between text cells?

05-18-2012, 03:39 PM

Colin Legg Colin Legg is offline

Windows 7 32bit Calculate differences between text cells?

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

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)))

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Wraping merged cells text - the text dissapears	shabbaranks	Excel	1	03-02-2012 02:35 AM
Combining Text from Table Cells	robmorleyuk	Word	1	11-01-2011 07:24 AM
Question regarding differences among styles	bigsnowdog	Word	0	08-01-2010 02:41 PM
Cells with wrap text not showing text	lazylew	Excel	1	08-31-2008 06:58 AM
How to get cells to calculate time?	jrasche2003@yahoo.com	Excel	2	02-09-2007 07:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:33 AM.