Functions in excel

[NathalySuarez_25]

Hello,
I have the following concerns:

1. I’m trying to match different files with the VLOOKUP function, but it doesn’t allow it, is there a way to do it?
2. In excel, it is possible to add the function to count the number of cells by color

[Constantine]

Hello @NathalySuarez_25

@NathalySuarez_25

I’m trying to match different files with the VLOOKUP function, but it doesn’t allow it, is there a way to do it?

Currently, the spreadsheet editor is not able to fetch data from other documents. However, we are planning to introduce the feature to insert data references within the documents of the same portal in upcoming update 7.3 of our editors.

@NathalySuarez_25

In excel, it is possible to add the function to count the number of cells by color

Unfortunately, there is no way to add custom functions to our editors. Can you share an example of this function so we can check it out and possibly add it to the list of available functions?

Sorry for the inconvenience.

[NathalySuarez_25]

Hello @Constantine ,
The shared code that is included in excel:
Function ContarPorColor(rango_datos As range, condicion_color As range) As Long
Dim datox As range
Dim colorx As Long
colorx = condicion_color.Interior.ColorIndex
For Each datox In rango_datos
If datox.Interior.ColorIndex = colorx Then
ContarPorColor = ContarPorColor + 1
End If
Next datox
End Function

I found this information on the following page ¿Cómo contar el número de celdas por su color, en Excel?

Thanks for your answer

[Constantine]

Thanks for providing the example of this function.
However, as I mentioned it before, currently there is no way to add custom functions to the spreadsheet editor. The suggestion to implement possibility to add custom functions is registered as an enhancement number 51736 in our internal tracker but, unfortunately, we do not have estimated date of the release of this feature.