All Questions
74
questions
0
votes
1
answer
27
views
Can I Translate a Pasted Time Value in an Excel Cell So That It Is Stored and Displayed Correctly?
Whenever I input a time in the Excel cell it is not recognized. Given the custom format for the cell(s) that I am using, a recognized value inputted into the formula bar will be displayed correctly as ...
0
votes
1
answer
1k
views
Formula2 vs Formula in vba [duplicate]
I am using vba to edit the value of cells in excel. When i use the macro recorder, I see that excel is populating using this:
range("E10").select
activecell.formula2R1C1("my formula&...
0
votes
0
answers
117
views
How to get Excel Sheetname on Android without using CELL function
I tried to get the sheetname using formula "=CELL("filename",A1)" which was successful on PC (Windows) but when I transferred the file to use on my mobile phone (Android), the ...
0
votes
0
answers
40
views
Indirect function usage
I am trying to use the indirect function to refer to a cell in another workbook:
A1 = 'C:\Users\thekv\OneDrive\Documents\accessmydocs\[KVR 4.0.xlsm]SheetOne'!$e$32
B1 = indirect(a1)
I get #REF!
Is ...
0
votes
0
answers
48
views
Whats a concise formula for converting an N amount of hours into their respective minutes (Excel)?
To explain this better, let's use an example.
Number cell(AA1)
perHour formula(AA1/12)
perMinute formula(???)
30
2.5
?
45
3.75
?
The idea is to have the per minute formula convert whatever number ...
0
votes
0
answers
41
views
Excel giving cells numbers based on the number in another cell
Hope someone could help me out here. I am currently working in an Excel file where I have a cell with a number in there based on an IF formula it gives a number. Now I want let's say you have the ...
1
vote
0
answers
3k
views
What symbol should I use to indicate the 'cell above' in a formula that applies to a list with multiple values and blank cells I need to fill?
This formula below is what I need but entering an 'up' arrow does not work. When I do copy and paste an 'up' arrow (as typing 'up' only moves my curser back one) it creates the #NAME? error. Which ...
1
vote
1
answer
143
views
Formula VLOOKUP with dynamic lookup value
I want to let the lookup vale of a vlookup dynamic with the loop counter, I tried:
WS1.Cells(4 + j - 1, 3 + ((i - 1) * 9)).Formula = "=VLOOKUP(" & WS1.Cells(4 + j - 1, 4 + ((i - 1) * 9)) ...
0
votes
1
answer
627
views
Formula to select a date 3 business days later than the cell on its left
In my Excel workbook, I have "November 10th". I want every cell in the column to the right to display a date 3 days later, but it has to be a weekday Monday - Friday, it can't fall on a ...
0
votes
1
answer
170
views
What's the meaning of "cell range as a formula" in MS Excel / Apple Numbers
Step to reproduce:
Create an Excel file or Numbers file.
Fill cells from A1 to A10 with 1~10 (An has value n).
Assign cells from B1 to B11 with formula $A$1:$A$10 (WITHOUT SUM function).
And we ...
0
votes
2
answers
744
views
In excel 365 how to subtract values sequentially but skip empty cells
Not sure how to word this exactly. We have a spreadsheet to keep track of pump runtimes.
We want to subtract the run times in column B and output to Column C so for instance B4-B5 would output .3 to ...
-1
votes
1
answer
110
views
Is there a way to highlight the cell based on different values on another cells
I struggle to create a formula to highlight a cell.
I am working with two different sheets on workbook: 1.Production & 2.Stock missing
I am updating Production sheet with production order numbers (...
1
vote
1
answer
638
views
Control cell value from another cell in Excel
Having this image:
Is there some way of having something like a "control cell"? E.g.: if B1 (the control cell) has some text, B3 displays "HELLO"; if B1 is empty, B3 displays &...
0
votes
0
answers
1k
views
Leave cell blank until data entered
I would like for the totals to show nothing until data on left is entered (see image.) I have tried many formula's using the IF, ISBLANK, OR, and NA functions. Nothing seems to be working. I could ...
0
votes
0
answers
27
views
Excel Function - Copying
So for example if I have a spreadsheet with BYM01 in a cell and have about 8/10 blank under it then BYM02, how would I be able to copy the BYM01 automatically into the blank spaces under it until it ...