All Questions
1,060
questions with no upvoted or accepted answers
4
votes
0
answers
2k
views
Formula evaluation not working in NPOI 2.1.3.0
I am creating an Excel workbook in code behind and save it as both XLSX and PDF. I use a template workbook for this that has formatting and formulae to be evaluated after the generating is done. When ...
3
votes
0
answers
290
views
New excel formulas/functions with C#: Cannot implicitly convert type “bool”to“system.func<object>”
We created a new Excel formulas/functions with C#, the partial code is as below:
using ExcelDna.Integration;
using Excel = Microsoft.Office.Interop.Excel;
namespace Test_Atune
{
public class ...
3
votes
0
answers
480
views
Find/Extract Emojis from Excel
With Twitter Archiver (TAGS), I've collected tweets like that:
RT @LeyLaLaa: FINLAND | 8 ways to summer like the Finns in the Turku Archipelago 🇫🇮☀️ Sauna, lake, repeat 😍 ... @OurFinland #ttot
...
3
votes
3
answers
27k
views
extract a date from a cell containing text string in excel
For the Twelve Months Ending Thursday, June 30, 2016
I have the above text in excel and I need an excel formula to extract ONLY the date June 30, 2016. The formulas I've researched were all for ...
3
votes
1
answer
1k
views
VBA paste formulas from filtered column
is there way in Excel(VBA) to copy/paste formulas from filtered column in 1 statement ? This works :
Sheets(1).Range("A2:C" & LastRow).Copy
Sheets(2).Range("A2:C" & Range("D" & Rows.Count)...
3
votes
4
answers
81
views
Formula using Cells in the spreadsheet
I am looking for a way to set a variable equal to the number of non-empty cells in Column A using Excel VBA.
So pseudo code
Dim j As Integer
j = CountA(A:A)
This however does not work. Neither does ...
2
votes
1
answer
120
views
How to split a search string into parts, then check parts against a database
Here's what I'm dealing with:
We have a database of machines and their part lists are specified using strings. For example, one machine might be specified with the string &XXX&YYY-ZZZ, ...
2
votes
1
answer
50
views
Copy the cell color from SheetA to SheetB that has the same cell value
This is my first time posting a question here so please bare with me as I try to explain my problem the best I can.
I have two sheets in my workbook where Sheet1 visually represents a position of ...
2
votes
0
answers
1k
views
SUM multiple Measures in CUBEVALUE
I have tried multiple different functions CUBESET , CUBEVALUE etc., but I cant seem to find a way to SUM multiple Measures within the same formula. Any tips on how to get this done? I've searched ...
2
votes
1
answer
6k
views
Excel automatically update graph when adding new columns and rows in data
My excel graph comes from a table in another sheet, as shown in the above image.
The X-axis of the graph shows the month/year headers in blue in row 3 except column A&B (.... 43.july17, 44.aug17,...
2
votes
0
answers
198
views
Subtotal array formula does not count cells accordingly
Recently i've encountered an issue with the subtotal array formula. To be more explicit, i have the following scenario:
In my workbook i have two different sheets: Statistics and Bugs
In the Bugs ...
2
votes
0
answers
1k
views
import formulas as values using readxl::read_excel
I have a .xlsx spreadsheet with 2 sheets.
This is a screenshot of the first sheet:
And this is a screenshot of the second sheet. Note that cell A2 is a value:
And this is a screenshot of the second ...
2
votes
0
answers
199
views
execute function when a one cell changes but not another
I have calculated values in the column of cells 'N', and each cell has the following function (I am showing the function for the first applicable row N12):
=IF(ISNUMBER(F12),QUOTIENT(F12-...
2
votes
1
answer
706
views
Excel - Record how many items a customer buys
I need your expertise for this specific area.
I'm running customer/inventory record on my excel but I don't know how to count the number of items a customer buys in times. For example there're 2 ...
2
votes
1
answer
286
views
Transferring specific Info from one spreadsheet to another in Excel
I am a complete beginner in Microsoft Excel and am attempting to create a workplace Time Sheet where you enter information regarding your shift (times, who you worked with, etc.) and that information ...