Previous Topic Next Topic

Insert the number 001 in column A if B A00-A10

Closed
a - Updated on Mar 2, 2018 at 04:29 PM
 Blocked Profile - Mar 2, 2018 at 02:52 PM
Hello,

In column B the data range from A00-Z99
and I want to insert the number 001 in column A if B A00-A10 and 002 if columnB A11-A20

which function can I use to complete this task
thank you very much


1 response

Answer 1 / 1
Blocked Profile
Mar 2, 2018 at 02:52 PM
This is really confusing, because you have a reference of: 
B A00-A10


Is that a value of A00 in Cell B1, or what?

Similar discussions

Micro sd card showing "please insert Disk"
Joreece -
meme -

6 responses
If cell A1 has text then cell B2 has today's Date
Sasha -
ac3mark -

1 response