Questions tagged [spreadsheet]
Questions about spreadsheet software in general and interoperability between spreadsheet programs.
724 questions
0
votes
1
answer
40
views
How do I use red highlighting on every cell in a column, if that cell contains the letter "n" or the cell contains the word "no" (case-insensitive)?
I tried the following formula.
OR("n" == LEFT(TRIM(E2), "N" == LEFT(TRIM(E2)))
My formula did not work as expected.The background color is white.The background color is not red.I ...
2
votes
1
answer
495
views
How to perform an "on this date" check with a spreadsheet formula?
I have a spreadsheet with a "start date" column and a "number of days" column. I wish to add an "is on this date" column. This value will be true if today's day and month ...
- 133
0
votes
0
answers
45
views
How can I sort our library's text report about books so that pulling them is more efficient?
TL;DR: I work at a library and we run a daily report (see below) to know which books to pull off shelves; how can I sort this report better, which is a long text file?
I work at a library. The ...
0
votes
0
answers
68
views
How do I update my Excel spreadsheet after I'm emailed a new table?
Every month, I am emailed a spreadsheet. This spreadsheet is a list of people. Sometimes new people are added, or old people are removed.
I then use the list, and add extra fields so I can make notes ...
- 191
4
votes
2
answers
891
views
How do I stop Excel from changing cell range when moving data around my spreadsheet?
I have a spreadsheet of containers that are constantly moved around to various locations on my site which we track on this spreadsheet.
I have formulas to count the number of containers in each column ...
- 41
0
votes
2
answers
123
views
Excel formatting to only show least significant digits
I have a sheet where one row is a set of key values (natural numbers derived by formula from another sheet), and subsequent rows are lookups of those values into other sheets.
This section of this ...
- 1,576
1
vote
2
answers
362
views
Excel/Spreadsheet Formula Help: Splitting and Reimbursing Shared Expenses
I have a monthly expenses tracking spreadsheet with two sheets:
"Expenses Summary" → Contains a list of members and columns for "To Pay" (how much they owe) and "To Receive&...
- 11
0
votes
0
answers
107
views
independent data sheets for every power point presentation
My wording might not be appropriate (I'm not an expert on Excel, OLE, VB-stuff), but please bear with me for a couple of seconds.
We have to deliver end-of-sprint statistics in a PowerPoint ...
- 435
0
votes
1
answer
185
views
Formula to calculate time related costs
I am new to Excel/LibreOffice and I want to calculate related time costs using a formula to speed the process.
I have only 2 columns for this purpose:
Column A: represents the amount of time in HH:MM ...
- 397
0
votes
0
answers
80
views
Spreadsheet Compare Highlight Function
My inquiry lies within the Spreadsheet Compare program which is a Microsoft Office Program. I would like to know if rows can be highlighted in the compared files using the Spreadsheet Compare program. ...
- 1
7
votes
3
answers
348
views
How to sort a spreadsheet by "dan and kyu" rank?
In the game of go as well as in martial arts, shogi, for tea ceremonies and for flower arrangements, players have a rank expressed in dan and kyu.
Dan and kyu form a simple numerical system:
30 kyu &...
- 251
0
votes
1
answer
127
views
In a MS Excel spreadsheet, how do we average all numeric values in a given column?
Consider the following table of data...
Year
Tempurature(°F)
2000
30.3
2001
M
2002
36.1
2003
M
Notice that half of the values are a single char, or string, such as MThe other half of the values are ...
0
votes
2
answers
219
views
How to efficiently count instances of strings in a corpus and show the results in a spreadsheet?
I have a "big" (1MB) file full of words in plain text. I want to count all permutations of letter-digraphs/-bigrams within it, e.g. from ab|ba, ac|ca, ad|da... to xy|yx, xz|zx, yz|zy – and ...
- 26
0
votes
1
answer
124
views
How to permanently add a conditional formatting rule to Excel
I am constantly using the conditional formatting on Excel to highlight every other row in a spreadsheet by using the following formula:
=MOD(ROW(),2)=0
No matter how many times I use it, I cannot ...
- 1
2
votes
0
answers
277
views
How to extract and copy all search results across multiple sheets in LibreOffice Calc?
In an ODS file with multiple sheets, we successfully use the 'Find All' feature to locate cells containing the word 'Steve'.
However, we are unable to copy all these results at once.
Is there a way to ...
- 121