Thread: [Solved] How to ignore the in between cells?
View Single Post
 
Old 01-21-2013, 03:05 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default
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
Reply With Quote