# AUTO FILL Help urgent

#### nabeeljeddah

##### New Member
dear all
i am having a problem & i am sure its a minor one but i tried my level best but was not able to find any solution even over the net
well the situation is like that
i am having

two columns

A B C
12 6 =(A1-B1)/B1

Now here the Column A & Column B are fill with values and column C is having a formula when i drag down for auto fill it is not calculating as it goes down with respect to its values in column A & B where as it repeats down the result in coulmn C which came in the first row.
please any 1 can help me as its really urgent i already did wat ever it was in my resource
THANKSS

REGARDS,
NABEEL

### Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

#### ageren

##### Board Regular

tools > options > calculation > [ calculation - automatic option button should be marked ]

Replies
3
Views
515
Replies
2
Views
362
Replies
2
Views
372
Replies
10
Views
2K
Replies
1
Views
375

1,191,190
Messages
5,985,202
Members
439,947
Latest member
fabiannic

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back