excel Questions
11
Solved
I need to get file name without extension name by VBA. I know ActiveWorkbook.Name property , but if user haves Windows property Hide extensions for known file types turn off, the result of my code ...
4
is there some tool to generate rest API specification in a MS Excel/MS Word format or any other human friendly table-like document from Swagger/OpenAPI spec in YAML. The result should be accessible...
Hadfield asked 10/4, 2017 at 21:2
5
Solved
I have a table called tblAccounts whose contents will come from an excel spreadsheet.
I am using MS SQL Server 2008 (x64) on a Windows 8.1 (x64)
I tried using the SQL Server Import/Export Wizard ...
Whimsicality asked 20/11, 2013 at 0:44
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
14
Solved
I need to fill a cell with the first non-empty entry in a set of columns (from left to right) in the same row - similar to coalesce() in SQL.
In the following example sheet
---------------------...
6
I am trying to check a table for specific data and if i found the data it will display the data. I did that with VLOOKUP. But now if the data is not in the table i want to interpolate between two s...
Gauthier asked 18/3, 2017 at 16:58
7
Solved
I'm trying to import excel file (.xlsx) using maatwebsite 3.0. How to fix This error
Call to undefined method Maatwebsite\Excel\Excel::load()
My controller
public function importsave(Request...
Meliamelic asked 25/3, 2018 at 6:20
5
Solved
In Excel, let's I have data in B2 to B7 and C2 to C7 . In VBA I can write a macro to select it:
Sub Macro1()
Range("B2:C7").Select
End Sub
How do I rewrite the code so that it chooses automatic...
Decima asked 10/10, 2016 at 21:36
4
Solved
I am working on vba macros. I was trying to use a dictionary. But it is giving error 457 with debugger pointing to toprow.Add ActiveCell.value, val. Can anyone please tell the issue? I even used Cs...
5
Solved
I have data in excel such as:
ID | Fee
123456789 | 100
987654321 | 100
987654321 | 75
987654321 | 50
I need to calculate a fee reduction for the items that are not the max price. The spreadsheet...
Lutenist asked 15/1, 2018 at 20:23
4
from datetime import datetime
x="Hello, it is now %s." % datetime.now().strftime('%d-%m-%Y %H:%M:%S')
import csv
try:
with open('output.csv', 'w+') as csvFile:
writer=csv.writer(csvFile)
w...
8
Solved
I have an excel file with 1 column and multiple rows.
The rows contain various text, here's an example:
texts are home
texts are whatever
dafds
dgretwer
werweerqwr
texts are 21412
texts are 34634...
1
Solved
I have a series of values in Excel.
The top row is a base number. The second row is how many values in each number in the series. The third row is the total value of that number in the series.
Not...
Biotin asked 4/6 at 11:8
6
Solved
I need to convert the Excel matrix FIRST in the table LATER:
FIRST:
P1 P2 P3 P4
F1 X
F2 X X
F3 X X
F4 X X
LATER:
F P VALUE
F1 P1 X
F1 P2
F1 P3
F1 P4
F2 P1 X
F2 P2 X
F2 P3
F2 P4
F3 P1
F3 P2 X...
Busily asked 12/12, 2013 at 11:11
7
Solved
My Excel file had a load of macros and now when I click Developer - Macros, they don't show up in the list, the list is empty. How do I fix?
Linstock asked 23/10, 2020 at 19:5
8
I want to open spss .sav data files in Excel without opening the spss files (I don't want to convert spss data file into Excel file). I know this is possible using OLDB connection, but I don't know...
13
Solved
I have an .xls file with a column of data. How do I count how many unique values are contained in this column?
I have googled many options, but the formulas I've found always give me errors. For ex...
6
This formula looks for the string "BFA" inside cell I3. If found, it returns "BFA"; if not, it returns "No".
=IF(ISNUMBER(SEARCH("BFA",I3)),"BFA","No")
How can I modify this to work for multiple...
Bloodline asked 9/1, 2015 at 19:14
9
Solved
Is there a setting that tells Excel to stop treating blanks as zeros?
I'm not looking for a workaround like =IsBlank() but a universal setting that shuts-down the blank->0 feature.
Nkrumah asked 2/4, 2012 at 14:9
14
Solved
I've got a massive Excel 2003 spreadsheet I'm working on. There are a lot of very large formulas with a lot of cell references. Here's a simple example.
='Sheet'!AC69+'Sheet'!AC52+'Sheet'!AC53)*$D...
Macneil asked 12/7, 2011 at 17:25
5
Solved
I'm having a hard time figuring this one out.
I have a short list of numbers in column C (C4 to C19).
Those numbers can range from 0 to anything. Never empty.
In column D is a date, in column E is ...
Hibbs asked 16/4 at 14:29
7
I need to format dates in excel, and I'm trying to use the TEXT formula. The problem is that Excel's intepretation of the arguments changes when the locale changes.
For example: if I have a date ...
Eritrea asked 5/7, 2019 at 10:26
4
I want to add leading "0s" to every number:
0000 & 1 = 00001
But I need to count the length because the total number of characters shouldn't exceed 5, so if the number is 30 then then excel ...
Unborn asked 16/10, 2013 at 19:16
4
Solved
13
Solved
I have columns of numbers that, for whatever reason, are formatted as text. This prevents me from using arithmetic functions such as the subtotal function. What is the best way to convert these "te...
Mikelmikell asked 21/4, 2016 at 13:41
© 2022 - 2024 — McMap. All rights reserved.