Is there any formula instead of first occurance
Could you elaborate?Thanks,Manjunath
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.
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