Annulé

Spreadsheet Cell Format

Spreadsheet Cell format

I need 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, Freelance

Voir plus : spreadsheet cell format, red black data, letter format, big w, big examples, excel spreadsheet formula, spreadsheet input, spreadsheet 2, odd, letter g, excel w, entry l, duo, cell, b2, data set formula, excel format formula, blank fields, excel column update, excel format cell, excel cell format, excel cell, format cell, update spreadsheet data, conditions excel

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

N° du projet : #1624055

11 freelance ont fait une offre moyenne de 63 $ pour ce travail

Teloquence

Consider it done. Check your PM for details.

150 $ SGD en 2 jours
(205 Commentaires)
6.9
nagybatonyi

Please, see a sample in PMB! Regards

60 $ SGD en 0 jours
(53 Commentaires)
5.7
MDavidCrompton

Project complete and attached. I have completed many such projects, please try this out and also check my feedback. Regards David

100 $ SGD en 0 jours
(28 Commentaires)
5.2
ethicalboy

Please see what I said.

50 $ SGD en 2 jours
(44 Commentaires)
4.8
JJdatajobs

Hello 'xumingle', I am submitting my SAMPLEWORK. Kindly review the same. Thank you very much, JJdatajobs.

35 $ SGD en 1 jour
(30 Commentaires)
4.6
sumshank

Thanks for your time in reading my bid. Here is what I can offer: - Excellent MS Excel skills, having used it extensively during my work with the Information Technology industry. - My Excel work includes usage of Plus

60 $ SGD en 5 jours
(3 Commentaires)
2.4
LeChatK

Hi! I'm an auditor at a Big 4 firm. Work with excel everyday. I can complete your assignment in a mater of hours. Quality guaranteed.

45 $ SGD en 1 jour
(1 Commentaire)
1.8
sjc243

Hi. I am new to freelancer, but have been working with data and excel daily for several years in my day job - so I expect this will take less than an hour. I am confident you will be satisfied with the finished project Plus

50 $ SGD en 1 jour
(0 Commentaires)
0.0
lahiru841012

Hi I'm new to freelancer, but I understand your project clearly.I have good knowledge of using MS Excel (I'm BSc graduate in university of peradeny, sri lanka) I'm interest to get this job and I can do it well.

40 $ SGD en 1 jour
(0 Commentaires)
0.0
vishusobti

Waiting for a positive reply from your side

70 $ SGD en 1 jour
(0 Commentaires)
0.0
damodaran999

Consider it done. It is an interesting work.

34 $ SGD en 1 jour
(0 Commentaires)
0.0