Home |
Search |
Today's Posts |
#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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to average data if in cells, but ignore blank cells. | Excel Worksheet Functions | |||
Match Dates in Two Cells and Ignore subsequent Cells | Excel Discussion (Misc queries) | |||
Count cells with numbers and ignore cells with errors | Excel Discussion (Misc queries) | |||
How do I count cells with text but ignore cells with spaces? | Excel Discussion (Misc queries) | |||
how can i ignore blank cells when multiple cells? | Excel Worksheet Functions |