SASnewbie
asked on
How to do a fill series in Excel
Hi experts,
Would you assist in providing a method to accomplish the following series in Excel?
1_1
1_2
1_3
2_1
2_2
2_3
...
150_1
150_2
150_3
Thanks
Would you assist in providing a method to accomplish the following series in Excel?
1_1
1_2
1_3
2_1
2_2
2_3
...
150_1
150_2
150_3
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you all for your very fast responses!!!
Yes I know the question is closed but just to shorten Matt's formula:
=INT((ROW()+2)/3)&"_"&MOD( ROW()-1,3) +1
=INT((ROW()+2)/3)&"_"&MOD(
ASKER
Thanks ssaqibh!
Open in new window