How to solve this problem in Excel [Closed]

Report
Posts
11
Registration date
Monday February 23, 2009
Status
Member
Last seen
April 15, 2009
-
Posts
185
Registration date
Tuesday November 18, 2008
Status
Member
Last seen
January 29, 2010
-
Hello,
how to check 3 column data together and it has to check the same 3 column and it has to give the result example
ColA-----------ColB-----------------ColC
1)10--------------20-------------------15
2)88--------------40--------------------30
3)20---------------10-------------------10
4)90--------------100------------------90

&
ColD------------ColE-----------------ColF
1)15----------------20-------------------20
2)22-----------------25-------------------15
3)92-----------------110--------------------90
4)88-----------------40---------------------60
5)88-----------------40---------------------10

Answer has to be like this
1)10-------------20---------------------15 15-------------20-----------20
2)88-------------40---------------------30 88-------------40------------60
this example is ok
Pls tell me how to solve this in Excel & what is the Formula i can use
thanx
Jai
2)

2 replies

Posts
233
Registration date
Tuesday November 18, 2008
Status
Member
Last seen
August 1, 2010
31
I think you have to change the alignment of the cell and reformat them. But i don't know which options to choose!
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
185
Registration date
Tuesday November 18, 2008
Status
Member
Last seen
January 29, 2010
68
Make a search on google or try tutorials about excel

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!