Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-18-2013, 09:37 AM
babapusy babapusy is offline How to ignore the in between cells? Windows XP How to ignore the in between cells? Office 2010 32bit
Novice
How to ignore the in between cells?
 
Join Date: Apr 2012
Posts: 2
babapusy is on a distinguished road
Default How to ignore the in between cells?

Hello people,

I have problem creating a formula that need to do the following:

(A and B represent the columns, 1 through 7 are rows)
- |A B
1 |5 s
2 |7
3 |5 b
4 |9
5 |3 b
6 |5
7 |6 s

If in column B there is "s" letter, the formula has to find the first "b" letter after the last "s", and to subtract from column A the first "b" from the last "s" (in the example A7-A3), and to ignore the in between "b" letters (in the example above there is one "b" letter in between, but there might be more than one in some cases)

Thank you. I hope someone can make my day.


baba

P.S. please no VBA code
Reply With Quote
  #2  
Old 01-21-2013, 03:05 AM
OTPM OTPM is offline How to ignore the in between cells? Windows 7 32bit How to ignore the in between cells? 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
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to ignore the in between cells? 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
How to ignore the in between cells? 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
How to ignore the in between cells? 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 03:13 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft