Jack-P-Winner
Member
I have a spreadsheet and I need to assign the numbers in column I under SS to a specific number reference point. I am not sure how to write the formula without doing a lot of +-<>=
Here are the locations that if a number value in column S = a certain numeric value
1=2
2=3
3=4
4=5
5=1
6=2
7=3
8=4
9=5
You will notice in column I:5 is a number 4 so it is = to 5
I:6=5=1
I:7=4=5
I:8=3=4 and so on
Again, many thanks!!!
Here are the locations that if a number value in column S = a certain numeric value
1=2
2=3
3=4
4=5
5=1
6=2
7=3
8=4
9=5
You will notice in column I:5 is a number 4 so it is = to 5
I:6=5=1
I:7=4=5
I:8=3=4 and so on
Again, many thanks!!!