I have something very specific I want my spreadsheet to do for a schedule I am making.
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.
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.