Ask Your Question

barnmichael's profile - activity

2018-03-13 18:35:26 +0100 received badge  Notable Question (source)
2018-03-11 21:07:03 +0100 received badge  Popular Question (source)
2018-03-11 18:55:10 +0100 received badge  Student (source)
2018-03-11 18:22:22 +0100 asked a question Date Format Issue

Date Format Issue Just ran into this. I have several spreadsheets with date formatted cells. The format is specified as

2018-01-26 19:18:00 +0100 received badge  Notable Question (source)
2018-01-26 19:18:00 +0100 received badge  Famous Question (source)
2017-09-13 08:28:12 +0100 commented answer calc format cells to upper case

Close, but not quite. For various political reasons, we are using the Consolas font. They like the slashed zeros. But, o

2017-09-13 03:35:14 +0100 asked a question calc format cells to upper case

calc format cells to upper case I want to have Calc format/convert input to uppercase on the fly for certain ranges of c

2017-05-31 17:09:41 +0100 answered a question Sum values in one column based on criteria in another

Finally found it. Thanks to another forum, I was pointed to https://help.libreoffice.org/Calc/SUMIFS_function which des

2017-05-29 13:18:15 +0100 commented question Sum values in one column based on criteria in another

Please forgive my ignorance, VBS? Vacation Bible School? I don't find any VBS in the Formula Wizard or other calc functi

2017-05-29 01:56:56 +0100 received badge  Popular Question (source)
2017-05-28 15:28:27 +0100 asked a question Sum values in one column based on criteria in another

Sum values in one column based on criteria in another I have a spreadsheet with column A (A8:A30) containing names and c