How to ignore the in between cells?

		Microsoft Office Forums > Microsoft Excel > Excel
How to ignore the in between cells?

FAQ

Thread Tools

Display Modes

01-21-2013, 03:05 AM

OTPM

Windows 7 32bit How to ignore the in between cells?

Office 2010 32bit

Expert

Join Date: Apr 2011

Location: West Midlands

Posts: 981

Hi
Unfortunately I am not going to make your day

.
Formulae can only work on static cells or ranges. You cannot use a formula to search cells and then move on to the next. You can only do this using (potentially) complex VBA.
Tony

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How-TO format cells (FILL) by comparing cells	zanat0s	Excel	1	07-03-2012 04:27 AM
Ignore Resource Work Times	JR_12	Project	2	12-05-2011 06:35 PM
Ignore Duplicate Emails	IanKM	Outlook	1	10-20-2011 11:02 AM
Count range cells eliminating merge cells	danbenedek	Excel	0	06-15-2010 12:40 AM
Ignore a section in grammar checker	stlsailor	Word	1	07-28-2009 12:45 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:59 PM.