#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
|
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 |