• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

kindly make a excel formula for this pattern

L

lalit232

New Member
[pre]
Code: 
DAY1 DAY2 DAY3 DAY4 DAY5 DAY6
A r 3	 0	0	0	0	0
B p 17	 0	0	0	0	0
B k 4	 1	0	0	0	0
C g 0	 1	0	0	0	0
D g 0	 22	5	0	0	0
A h 0	 0	3	0	0	0
F i 0	 0	2	0	0	0
G e 0	 0	3	0	0	0
[/pre]

PROBLEM IS

TO ARRANGE NON ZERO VALUES IN ONE COLUMN DAY WISE WITH THEIR ALPHABETS i.e

1 A r 3

1 B p 17

1 B k 4

2 B k 1

2 C g 1

2 D g 22

3 D g 5

3 A h 3

3 F i 2

3 G e 3

BLANK BLANK BLANK


AND SO ON.........
 
will you please check the following link....

http://www.2shared.com/document/79Kk0BK8/result.html


i have put a file on the above link in which there are two sheets

Sheet 3 = problem data

Sheet2 = you will get there answer...as you required


after the above file download you have to open sheet3 then press the button there

then you will see your answer infront of your eyes...


i hope it is useful for you....


Regards

CA Mahaveer Somani
 
You must log in or register to reply here.
Back
Top