Đã Hủy

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”.

----

Kỹ năng: Nhập liệu, Excel, Format & Layout, Freelance

Xem thêm: 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

Về Bên Thuê:
( 4 nhận xét ) Singapore, Singapore

Mã Dự Án: #1624055

11 freelancer đang chào giá trung bình $63 cho công việc này

Teloquence

Consider it done. Check your PM for details.

$150 SGD trong 2 ngày
(205 Đánh Giá)
6.9
nagybatonyi

Please, see a sample in PMB! Regards

$60 SGD trong 0 ngày
(53 Đánh Giá)
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 trong 0 ngày
(28 Đánh Giá)
5.2
ethicalboy

Please see what I said.

$50 SGD trong 2 ngày
(44 Đánh Giá)
4.8
JJdatajobs

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

$35 SGD trong 1 ngày
(30 Đánh Giá)
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 Thêm

$60 SGD trong 5 ngày
(3 Đánh Giá)
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 trong 1 ngày
(1 Đánh Giá)
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 Thêm

$50 SGD trong 1 ngày
(0 Đánh Giá)
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 trong 1 ngày
(0 Đánh Giá)
0.0
vishusobti

Waiting for a positive reply from your side

$70 SGD trong 1 ngày
(0 Đánh Giá)
0.0
damodaran999

Consider it done. It is an interesting work.

$34 SGD trong 1 ngày
(0 Đánh Giá)
0.0