Need help with commando or formula in Excel

[fsalde]

Hi all,
I am struggling with a issue and I can't figure out a formula to use to get the output as the pic chose. What I have is a list of different domain names in column A IE fred.se, fredtest.com, fred2020.org etc. In column B I have the TLD IE .se, .com, .org etc and in column C I have the brand name IE fred, fredtest, fred2020 etc. All that data I would then like to use a formul or commando inside Excel so it take all data in sheet A and provide the output in sheet B and show me as the picture with what they have and what they do not have. Anyone who can help me solve this issue because I am getting grey hairs. Thanks a lot.

[TMS]

Attach a workbook with some typical data.

[MarvinP]

Hi fsalde,
Seems like you want to count the number of "x" in your column range. That would be "=Countif(range,"X")"

[TMS]

@MarvinP: I think he might want us to build that table from data elsewhere that we cannot see.

[fsalde]

Correct. I attache an example. The data in Sheet A should end up as showed in Sheet B so I can see what they have and not have. I had a commando ones but forgot about it.

Thanks!
Fred

[TMS]

Cell B2:

Please Login or Register  to view this content.

copied across and down.

Use Conditional Formatting for the colour(s)

[fsalde]

OK, thanks! Any idea what I should use in swedish since the formula you provided did not work with my EXCEL. Many thanks!

[fsalde]

Or if easier send me an updated sheet with the formulas you mean I should use and I can open the sheet and use that version since it should be compatible with Excel no matter language. Thanks!

[TMS]

See: http://easy-excel.com/excel-in-other...as-in-swedish/

[fsalde]

Thanks, but when I try that:
=OM(ANTALOM('Sheet A'!$A:$A,$A2&B$1),"x","")

I get error message: There is an error in the formula. If you write 1 + 1, the cell will show you: 2. If you do not want that add a ´ before: ´= 1 + 1. But I still do not get it to work. Any idea what to do?

Thanks!

[TMS]

Change the commas ( , ) to semi-colons ( ; ). It will be your Regional Settings.

[fsalde]

Sorry for being a pain.... but now I get #NAMN? any idea what I need to do to get what I am looking for? See attached screenshot, THANKS!

[TMS]

I'll get back to you later with the workbook.

[fsalde]

I'll get back to you later with the workbook.

THANKS! Much appreciated. Really want to know how to do it =)

[Fluff13]

The formula should be
=OM(ANTAL.OM('Sheet A'!$A:$A;$A2&B$1);"x";"")

This site translates formulae for you
https://en.excel-translator.de/translator/

[fsalde]

We are getting close =). Now I get X for all the names, but what I would like to get is that have all the TLDs horizontal and an X for the TLDs and names that they have and where it is empty, they do not have it. See Example2.

Thanks!

[TMS]

Yep, ...

COUNT ANTAL
COUNTA ANTALV
COUNTBLANK ANTAL.TOMMA
COUNTIF ANTAL.OM
COUNTIFS ANTAL.OMF

[fsalde]

So how should the formel look like and should I create it in Sheet C (new that I create) or how do I do it? Thanks!

[TMS]

Here's the workbook