All Questions
48
questions
0
votes
1
answer
50
views
Not using a cell as variable, whilst inserting a (excel-)formula in several cells
I'm facing a small, basic little problem, for which I can't find the solution:
I'd like to insert the same formula in several cells at once. Quickly googling this problem provides a solution:
Either ...
0
votes
2
answers
229
views
How to step up cell reference in function by numeric values based on known number of rows
This is in reference to the formula I need for cell F2 in the below image.
F2 shows the result I WANT:
I NEED: The Concat Formula to concatenate the data in Column B for each variant of whatever is ...
1
vote
2
answers
184
views
Robust linking of cells Excel
Is there a way to link cells so that not only content updates automatically, but also format (fill, border, font, etc.)?
Also, is there a way, other than doing each cell individually, to avoid blank ...
0
votes
2
answers
2k
views
Increment number with letter in cell
I have a column of random numbers that all begin with 'B*****' where the stars are numbers.
I need a formula to add 1 (+1) to the cell on the right of the number and take away 1 (-1) to the left of ...
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 ...
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 ...
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.
...
0
votes
1
answer
5k
views
How to link cells from access to excel?
I have a database in MS Access and I need to link some cell in MS Excel.
I need to link only few cells from a huge table that I update automatically.
Maybe it is easy but I know how to import table ...
0
votes
1
answer
453
views
Find a text cell in a range dynamically
I am trying to find a cell in excel using a formula from a range.
The range will be as such:
╔═══╦═══╦═══╦═══╦═══╦═══╦═══╦═══╗
║ ║ A ║ B ║ C ║ D ║ E ║ F ║ G ║
╠═══╬═══╬═══╬═══╬═══╬═══╬═══╬═══╣
║ ...
0
votes
1
answer
73
views
How to apply a fomula multiple times at different intervals to entire column? OO Calc
I am using Open Office Calc on windows 8.1 Pro
I have the following data already sorted nicely.
A B C
--+-----------------------
1 | Bmw Gold £80
2 | Bmw Silver £60
3 | ...
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
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 ...
-1
votes
1
answer
2k
views
Lock Drop Down Cells and Enable Use - Excel 2013
I would like a drop down list in a cell. I would like to lock the cell so it cannot be moved or altered but changes other than selecting from the drop down menu.
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,
...
0
votes
1
answer
9k
views
Multiplication of cells containing words
I'm making a finance plan, where I have the columns 'Quantity', 'Cost' and 'Total'.
The quantity column will contain how many of the item I buy.
The Cost column will have the individual cost of the ...