MOD Function

[eguirocker3]

Need help on using MOD functions in the attached sheets.

I would like to use a MOD function on each line in column A to return the value that I have typed in column B. No using column B in mod formula.

Sheet 1 Examples:
In Cell C1, need MOD funtion on 131 to return a value of 1
In Cell C20, need MOD function on 150 to return a value of 2

Sheet 2 Examples:
In Cell C1, need MOD funtion on 131 to return a value of 1
In Cell C18, need MOD function on 148 to return a value of 2

Any help would be greatly appreciated, thanks.

[protonLeah]

Please return to this thread It seems like the same problem.