En cours

Spreadsheet Cell format

Spreadsheet Cell format

To provide me with input formula to spreadsheet cells for auto data entry for various conditions to respective fields.

Note: See examples in attached spreadsheet.

The column A is for number entry.

Upon input of a number (0-36) to Column A cell, shall automatically update the information to the corresponding cells in the Column B , C, etc…..onwards; under certain specific conditions.

For example:

When Cell A2 (No.) input a number from a set of numbers set as below, then Cell B2 (Red) specify that the number shall be reflected with a tick ( or such can be signify by a letter “V”) in cell B2.

Column B (Red)

Set of numbers for Column B cell marked with a tick ( “V”): Column C cell is left blank.

1, 3, 5, 7, 9, 12, 14, 16, 18, 19, 21, 23, 25, 27, 30, 32, 34, 36.

Column C (Black)

Set of numbers for Column C cell marked with a tick ( “V”): Column B cell is left blank.

2, 4, 6, 8, 10, 11, 13, 15, 17, 20, 22, 24, 26, 28, 29, 31, 33, 35.

For number input of “0”, Column B cell and C cell shall reflect a “O”.

----

Column D (Even)

Set of numbers for Column D cell marked with a tick ( “V”): Column E cell is left blank.

2, 4, 6, 8, 10, 12, 14, 16, 18, 20, 22, 24, 26, 28, 30, 32, 34, 36.

Column E (Odd)

Set of numbers for Column E cell marked with a tick ( “V”): Column D cell is left blank.

1, 3, 5, 7, 11, 13, 15, 17, 19, 21, 23, 25, 27, 29, 31, 33, 35.

For number input of “0”, Column D cell and E cell shall reflect a “O”.

----

Column F (Big)

Set of numbers for Column F cell marked with a tick ( “V”): Column G cell is left blank.

19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36.

Column F (Small)

Set of numbers for Column G cell marked with a tick ( “V”): Column F cell is left blank.

1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18.

For number input of “0”, Column F cell and G cell shall reflect a “O”.

----

Column H (Row123)

Set of numbers for Column H cell marked with corresponding number:

Entry No. – Input number Entry No. – Input Number Entry No. – Input Number

Column A - Column H cell Column A - Column H cell Column A – Column H cell

0 0

1 1 2 2 3 3

4 1 5 2 6 3

7 1 8 2 9 3

10 1 11 2 12 3

13 1 14 2 15 3

16 1 17 2 18 3

19 1 20 2 21 3

22 1 23 2 24 3

25 1 26 2 27 3

28 1 29 2 30 3

31 1 32 2 33 3

34 1 35 2 36 3

Column I (Section123)

Set of numbers for Column I cell marked with corresponding number:

Entry No. – Input number Entry No. – Input Number Entry No. – Input Number

Column A - Column I cell Column A - Column I cell Column A – Column I cell

0 0

1 1 13 2 25 3

2 1 14 2 26 3

3 1 15 2 27 3

4 1 16 2 28 3

5 1 17 2 29 3

6 1 18 2 30 3

7 1 19 2 31 3

8 1 20 2 32 3

9 1 21 2 33 3

10 1 22 2 34 3

11 1 23 2 35 3

12 1 24 2 36 3

----

Column J (Top)

Set of numbers for Column J cell marked with a tick ( “V”):

0, 2, 3, 4, 7, 12, 15, 17, 19, 21, 25, 26, 28, 29, 32, 35.

For number input of 6, 9, 18, 22, 34 Column J cell shall reflect a “O”.

----

Column K (Bottom)

Set of numbers for Column K cell marked with a tick ( “V”):

1, 5, 8, 10, 11, 13, 14, 16, 20, 23, 24, 27, 30, 31, 33, 36.

For number input of 6, 9, 18, 22, 34 Column K cell shall reflect a “O”.

----

Column L (Left)

Set of numbers for Column L cell marked with a tick ( “V”):

1, 3, 7, 9, 12, 14, 16, 18, 20, 22, 26, 28, 29, 31, 33, 35.

For number input of 0, 5, 10, 24, 32 Column L cell shall reflect a “O”.

----

Column M (Right)

Set of numbers for Column M cell marked with a tick ( “V”):

2, 4, 6, 8, 11, 13, 15, 17, 19, 21, 23, 25, 27, 30, 34, 36.

For number input of 0, 5, 10, 24, 32 Column L cell shall reflect a “O”.

----

Column N (A)

Set of numbers for Column N cell marked with a tick ( “V”):

0,3, 4, 7, 9, 12, 15, 18, 19, 22, 26, 28, 29, 31, 32, 35.

For number input of 1, 2, 14, 20, 21 Column N cell shall reflect a “O”.

----

Column O (C)

Set of numbers for Column O cell marked with a tick ( “V”):

5, 6, 8, 10, 11, 13, 16, 17, 23, 24, 25, 27, 30, 33, 34, 36.

