All Questions
18
questions with no upvoted or accepted answers
3
votes
0
answers
348
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 ...
- 31
1
vote
0
answers
335
views
LibreOffice Calc: when copying an empty cell, it turns into a zero?
In a LibreOffice spreadsheet, when I want to duplicate a cell's content, I use =<source coords>. For example if I want cell A2 to contain a duplicate of whatever is in A1, I fill in =A1 in A2.
...
- 1,172
1
vote
0
answers
296
views
Excel: VLOOKUP with cell containing multiple references
I have a table which contains multiple references per cell separated by a blank space.
In an other table that contains one line per reference, I want to use VLOOKUP to retrieve the name of the ...
- 123
0
votes
2
answers
70
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
121
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) ...
- 1
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 ...
- 1
0
votes
1
answer
694
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 ...
- 1
0
votes
1
answer
52
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 ...
- 1
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 ...
- 41
0
votes
1
answer
621
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 ...
- 11
0
votes
0
answers
201
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 ...
- 19
0
votes
1
answer
79
views
Excel: Data across multiple columns and rows
Currently have a table like this:
How can I consolidate and count the hours per person spent on each day. Need to be on seperate lines due to working on different tasks but want to bring in all ...
- 1
0
votes
1
answer
693
views
How do I calculate the ratio for a range of cells in excel?
I'm trying to calculate the number of females per 100 males in each state and display the result using cell arrays. If the data for any state is unavailable or producing an error, then empty cell ...
- 1
0
votes
1
answer
2k
views
Formula or VBA for cell formatting using value based on a cell but formatting from an other cell
I have a fixed set of values, (0%,20%,40%,60%,80% and 100%) in column E.
If I fill a cell in column E with any of the above values, the cell G should pick formatting from another cell.
For example,
...
- 1
0
votes
1
answer
3k
views
Conditional Formatting for one cell value in a list, another cell blank
Looking for how to do Conditional Formatting for the following rule:
If a number in a cell equals one of a list of particular numbers, then information MUST be entered into an additional cell. Both ...
