Storing and retrieving data

5 pts.
Tags:
Data
Open Office
SPREAD SHEETS
Storage
I have something very specific I want my spreadsheet to do for a schedule I am making.
  1. I want to be able to add data as text (IE shower or eat out) as a list 1-40. Ths list would give each text a value 1-5. If the text is already in the database, then it would only add the value to the balance value in the database. If the text is not in the database then it would add the text and the value.
  2. Then on another spreadsheet, I would like to retrieve the text with the highest value to the lowest value indexed 1-40. This seems like it should be a simple thing to do but I have taken tutorials on lookup and find and some others but have not been able to figure it out.
I think I should also add that I'm using Open Office not Excel.
ASKED: November 13, 2013  3:59 AM
UPDATED: November 16, 2013  5:57 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following