|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Excel Question, returning values based on another cell
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? |
|
#2
|
||||
|
||||
|
Moved from ASP forum.
__________________
-
thought-after | my thoughts on web development Get Firefox, the developers browser Budget hosting - recommended [/left] |
|
#3
|
||||
|
||||
|
Excel Question, returning values based on another cell
here you go have a look at the attached zip file it has an excel file with what you want
__________________
Hope this advise helps. ![]() If so please show your appreciation by adding reputation points (click gauge image on top right of this post and score).
|
![]() |
| Viewing: ASP Free Forums > Other > Programming Help > Excel Question, returning values based on another cell |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|