질문하기

leviticus8908's profile - activity

2017-08-01 07:12:47 +0200 받은 배지  정리의 달인
2013-07-09 20:26:03 +0200 받은 배지  유명한 질문 (source)
2013-07-09 20:26:03 +0200 받은 배지  주목할 만한 질문 (source)
2013-07-09 20:26:03 +0200 받은 배지  인기있는 질문 (source)
2013-02-03 09:50:53 +0200 받은 배지  학생 (source)
2012-11-25 15:30:13 +0200 질문에 댓글을 달았습니다 Accounting Journal Problem

Sorry. I mean that row needs to have an indentation (similar to an outline).

2012-11-20 03:03:54 +0200 질문에 댓글을 달았습니다 Accounting Journal Problem

The three separate rows almost works but I need to tab after each line.

2012-11-20 01:06:40 +0200 질문에 댓글을 달았습니다 Accounting Journal Problem

I can't figure out how to change the numbers I had to "date" formula without losing the right numbers. For example, I put in "0820" for August 20 and when I attempt to convert it it goes to "03-30" [?!]. Also, why would it make a difference what format the numbers are in for the purpose of sorting?

2012-11-20 00:59:04 +0200 질문에 댓글을 달았습니다 Accounting Journal Problem

How do I get more "karma?" I think I need to show an example of what I'm trying to do. I can't get the "=IF(THEN)" function to operate like I want it to. It seems that the formula is correct but it doesn't yield the correct value.

2012-11-15 21:56:45 +0200 질문에 댓글을 달았습니다 Accounting Journal Problem

Also, apparently I can't upload a sample because I don't have enough "karma" yet.

2012-11-15 21:55:56 +0200 질문에 댓글을 달았습니다 Accounting Journal Problem

Perhaps I didn't make myself clear or I misunderstood your answer. Basically I just need to know how to sort data entries with multiple rows without breaking up the entry.

2012-11-15 06:07:41 +0200 받은 배지  편집자 (source)
2012-11-15 06:03:49 +0200 질문하였습니다 Accounting Journal Problem

I am trying to keep an accounting journal in LibreOffice Calc. The format was originally a .xls that was sent from my Accounting professor which I am now attempting to use for my personal use. Basically my goal is to be able to input my transactions in any order and then sort by date. This is so that I will not have to worry about sorting the physical receipts by date and can just let them build up and then dump them all the data into Calc and then sort it out. However, my problem is that each journal entry takes up three rows and I don't know how to sort it without having the journal entries broken up. I've searched around the internet for some solutions on Excel, and they all seem to come down to using the IF/THEN function to generate the appropriate identification for each row and then sorting it by the new row. Every time I try in Calc however, all I can generate is the same number for every row.

This makes more sense if you see it so I have attached an example. If you know of any easier way I could format it, please let me know.

Thanks in advance for your help.

P.S. Please note that Column A is not part of the journal but rather my attempt of coming up with a way to sort the entries.