Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A number autofill !!
Hi all,
Little help needed I have A1 A2 A3 A1 A2 A3 10 AA 1 4 AB 1 4 AA 1 Now A1 can contain a number from 1 to 300 A2 can contain a combo of 30 different letter combos which describes a product sometimes they will be the same letter combo I need A3 to scan thru A2 column as A2 is entered and populate A3 with the number 1, it will always be 1, cannot be anything else. Or just have the number 1 auto fill A3. Am I thinking this is more complicated than it really is?? Any help appreciated.. Thanks Stephen |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A number autofill !!
Just put this in A3 and drag it across the row
=if(a2<"",1,"") pano wrote: Hi all, Little help needed I have A1 A2 A3 A1 A2 A3 10 AA 1 4 AB 1 4 AA 1 Now A1 can contain a number from 1 to 300 A2 can contain a combo of 30 different letter combos which describes a product sometimes they will be the same letter combo I need A3 to scan thru A2 column as A2 is entered and populate A3 with the number 1, it will always be 1, cannot be anything else. Or just have the number 1 auto fill A3. Am I thinking this is more complicated than it really is?? Any help appreciated.. Thanks Stephen |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A number autofill !!
I need A3 to scan thru A2 column as A2 is entered and populate A3 with
the number 1, it will always be 1, cannot be anything else. Put in C2: =IF(B2="","",1) Copy down as far as required -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "pano" wrote: Hi all, Little help needed I have A1 A2 A3 A1 A2 A3 10 AA 1 4 AB 1 4 AA 1 Now A1 can contain a number from 1 to 300 A2 can contain a combo of 30 different letter combos which describes a product sometimes they will be the same letter combo I need A3 to scan thru A2 column as A2 is entered and populate A3 with the number 1, it will always be 1, cannot be anything else. Or just have the number 1 auto fill A3. Am I thinking this is more complicated than it really is?? Any help appreciated.. Thanks Stephen |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A number autofill !!
After having another look at this I need the formula to allow a
product NH not to count as 1. How would I exclude NH as zero and not show as 1???? On Feb 5, 1:26 pm, Max wrote: I need A3 to scan thru A2 column as A2 is entered and populate A3 with the number 1, it will always be 1, cannot be anything else. Put in C2: =IF(B2="","",1) Copy down as far as required -- Max Singaporehttp://savefile.com/projects/236895 xdemechanik --- "pano" wrote: Hi all, Little help needed I have A1 A2 A3 A1 A2 A3 10 AA 1 4 AB 1 4 AA 1 Now A1 can contain a number from 1 to 300 A2 can contain a combo of 30 different letter combos which describes a product sometimes they will be the same letter combo I need A3 to scan thru A2 column as A2 is entered and populate A3 with the number 1, it will always be 1, cannot be anything else. Or just have the number 1 auto fill A3. Am I thinking this is more complicated than it really is?? Any help appreciated.. Thanks Stephen- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A number autofill !!
How would I exclude NH as zero and not show as 1?
In C2, copied down: =IF(B2="","",IF(B2="NH",0,1)) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- On Feb 5, 11:01 am, "pano" wrote: After having another look at this I need the formula to allow a product NH not to count as 1. How would I exclude NH as zero and not show as 1???? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert a month to a quarter ...... | New Users to Excel | |||
Show Next Number in sequence | Excel Worksheet Functions | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |