Setting up an ‘autocomplete script excel’

Asked By 20 points N/A Posted on -
qa-featured

The text/numerics recorded in the first three columns of a worksheet determine the text/numeric content of the fourth column. I would like to know the best way to set up an autocomplete script excel for the fourth column? Thanks. 

SHARE
Best Answer by Cohen Wible
Answered By 0 points N/A #137210

Setting up an ‘autocomplete script excel’

qa-featured

Dear customer,

Auto complete, or Autofill, is a great feature on Microsoft Excel, you can find the Autofill items (days/numbers/months) stored in the program by the manufacturers, or you can make your own Autofill list. You can do this in a few simple ways, but if you are using Microsoft Office 2003, it is different from the 2010 version. In the two links below, you will find the instructions.

http://www.ehow.com/how_13021_autofill-function-excel.html

http://www.ehow.com/how_8297719_use-autofill-excel.html

Best Answer
Best Answer
Answered By 0 points N/A #137211

Setting up an ‘autocomplete script excel’

qa-featured

 

So you would want the data from columns 1, 2, and 3, to  determine the result for column 4, and the solution to that is not through an "autocomplete excel script" but an excel formula to concatenate the 3 values. Excel concatenation does not compute numerical or textual values in multiple cells, but position the values of each cell in the specific concatenation formula. So for example, you want values inside A1, B1, and C1 to be in a series "C1 A1 B1" order without typing it on D1, then you would type on D1:

Example

A1 = "the"

B1 = "fence"

C1 = "jump over"

 

D1 = "=Concatenate(C1,A1,B1)"

I have provided a screenshot for your reference:

Login/Register to Answer

Related Questions