All Questions
48
questions
0
votes
2
answers
69
views
Copying Sheets and cell references
Let's say I have "Sheet A" and "Sheet B" within the same workbook.
Sheet B has a cell that references Sheet "A" i.e. ='Sheet A '!Q20
I want to copy Sheet B and Create &...
0
votes
2
answers
118
views
In Excel, Format a Number with Intermediate Spacing AND Optional Decimal
I have a series of numbers in Excel that I would like formatted in a certain way and I need some help.
Background:
I work in construction, and am using the Construction Specification Institute's (CSI) ...
0
votes
1
answer
114
views
Conditional Formatting Not working (maybe pilot error?)
Excel Version 16.68.
I want to compare numbers in Column D to a Reference Number and use Conditional Formatting Formulas in Column E to highlight the corresponding cells.
I use Formulas because the ...
0
votes
1
answer
121
views
Excel Conditional Formatting - Using Formula as Part of a Cell Reference
I am trying to use conditional formatting to highlight a cell if it is blank and a cell in the first column of the same row is not blank. For example, if the conditional formatting is for cell D4, I ...
0
votes
1
answer
112
views
How to decrease the number of cells that are selected in the formula in Excel?
I'm using the AVERAGE function and drag/expand it along one row (e.g. from A1 to D1), the cells that are selected should decrease by 1 row in each new column.
For example:
A1
=AVERAGE(A2:A10)
B1
=...
0
votes
5
answers
2k
views
Excel: Sum all numbers separated by new line within cell
How do I create a new cell that equals the sum all numbers in a cell separated by a new line?
I may not use text to columns as that is messy and there's no new line separator delimiter in text to ...
0
votes
4
answers
2k
views
excel formula of sum with error and cells not in range
I want a sum formula that will ignore errors.
For example something like: =sum(c3+f3+h3+j3+n3) however, some of these cells may contain an error.
Between these cells there is data which I do not want ...
0
votes
1
answer
217
views
Get cells from another sheet based on criteria
I'm trying to build a simple helper to control my expenses.
One sheet has a list of all financial movements (income and payments), with these details:
Date
Amount
Reason
02/02/21
-1000.00
Rent
02/...
0
votes
1
answer
688
views
Excel - Use Formula In Different Cell From Referencing In If Statement
I am currently working on a listing template that uses different things like a title generator. This generator uses a ton of if statements based on the data that it is given. I have broken this ...
0
votes
1
answer
51
views
Prevent User to fill in a specified value into a cell before another cell is filled
Since I am not that well versed in Excel I have stumbled upon the following Problem:
I have the two cells:
A1 and B1
I want A1 not to be able to be filled with the value "1" before B2 is ...
0
votes
1
answer
5k
views
Excel: How to create a list of values in one cell for curent and previous values?
I have data that corresponds to "usage" of a product. I can manually update the value as it increases and save the previous values somewhere else.
However, I would like to have the previous value ...
0
votes
1
answer
183
views
simple sum in Excel but replacing one of the addends in its own cell
Am an Excel novice and have looked in several MS office books I got from the library but none say how to do the following, and I've performed a couple of general internet searches to no avail as well ...
0
votes
1
answer
620
views
Excel 2010 - CELL function not returning Worksheet
All over the INTERNET I found that CELL function returns the full file path, the Drive letter, Workbook and Sheet name in a format of C:\Folder\[workbook.xlsm] sheetname more or less by entering the ...
0
votes
0
answers
200
views
Case sensitive formula in excel
I’ve been playing with this formula because I couldn’t get the original syntax to work and it’s nearly doing what I would like. Please can you help me make it case insensitive?
Here is the data and ...
1
vote
2
answers
53
views
Sum cells based on the value of other cell
I am facing a problem that seems trivial in Excel. What I need to do is simply this:
In short, I have a large file of prices linked to a few people and I need to know how much each person paid. I've ...