• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How can I write a formula to assign a number to a location

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!!!
 

Attachments

  • VTracking.jpg
    VTracking.jpg
    175.8 KB · Views: 0
  • VT SS RS Trap.xlsx
    9.8 KB · Views: 0
Your explanation is quite convoluted and unclear

I think I5: =IF(K5>4,K5-5,K5)+1
copy down
 
Thanks Hui, but that can not work since I have numbers in It. I am trying to take the data in I an convert it to the VT numbers. So, the 4 in I:5 will give me a 5 in K:5, the 5 in I:6 will give me a 1 in K:6and so on. Thanks for respondong
 
Not there yet Hui, this is what it gives me

3 =1 should be 3=4
5 =4 5=1
3= 3 3=4
2 =5 2=3
4= 1 4=5
5 =5 5=1
4 =4 4=5

Here's the rundown again

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
 
I am so embarrassed. I actually worked with this for well over an hour till 3 a.m. only to just realize now after some sleep I had placed the formula in the wrong row duh!!! Thanks Hui FANTASIC as ALWAYS!!!! THANK YOU!!!
 
Back
Top