For number input of 1, 2, 14, 20, 21 Column O cell shall reflect a “O”.

----

Column P (B)

Set of numbers for Column P cell marked with a tick ( “V”):

1, 5, 7, 9, 10, 14, 16, 18, 20, 22, 23, 24, 28, 29, 31, 33.

For number input of 8, 11, 12, 30, 35 Column P cell shall reflect a “O”.

----

Column Q (D)

Set of numbers for Column Q cell marked with a tick ( “V”):

0, 2, 3, 4, 6, 13, 15, 17, 19, 21, 25, 26, 27, 32, 34, 36.

For number input of 8, 11, 12, 30, 35 Column Q cell shall reflect a “O”.

----

Column V (AL)

Set of numbers for Column V cell marked with a tick ( “V”):

1, 2, 4, 5, 6, 7, 8, 9, 11, 13, 14, 16, 17, 18, 32, 35.

For number input of 0, 10, 12, 19, 26 Column V cell shall reflect a “O”.

----

Column S (AR)

Set of numbers for Column S cell marked with a tick ( “V”):

3, 15, 20, 21, 22,23, 24, 25, 27, 28, 29, 30, 31, 33, 34, 36.

For number input of 0, 10, 12, 19, 26 Column S cell shall reflect a “O”.

----

Column T (Riviera)

Set of numbers for Column T cell marked with a tick ( “V”):

1, 2, 3, 4, 6, 7, 8, 9, 11, 12, 13, 14, 15, 16, 17, 18.

For number input of 0, 5, 10, 23, 24, 26, 32 Column T cell shall reflect a “O”.

----

Column U (MGM)

Set of numbers for Column U cell marked with a tick ( “V”):

0, 1, 2, 7, 8, 10, 12, 16, 17, 19, 22, 26, 27, 31, 32, 36.

----

Column V (Duo A)

Set of numbers for Column V cell marked with a tick ( “V”):

0, 1, 3, 4, 5, 8, 10, 15, 16, 19, 23, 24, 26, 32, 33, 35,

For number input of 11, 12, 20, 21, 30 Column V cell shall reflect a “O”.

----

Column W (Duo B)

Set of numbers for Column W cell marked with a tick ( “V”):

2, 6, 7, 9, 13, 14, 17, 18, 22, 25, 27, 28, 29, 31, 34, 36.

For number input of 11, 12, 20, 21, 30 Column W cell shall reflect a “O”.

----

Column X (Tri A)

Set of numbers for Column X cell marked with a tick ( “V”):

0, 1, 3, 6, 9, 11, 13, 14, 15, 20, 26, 27, 31, 32, 33, 36.

For number input of 16, 19, 22, 34, 35 Column X cell shall reflect a “O”.

----

Column Y (Tri B)

Set of numbers for Column Y cell marked with a tick ( “V”):

2, 4, 5, 7, 8, 10, 12, 17, 18, 21, 23, 24, 25, 28, 29, 30.

For number input of 16, 19, 22, 34, 35 Column Y cell shall reflect a “O”.

----

Column Z (4A-Stars)

Set of numbers for Column Z cell marked with a tick ( “V”):

0, 3, 5, 6, 9, 10, 17, 18, 22, 23, 24, 26, 27, 31, 32, 34.

For number input of 13, 15, 16, 25, 29 Column Z cell shall reflect a “O”.

----

Column AA (4B-Stars)

Set of numbers for Column AA cell marked with a tick ( “V”):

1, 2, 4, 7, 8, 11, 12, 14, 19, 20, 21, 28, 30, 33, 35, 36.

For number input of 13, 15, 16, 25, 29 Column AA cell shall reflect a “O”.

----

Compétences : Saisie de Données, Excel, Format & Présentation

Voir plus : spreadsheet cell format, the big o 1, red black data, m format in excel, letter format, big w, big o examples, big o 2, excel spreadsheet formula, spreadsheet input, spreadsheet 2, q-v, odd, letter G, excel w, entry l, DUO, d e s i g n l o g o, cell, b2, excel formula spreadsheet spreadsheet, data set formula, excel format formula, blank fields, excel column update

Concernant l'employeur :
( 2 commentaires ) Singapore, Singapore

N° du projet : #1625076

Décerné à :

MDavidCrompton

Hi, I did this this morning for xumingle. Is this for real? Completed File attached Have used real ticks David

35 $ SGD en 0 jours
(23 Commentaires)
4.9

4 freelance ont fait une offre moyenne de 38 $ pour ce travail

Nhcuong

hi,i can do it in many way! in-cell formulas or off-cell vba, simply up to you requirements and the scale of the sheet.

40 $ SGD en 1 jour
(19 Commentaires)
4.8
manishadk

This is very EASY JOB for me. Please check PMB for details.

30 $ SGD en 1 jour
(10 Commentaires)
3.7
LeChatK

Hi! Kindly find the completed file in my PMB.

45 $ SGD en 1 jour
(1 Commentaire)
1.8