Does anyone know how I could auto generate a pattern in excel like this:
1 | 2
1 | 3
2 | 3
1 | 4
2 | 4
3 | 4
1 | 4
2 | 5
3 | 5
4 | 5
ie numerators and denominators of fractions in 2 individual columns?
When I try to fill down I don't get the pattern expanding itself ( 1 want all the way to 100, so don't want to type it by hand!)
Thanks
1 | 2
1 | 3
2 | 3
1 | 4
2 | 4
3 | 4
1 | 4
2 | 5
3 | 5
4 | 5
ie numerators and denominators of fractions in 2 individual columns?
When I try to fill down I don't get the pattern expanding itself ( 1 want all the way to 100, so don't want to type it by hand!)
Thanks