Need an autofill number

Rakeshlavishetty

Hi,

1) I need a formula, which can fill number automatically

Ex: series of num 1,2,3..... if i select a cell next number should come automatically!!!

2) Two coloumns A & b, If I select a cell in colounm A , automatically another cell should autofill in column B.

EX:

Green, Blue, Red-----Coloumn A

8h, 10h, 24h------- coloumn B

IF I select Blue in A column , 10h should autofill in B colounm,

Please help me

Paul Newcome

The formula above should work in the dropdown.

As for the series... Are you able to provide a screenshot that shows what you are trying to accomplish?

Paul Newcome

You would use a nested IF statement for your provided example. Something along the lines of this in Column B...

=IF([Column A]@row = "Green", "8h", IF([Column A]@row = "Blue", "10h", IF([Column A]@row = "Red", "24h")))

Rakeshlavishetty

Thanks for writing paul,

It is working fine...

How to write same formula for dropdown??(Green, blue, Red) in dropdown in column A and (8h,10h,24h) in dropdown in coloumn B.

And please address this one as well

1) I need a formula, which can fill number automatically

Ex: series of num 1,2,3..... if i select a cell next number should come automatically!!!

)

Paul Newcome

The formula above should work in the dropdown.

As for the series... Are you able to provide a screenshot that shows what you are trying to accomplish?

Rakeshlavishetty

Yeah paul, that works absolutly fine now...

Could you please address this one ??/

1) I need a formula, which can fill number automatically

Ex: series of num 1,2,3..... if i select a cell next number should come automatically!!!

Thanks...

Paul Newcome

Are you able to provide a screenshot with manually entered data that shows what you are trying to accomplish?

Rakeshlavishetty

Screenshot 2021-01-20 212528.jpg

Hi,

Numbers are in 0001,0002,0003,.... the arrow showing cell should auto fill i,e 0006 should come if I click the cell.

Paul Newcome

You can insert an auto-number column and then put the leading zeros in the "Fill" field. It won't automatically populate when you click on a cell, but it will populate on each row as you insert new data.