Excel Help - Find within a cell

[Dolby]

In the situation below, I have 12 x data samples in column A
Of these, there are 6 x in column B

Is there anyway to highlight the 6 or somehow identify the 6?
In other words, if B is in A, then highlight ?
Or even make column C the balance?

Hope that makes sense

 

[DapperDanMan]

Yes, Bill's Boys would have thought of that.

 

[RedViking]

@TribbleZA is the excel queen.

 

[saor]

Hmmm not sure about excel. In Sheets you could use conditional formatting on the two columns:

=COUNTIF($A$1:$B$6,A1)>1

 

[ChuckMeFarley]

In the situation below, I have 12 x data samples in column A
Of these, there are 6 x in column B

Is there anyway to highlight the 6 or somehow identify the 6?
In other words, if B is in A, then highlight ?
Or even make column C the balance?

Hope that makes sense

View attachment 1603168

Highlight both columns.
Home > conditional formatting > new rule
Format only unique or duplicate values > format > Fill tab and select color.

 

[Dolby]

Highlight both columns.
Home > conditional formatting > new rule
Format only unique or duplicate values > format > Fill tab and select color.

Thank you!

 

[Tman*]

In the situation below, I have 12 x data samples in column A
Of these, there are 6 x in column B

Is there anyway to highlight the 6 or somehow identify the 6?
In other words, if B is in A, then highlight ?
Or even make column C the balance?

Hope that makes sense

View attachment 1603168

Use XLOOKUP

Open cell c1, open xlookup
Lookup value is cell B1
Lookup array and return array is column A
Leave the rest blank. Hit enter.
Then drag the formula down in column C

The 6 will be duplicated in column C

 

[TribbleZA]

@TribbleZA is the excel queen.

There are plenty of people who know Excel really well.

 

[RedViking]

You can just ask ChatGPT

Now what is the fun in that.

 

[TribbleZA]

Now what is the fun in that.

You actually good - I really do get a lot of use out of that AI. I hate reminding people that they need to pay - and she does it sooooo nicely!

 

[UB40]

I went to High School with @TribbleZA . I will ask her on WhatsApp for the solution to your query. She travels around the country giving Excel courses to people in companies.

 

[TribbleZA]

I went to High School with @TribbleZA . I will ask her on WhatsApp for the solution to your query. She travels around the country giving Excel courses to people in companies.

I did - after COVID the world became tech-savvy and we do a lot online now.

 

[Paul Kemp]

You’re welcome.

 

[Jan van Riebeeckstad]

I went to High School with @TribbleZA . I will ask her on WhatsApp for the solution to your query. She travels around the country giving Excel courses to people in companies.

She hot?

 

[UB40]

She hot?

Was hot 35 years ago

 

[Jan van Riebeeckstad]

Was hot 35 years ago

I guess I don't need excel training anymore