Variable text

  • Thread starter Thread starter Gary Campbell
  • Start date Start date
G

Gary Campbell

If I have two columns of sample and result :-
A 2
B 3
C 1
D 6
E 4
F 2

Is there anyway to test the 2nd column and place text in
another column dependant on this. Like, if the test
returns 2, place X in the 2nd column. If the result is 3,
place an X in the 3rd column so

I need something lkie :-
A 2 X
B 3 X
C 1 X
D 6 X
E 4 X
F 2 X

where each X is in it's own column (offset + value in
column B).

Ta
 
You could give the IF formula in the respective columns.
for example, in column 2 IF(A2=2,"x"," "). Likewise, in
the other columns and then copy the formula to the other
rows.
 
Gary

Assuming that your data as described is in the range
A1:B6, then put the formula
=IF(COLUMN()-2=$B1,"X","")
in C1 and copy down/across as required.


Tony
 
Ta heaps - works a treat!
-----Original Message-----
Gary

Assuming that your data as described is in the range
A1:B6, then put the formula
=IF(COLUMN()-2=$B1,"X","")
in C1 and copy down/across as required.


Tony
.
Click to expand...
 
Back
Top