질문하기

Ram.BM's profile - activity

2017-01-05 19:47:03 +0100 받은 배지  정리의 달인
2016-02-20 08:39:13 +0100 받은 배지  유명한 질문 (source)
2016-02-19 10:42:17 +0100 으뜸 답변으로 표시됨 how to calculate date difference

my file is

   column1        column2
    1-Sep-11     31-Aug-12
    1-May-12    30-Apr-14
    1-Mar-09    28-Feb-14
    1-Apr-13    31-Mar-14
    1-Apr-10    31-Mar-13

i want how many years difference between column1 and column2

out put like

column1        column2
    1-Sep-11     31-Aug-12      1
    1-May-12    30-Apr-14       2
    1-Mar-09    28-Feb-14      5
    1-Apr-13    31-Mar-14      1
    1-Apr-10    31-Mar-13      3

please let me know

2016-02-19 04:19:11 +0100 받은 배지  유명한 질문 (source)
2016-02-19 03:42:41 +0100 받은 배지  유명한 질문 (source)
2015-09-09 21:14:04 +0100 받은 배지  인기있는 질문 (source)
2015-09-09 21:14:04 +0100 받은 배지  유명한 질문 (source)
2015-09-09 21:14:04 +0100 받은 배지  주목할 만한 질문 (source)
2015-08-10 23:18:46 +0100 받은 배지  유명한 질문 (source)
2015-06-14 22:11:50 +0100 받은 배지  주목할 만한 질문 (source)
2015-06-14 22:11:50 +0100 받은 배지  인기있는 질문 (source)
2015-02-26 20:45:57 +0100 받은 배지  주목할 만한 질문 (source)
2015-01-23 04:42:12 +0100 받은 배지  유명한 질문 (source)
2014-06-02 10:04:06 +0100 받은 배지  주목할 만한 질문 (source)
2014-06-02 10:04:06 +0100 받은 배지  유명한 질문 (source)
2014-03-28 07:28:13 +0100 코멘트달린 답변 How to split data based on hyphen

I didnot get your answer can you show me with one example

2014-03-27 13:53:28 +0100 질문하였습니다 How to split data based on hyphen

I have data in on one cell like

columnA
VADODARA - 390010
KALWAKURTHY -509324
CHENNAI -600042

I need output like

columnA       columnB
VADODARA      390010
KALWAKURTHY   509324
CHENNAI       600042

Please tell me how to do this.

2014-03-24 17:26:09 +0100 받은 배지  주목할 만한 질문 (source)
2014-03-24 12:33:56 +0100 받은 배지  인기있는 질문 (source)
2014-03-24 12:27:13 +0100 코멘트달린 답변 How to extract the name and address from mailing list cell in Calc

Thanq it works now exactly thanq

2014-03-24 12:27:13 +0100 받은 배지  논객
2014-03-24 10:24:39 +0100 코멘트달린 답변 How to extract the name and address from mailing list cell in Calc

it is not work well because in libreoffice there is no " so please modify your answer

2014-03-24 05:57:33 +0100 질문하였습니다 How to extract the name and address from mailing list cell in Calc

I have data in libroffice calc like below

"V K RAJU
E -45  COLLEGE LANE
BENGALI MARKET
XYZ  -110001"
"B  PAVAN KUMAR SARMA
D.No: 4318/3,Ansari Road, Dariya Gunj,
XYZ - 110 002."

like upto 3500 records are there in that file. In that file how to extract the mailing list please tell me as early as possible

In that data mailing list means what i want to extract(either name or Address)

2014-03-24 05:50:11 +0100 받은 배지  인기있는 질문 (source)
2014-03-24 05:49:18 +0100 받은 배지  유명한 질문 (source)
2014-03-20 10:56:27 +0100 받은 배지  자기 주도 학습자 (source)
2014-03-20 10:56:27 +0100 받은 배지  선생님 (source)
2014-03-20 08:13:50 +0100 질문하였습니다 How compare Number with number and string

If suppose I have data like

column1 column2 
504231  504109  
504109  504201  
504201      
504299

then I used the following formula =IF(ISNA(VLOOKUP($A2,$B$2:$B$5,1,0)),"",VLOOKUP($A2,$B$2:$B$5,1,0)) it works fine and it producess following result

column1 column2 column3
504231  504109  
504109  504201  504109
504201          504201
504299

Now I have data like

column1 column2 column3
504231   504109 smith
504109   504201 scott
504201      
504299

then I want ouput like

column1 column2 column3 column4 column5
504231   504109 smith       
504109  504201  scott      504109     smith
504201                     504201     scott
504299
            **OR**
column1 column2 column3
504231      
504109  504109  smith
504201  504201  scott
504299

How to acheive this output . What is the formula for this please let me know

2014-03-20 07:20:41 +0100 질문에 답변하였습니다 Not getting desired output

inted of =IF(ISNA(VLOOKUP($A2;$B$2:$B$5;1;0));"";VLOOKUP($A2;$B$2:$B$5;1;0)) we can place =IF(ISNA(VLOOKUP($A2;$B$2:$B$16075;1;0));"";VLOOKUP($A2;$B$2:$B$16075;1;0)). Then it works fine

2014-03-20 06:23:25 +0100 질문하였습니다 Not getting desired output

I have data in two file there are

file1: https://app.box.com/s/vhspjgex5op42irdmpa4

file1: https://app.box.com/s/z0qpv06wqjt9efoh6i4e (download the these two files by using download option)

In these two file I'm applying the following formula

=IF(ISNA(VLOOKUP($A2;$B$2:$B$5;1;0));"";VLOOKUP($A2;$B$2:$B$5;1;0))

but sampl2.ods is showing proper result but sample1.ods is not showing proper result . Why these two files behaving like this please tell me

2014-03-20 05:44:07 +0100 코멘트달린 답변 How to compare numbers in two columns

Please see the attached file

2014-03-20 05:43:02 +0100 받은 배지  편집자 (source)
2014-03-20 05:41:39 +0100 코멘트달린 답변 How to compare numbers in two columns

It is not working fine . I will attache my file can u pls do that

2014-03-20 05:20:30 +0100 받은 배지  개근상
2014-03-19 23:59:19 +0100 받은 배지  주목할 만한 질문 (source)
2014-03-19 19:37:02 +0100 받은 배지  인기있는 질문 (source)
2014-03-19 11:40:31 +0100 질문하였습니다 How to compare numbers in two columns

C:\fakepath\13952684201163267.ods I have data in libreoffice like

ColumnA ColumnB
504231  504109
504109  504201
504201  
504299

like so much data Then I want output like

ColumnA ColumnB
504231  
504109  504109
504201  504201
504299

How to achieve this output please let me know

2014-03-19 10:31:40 +0100 받은 배지  주목할 만한 질문 (source)
2014-03-19 10:29:22 +0100 으뜸 답변으로 표시됨 How to disable auto save method in libreoffice

Currently I'm working in libreoffice with large amount of data . while working in libreoffice it automatically save and this save taking so much time so how to disable auto save method in libreoffice .I'll save the hole document by end of the finishing work please tell me how to do this

2014-03-19 10:29:19 +0100 코멘트달린 답변 How to disable auto save method in libreoffice

works fine