Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
two arrays correction
Hi, Sorry the frist one fell apart when it sent. I am trying again.
In col A througn F there are numbers about 150 rows down. In G1 through L1 there are numbers and these will change from time to time. G2 through L2 and down I want a formula that will find the numbers that are in A through F and put YES in the corresponding cell under G to L. So any cell in A:F that has one of the numbers in G:L the formula will put yes in the corresponding cell under G:L if the numbers is in G1:L1. A B C D E F G H I J 2 8 11 50 43 32 21 5 23 50 Yes 9 43 21 18 22 Yes 2 34 1 54 8 Yes Yes |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
two arrays correction
Do you want the rows in A through F to match the first row in H through L?
If so, and I understand you correctly, try putting this formula in G2 and copying it down and across: =IF(H$1=A2,"YES","") "Jerry Kinder" wrote: Hi, Sorry the frist one fell apart when it sent. I am trying again. In col A througn F there are numbers about 150 rows down. In G1 through L1 there are numbers and these will change from time to time. G2 through L2 and down I want a formula that will find the numbers that are in A through F and put YES in the corresponding cell under G to L. So any cell in A:F that has one of the numbers in G:L the formula will put yes in the corresponding cell under G:L if the numbers is in G1:L1. A B C D E F G H I J 2 8 11 50 43 32 21 5 23 50 Yes 9 43 21 18 22 Yes 2 34 1 54 8 Yes Yes |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
two arrays correction
f2=If($F$1=A2,"Yes","")
copy this formula accross to J then highlight F1:J1 copy (ctrl c) Highlight the F3:J150 or however far down this goes and then paste (Ctrl v) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vba adding arrays | Excel Discussion (Misc queries) | |||
3D Arrays | Excel Worksheet Functions | |||
Confused about arrays and ranges in functions | Excel Worksheet Functions | |||
Comparing Arrays | Excel Discussion (Misc queries) | |||
Comparing Arrays | Excel Worksheet Functions |