Questions tagged [worksheet-function]
Questions about using in-cell functions/formulas in spreadsheet software.
2,594
questions with no upvoted or accepted answers
5
votes
1
answer
1k
views
Excel- How do I find common text values from multiple (>2) rows?
This is essentially a variant of the question asked here:
Excel- How do I find common text values from multiple (>2) columns?
In this case, however, instead of multiple columns of data I need to ...
4
votes
2
answers
386
views
Outlook Table Relative Cell Reference Error
I'm getting a "!(cell) Is Not In Table" error when attempting to create a Relative cell reference, inside of an outlook table, when using a formula.
I've tested the formula functions and they seem ...
4
votes
1
answer
3k
views
Numbers conditional formatting based on a different cell in the same row
I have a Numbers spreadsheet, with "quantity required" and "quantity in stock" columns, then each part is on a row. I'm trying to use conditional formatting to turn a cell yellow when # required = # ...
3
votes
0
answers
49
views
Changes to User Defined Functions in Office 365 Subscription based
I've seen issues a couple of times when using User Defined Functions with Excel from subscription-based Office 365.
When a workbook is opened with these formulas, they are automatically updated. ...
3
votes
1
answer
2k
views
What is the "next cell character" when coping and pasting from a table?
You know when you copy a row from a table and paste it into another one it is in the correct place. So what is the character that is between cell values when this operation is performed.
Eg. I have ...
3
votes
2
answers
2k
views
TEXTJOIN() on an array incorrectly returns a blank
TL;DR: TEXTJOIN() on an array returns a blank - can't use VBA to solve the issue in an alternative way.
I've created several sheets with heavy dependence on Array functions due to limitations ...
3
votes
1
answer
793
views
References in color-scale conditional formatting formulae for ranges
I'm using Libreoffice Calc (v6.1b).
Suppose I have numeric data in sheet column, A and I'm applying conditional formatting to sheet column B. I want each cell of B to have a color on a scale ...
3
votes
0
answers
177
views
Excel formula to work out time elapsed between dates based on very specific criteria
I have a dataset with approx. 29,000 entries related to approx. 3000 unique individuals’ admission and departure dates to and from a service over a period of time.
I’m trying to collapse each ...
3
votes
0
answers
347
views
Formulas Changed to Reference Last Row When I Close and Open Excel File
I have no idea what is causing this issue, but when I reopen an Excel file, formulas that reference cells will change the reference cells at the very end of the sheet.
Example:
Super simple spread ...
3
votes
1
answer
750
views
Define Name for Worksheet Scope in Microsoft Excel for Mac V15.38
I am trying to create named references that have a Worksheet scope in Microsoft Excel for Mac V15.38.
I want to set up a template sheet that gets duplicated multiple times (example: a template sheet ...
3
votes
3
answers
170
views
Excel data in rows and columns to be reformatted
I have data in Excel in a staggered format. There is a customer ID in the left-most column and the details of that customer are in different rows within different columns. I need to rearrange the ...
3
votes
1
answer
1k
views
Data on excel from access database based on criteria in excel
I have a MS Access database to which an excel file is connected to view output. MS Query is used to interface and fetch data based on two conditions date & ID. I am unable to specifiy the ...
3
votes
1
answer
74
views
libreoffice /open office calc - visualise formula
Let's say I have two alternatives in columns C,D like so:
row 6: sample size
row 7: sample mean
row 8: sample standard deviation
and then want to do a t-Test, which requires (amongst other things)...
3
votes
1
answer
1k
views
Optimize row height/column width in Excel = minimize white space
I often create tables in Excel where some cells contain a lot of text while others just contain a single digit or some other short value. With wrap text in cells enabled and then a combination of ...
3
votes
1
answer
2k
views
Cells evaluated by user-defined module do not update automatically
I read the questions existing but no answer seemed to help. I have a function I wrote in VB which evaluates sum of cells in a certain range by font color, it all works well when I type the function in ...