Two values to find on the same cell

Solved/Closed

jutulu Posts 34 Registration date Monday March 10, 2014 Status Member Last seen September 21, 2015 - Apr 1, 2014 at 01:51 PM
jutulu Posts 34 Registration date Monday March 10, 2014 Status Member Last seen September 21, 2015 - Apr 7, 2014 at 04:06 PM

Hi,
Can the below be shorten up? It's basically to count if "dr" or "ba" are in cell E2180;

=IF(ISNUMBER(SEARCH("(dr)",E2180)),"1",IF(ISNUMBER(SEARCH("(ba)",E2180)),"1",""))

Thank you for your help

Based on the values in cells b77
Based on the values in cells b77 b81 what function can automatically - Best answers
Based on the values in cells b77:b81 what function can automatically - Best answers
Return Seq Values Until Blank value then return different set of seq values ✓ - Excel Forum
Based on the values in cells b77 b88 - Excel Forum
Instagram account based in wrong country - Instagram Forum
Based on the values in cells b77 b81 ✓ - Excel Forum
Excel macro to create new sheet based on value in cells - Guide

2 responses

Answer 1 / 2

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Apr 7, 2014 at 12:01 PM

Hi Jutulu,

So you basically want to know if either "(dr)" or "(ba)" are present in E2180 (you are not counting).

Another way to get that result is to use:
=IF(OR(ISNUMBER(SEARCH("(dr)",E2180)),ISNUMBER(SEARCH("(ba)",E2180))),1,"")

Which is 6 characters shorter (or 4 if you want to put the 1 on the left side of the cell).

To answer your question: YES

Best regards,
Trowa

Answer 2 / 2

jutulu Posts 34 Registration date Monday March 10, 2014 Status Member Last seen September 21, 2015 2
Apr 7, 2014 at 04:06 PM

Thanks. It works great

Similar discussions

help me to add particular cells

Hello,

i want to sum particular cells when a number consists in a cell

eg:-

=IF($B$81:$BH$81=7=TRUE,SUM($B$77:$BH$77),0)

it calculates all b77 to bh77 if any cell b81 to bh81 contains 7
i want a formula to calculate like if

b81=7, x81=7, ...... , bh81=7....

sum(b77+x77+......+bh77)

please help me to solve this issue..

Fill adjacent cell with number from text answer

Hello, and good morning, I have a cell with a dropdown box, to select a certain text. When I select the type of incident from a drop down box, I would like the adjacent cell to poulate with the number (eg Minor injury = 4) I have to do it for the three blank columns Any help will be much appreciated. Thanks, Mitch.

Excel function question

Hello,

Which spreadsheet function in Excel will display 6 as the output in the following formula?

=(36)

Name Values

Hi

I have a sheet of people's names in C8 : C59 and D8 : D59. I would like a formula that can check these ranges and if it sees a specific name it adds +1 to another cell, yet to be determined.

Any help would be most grateful.

Clear cell contents based on value of another cell range using VBA

I'm new to all of this and I'm stumbling through as best as I can so forgive me if I don't explain this very well.

I have a workbook that has over 180 worksheets in it.

I store ongoing data on each worksheet in cells a6:i6 through a2506:i2506.

At the start of the new year I only need to keep "Active" data.

I want to be able to compare cell b6 through b2506 individually and make sure it doesn't match ANY cell in the range k8:k508 collectively and then clear contents of range a:i for each row b6:b2506 that doesn't match.

I can't use a simple compare b to k because column k is a consolidated (removing duplicates) list of...

Similar discussions

Subscribe To Our Newsletter!