I have a question about returning values from another cell.
Example:
There are 4 columns (G, H, I and J) that contain a number between 1 and 8. Then there are 8 columns for each of those 8 numbers, columns K through R. What I do is if 1 is contained in G, H, I or J - I indicate F in column K and N if it's not contained in those columns. A number cannot be duplicated on a row.
Here's what those columns would show. You would have 4 columns with an F and 4 columns with an N based on your 8 columns of numbers.
G H I J K L M N O P Q R <Columns G through J and K through R)
1 6 5 4 F N N F F F N N
2 7 3 8 N F F N N N F F
K - represents 1, L = 2, M = 3, through R = 8
My questions is, can I create a formula to calculate the F and N for me?
Example:
There are 4 columns (G, H, I and J) that contain a number between 1 and 8. Then there are 8 columns for each of those 8 numbers, columns K through R. What I do is if 1 is contained in G, H, I or J - I indicate F in column K and N if it's not contained in those columns. A number cannot be duplicated on a row.
Here's what those columns would show. You would have 4 columns with an F and 4 columns with an N based on your 8 columns of numbers.
G H I J K L M N O P Q R <Columns G through J and K through R)
1 6 5 4 F N N F F F N N
2 7 3 8 N F F N N N F F
K - represents 1, L = 2, M = 3, through R = 8
My questions is, can I create a formula to calculate the F and N for me?
