Link to home
Start Free TrialLog in
Avatar of excelismagic
excelismagic

asked on

how can i convert array of {1,2,3,4,5,6,7,8,9,10,11} to {1,1,1,1,1,1,1,1,1,1,1} in excel formula.

how can i convert array of {1,2,3,4,5,6,7,8,9,10,11} to {1,1,1,1,1,1,1,1,1,1,1} in excel formula.
ASKER CERTIFIED SOLUTION
Avatar of Professor J
Professor J

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of excelismagic
excelismagic

ASKER

thanks