Excel - FIND function case-sensitive ignores case

0 votes

Does anybody know why this example's FIND function doesn't treat cases differently? The conditional formatting command

 =OR(ISNUMBER(FIND($B$1:$B$13,A1))))

was used on my table. And because FIND is case-sensitive, the word "Rektor" in column B causes the term "Prorektor" to be coloured in column A, even though it shouldn't, or did I do it wrong?

enter image description here

Also, if anybody knows why the first cell of my array seems to stay unaffected by the formula, I'd be happy to hear it! I'm using Excel Version 2301.

Apr 3, 2023 in Others by Kithuzzz
 • 38,000 points • 651 views

1 answer to this question.

0 votes

Just to show the behaviour of find():

enter image description here

answered Apr 3, 2023 by narikkadan
 • 63,600 points

Related Questions In Others

0 votes
1 answer

EXCEL: Count case sensitive criteria in one column if meets criteria in another column

You may try: The formula in B1: =MAP(A1:A12,LAMBDA(x,SUM(- ...READ MORE

answered Feb 24, 2023 in Others by narikkadan
 • 63,600 points • 615 views
0 votes
1 answer

Is JavaScript a case-sensitive language?

Yes, JavaScript is a case sensitive language.  The language ...READ MORE

answered Mar 7, 2019 in Others by Frankie
 • 9,830 points • 5,837 views
0 votes
1 answer

Convert CASE WHEN logic from SQL to EXCEL

A combination of IF(), ISNUMBER(SEARCH()), and OR() ...READ MORE

answered Sep 21, 2022 in Others by narikkadan
 • 63,600 points • 1,159 views
0 votes
1 answer

Excel-VBA - How to identify Target range (more than 1 cell) is deleted in a Worksheet_Change function?

You misunderstand the purpose of the function ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
 • 63,600 points • 3,721 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
 • 13,690 points • 3,973 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
 • 13,690 points • 1,984 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
 • 13,690 points • 975 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18, 2022 in Others by gaurav
 • 23,260 points • 3,663 views
0 votes
1 answer

Is there a function in excel to find duplicates

Solution: You can use Conditional formatting inside the ...READ MORE

answered Nov 14, 2022 in Others by narikkadan
 • 63,600 points • 663 views
0 votes
1 answer

EXCEL-Function to find how many people does the oldest female live with

You can try something like this: =ROWS(FILTER(B11:B9291, T11:T9291=MAXIFS(T11:T9291,G11:G9291,2))) It ...READ MORE

answered Jan 13, 2023 in Others by narikkadan
 • 63,600 points • 618 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.