Scenario for calculation

143kishornaidu · October 2022

Is there any formula instead of first occurance

ManjunathKN · October 2022

Could you elaborate?

Thanks,
Manjunath

143kishornaidu · October 2022

Hi,

Please go throught the attached screenshot

When I am writing the first occurance . It's not working and showing error. Please suggest any ideas to solve it.

Misbah · October 2022

First of all we don't see any screenshot here.

ISFIRSTOCCURRENCE(X,Y) is used as follows

X is Number, Boolean, date, time period, list, or text

Y is the dimension of the module

For more info

Hope that helps

Misbah

Miz Logix

Answers