worksheet-function Questions
4
Solved
In Excel, I would like to round to the nearest fibonacci number.
I tried something like (sorry with a french Excel):
RECHERCHEH(C7;FIBO;1;VRAI) -- HLOOKUP(C7, FIBO, 1, TRUE)
where FIBO is a nam...
Lightweight asked 28/6, 2011 at 15:47
4
Solved
I'm using Google App Script for the first time.
I'm using it on a Google Doc spreadsheet.
I'm trying very simple functions, just to learn the basics. For example this works:
function test_hello()...
Aesir asked 26/7, 2012 at 0:14
11
Solved
What function can I use in Excel VBA to slice an array?
Goldston asked 6/10, 2008 at 16:54
5
Solved
I have a total data set that is for 4 different groupings. One of the values is the average time, the other is count. For the Total I have to multiply these and then divide by the total of the coun...
Lindsay asked 9/3, 2010 at 23:0
3
Solved
In column A I have 20000 rows with filename with file path
"C:\person\microsoft\ygkyg\mmddyy\filename.xls"
"\server-41\performance\mmddyy\filename.doc"
.....
etc.
In column B I just want to...
Harkins asked 31/3, 2011 at 18:51
24
Solved
I use the following function
=DAYS360(A2, A35)
to calculate the difference between two dates in my column. However, the column is ever expanding and I currently have to manually change 'A35' as...
Tridentine asked 14/11, 2011 at 0:34
3
Solved
In Excel, with the following function:
=IF(AND(N3=1,ISNUMBER(D3),ISNUMBER(E3)),SUM(D3:E3)-2,IF(AND(N3=1,D3="",E3=""),G3,IF(N3=1,"",IF(AND(N3=0,ISNUMBER(D3)),D3-1,IF(AND(N3=0,ISNUMBER(E3)),E3-1,IF(...
Tilsit asked 15/10, 2016 at 17:8
5
Solved
Is there some way of getting an array in Excel of a smaller size than a starting array in a cell worksheet function?
So if I had:
{23, "", 34, 46, "", "16"}
I'd end up with:
{23, 34, 46, 16}
...
Samualsamuel asked 18/10, 2011 at 23:53
27
Solved
Does anyone know the formula to find the value of the last non-empty cell in a column, in Microsoft Excel?
Probe asked 26/3, 2011 at 11:5
5
Solved
If I have a set of cells in a worksheet that I want to add up, I can use the formula:
=SUM(Sheet1!A1:A10)
To do this in a sub, I would use:
Sub example1()
Dim r As Range, v As Variant
Set r ...
Pink asked 27/5, 2016 at 20:17
16
Solved
I would like to write an IF statement, where the cell is left blank if the condition is FALSE.
Note that, if the following formula is entered in C1 (for which the condition is false) for example:
...
Chimpanzee asked 12/9, 2013 at 15:9
5
Solved
Is there a way to pretty print Excel formulas?
I've got a few worksheets of semi-complex formulas to slog through, so this would make my life a bit easier.
I'm just looking to turn something like t...
Irons asked 18/9, 2009 at 21:41
7
Solved
I am trying to open an XLSX file as a template (I have even used a blank XLSX file), using EPPLUS 4.0.3.
If I do not open the template file (blank or the real one) and just create a new workbook a...
Literatim asked 21/4, 2015 at 14:27
4
Solved
I would like to use empty range in following manner :
Set NewRange = Union(EmptyRange, SomeRange)
I've tried to set EmptyRange as empty range using Nothing, Empty and Null but "run-time error '5'...
Glennaglennie asked 18/12, 2014 at 20:12
6
The following piece of code works in Excel prior to 2010:
myRange = Range("A:A")
NumRows = Application.CountA(myRange)
There are 38 cells containing text/values in column A. When the cod...
Lavina asked 17/9, 2014 at 12:28
10
Solved
In a worksheet function in Excel, how do you self-reference the cell, column or row you're in?
Vanderhoek asked 13/6, 2011 at 19:54
5
Solved
I have a simple problem that I'm hoping to resolve without using VBA but if that's the only way it can be solved, so be it.
I have a file with multiple rows (all one column). Each row has data th...
Thermistor asked 16/8, 2011 at 23:19
13
Solved
Whats the best way to round in VBA Access?
My current method utilizes the Excel method
Excel.WorksheetFunction.Round(...
But I am looking for a means that does not rely on Excel.
Mohsen asked 26/9, 2008 at 0:30
7
I'm trying to make a function MonstersInLevel() that filters the second column of my "LevelMonsters" named range based on the value of the first column. The range's first column represent...
Crosswalk asked 5/6, 2020 at 2:8
13
Solved
How do I obtain a reference to the current cell?
For example, if I want to display the width of column A, I could use the following:
=CELL("width", A2)
However, I want the formula to be somethi...
Argentite asked 16/4, 2009 at 18:21
5
Solved
How do I calculate Excel's XIRR function using C#?
Gabe asked 3/3, 2011 at 11:3
9
Solved
I have 0,4*A1 in a cell (as a string). How can convert this "string formula" into a real formula and calculate its value, in another cell?
Weightlessness asked 17/12, 2010 at 15:17
4
Solved
How to get the first and last day of the previous month in Google Sheets?
Martyrize asked 29/6, 2015 at 10:23
4
Solved
Is it possible to filter an array using a single formula (without autofilter, VBA, or additional columns)?
For example, I have the following spreadsheet:
A | B | C
--------------------
1| ID | ...
Voletta asked 27/6, 2011 at 18:10
7
Solved
I want to get values from other sheets.
I have some values in Excel (sheet2) for example:
A B C D
- - - -
1 | 2 5 9 12
2 | 5 8 4 5
3 | 3 1 2 6
I sum each column in row 4.
I'm working with ...
Integrate asked 10/11, 2010 at 20:29
1 Next >
© 2022 - 2025 — McMap. All rights reserved.