current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0

Tagged Questions

Use the Excel tag only for questions which involve programming directly. If you seek general help regarding Microsoft Excel which is not about programming than consider asking your question at [SuperUser](http://superuser.com/). It is OK to combine the Excel tag with VSTO, C#, VB.NET, ...

learn more… | top users | synonyms (2)

0
votes
1answer
10 views

Summing a column value with each row value in excel

I want to add a column value with each row value in an excel. I would insert an image of my spreadsheet but apparently I need 10 reputation to do that. Basically, it would be the following: Cell B2 ...
0
votes
0answers
5 views

Is it possible to assign Permissions to a worksheet by User or Station?

Not sure if this is even possible... I know how to protect the entire sheet with VBA code but striking out otherwise. I've tried to implement the Excel "Allow Users to Edit Ranges" but will not work ...
0
votes
0answers
10 views

Converting lengthy Excel function to SQL?

IFERROR((SUMIFS('Sheet 1'!$K:$K,'Sheet 1'!$A:$A,'Sheet 2'!I$5,'Sheet 1'!$C:$C,'Sheet 2'!$B15,'Sheet 1'!$K:$K,"<>0"))/(SUMIFS('Sheet 1'!$J:$J,'Sheet 1'!$A:$A,'Sheet 2'!I$5,'Sheet 1'!$C:$C,'Sheet ...
0
votes
0answers
9 views

How to obtain the y-value from a chart when I know the x-value?

I have a scatter chart with smoothed lines. I know the x-values of the points where peaks are, and I want to know the y-values of the peaks at those points. I then want to assign that value to a cell ...
0
votes
1answer
12 views

VLOOKUP with Alphnumeric codes Failing even though they are equal.

What I'm trying to do is use VLOOKUP to search through for an Alphanumeric serial number in a range of data in another sheet. However, it does not seem to be recognizing that there is a match when I ...
0
votes
0answers
9 views

Reading from ByteArray yields “End of file was encountered” (Actionscript 3)

I can't seem to figure out what is going on here. I'm developing a mobile app in Flash Builder 4.7 that reads through an Excel spreadsheet and extracts data, and I keep getting the following error ...
0
votes
1answer
19 views

Trying to get data from excel then store it inside array and later print it

I am trying to read data from an excel file. When i run the below code it runs without any error but won't give any data. When i checked the code i found that the global variable rownum is not ...
-1
votes
0answers
30 views

How to return a double from a vba excel function?

Function test() As Double If ThisWorkbook.Worksheets("A").Range(type) = "1" Then test= 26# ElseIf ThisWorkbook.Worksheets("A").Range(type) = "2" Then test= 78# End If End ...
-1
votes
2answers
17 views

Count Unique Occurrences in Excel

I have a row called Name. There are about 20k values in it. How would I get a unique count of the values in the row? I want bob to be counted once and not 5 or 6 times. Thank you in advance. Name ...
0
votes
1answer
9 views

Wrong information showing in Xlwt export in Django

I´m having a hard time with this. I have a button at the bottom of a page. This page shows the render information of a bill, every bill is different so this information changes all the time. The ...
-1
votes
3answers
22 views

To find the absolute difference have negative and positve values

I have 2 columns having mix positive and negative values. sometime one column have positive and other is negative. I need to find the absolute difference between two column. what i am doing is first i ...
0
votes
2answers
20 views

Unpivoting an Excel table with 100 columns into rows

I have a table in my Excel sheet that looks like this: Code _01001 _01002 ---------------------- 1 88 371 2 88 371 3 88 371 And I want to convert it to the ...
1
vote
1answer
16 views

Unable to open exported xlsx file

I am trying to export into excel with xlsx format but getting this error when trying to open the file. Excel cannot open the file 'CertificationMetricsReport.xlsx' because the file format or file ...
-1
votes
1answer
30 views

Excel to CSV to TXT cells with double quotes

I have an excel spreadsheet with values in each of the cells that I'm looking to convert to a comma-delimited text file. Currently I have a vbs script that is converting the excel file to a csv, then ...
0
votes
2answers
29 views

Reading names with special characters using R

I've an excel (xlsx) table and in the column "PLAYERS" European players have an asterisk in their names and South Americans don't. Something like this PLAYERS Neymar *Bale* Messi ...
-2
votes
0answers
21 views

Excel: Matching based on multiple criteria, with 1 mathematical condition

I have the following dataset. A1: Albania |A2: 2007 |A3: Value to Fill |A4: Afghanistan |A5: 2007 |A6: 0 B1: Albania |B2: 2009 |B3: Value to fill |B4: Albania |B5: 2008 |B6: 0.62 C1: ...
-2
votes
1answer
13 views

Catching people removing Excel passwords

I have several Excel files passworded in different ways. Password on Open Password on Sheet Password on VBA Password on workbook I have search for hours and cannot find any vba that i can run on ...
0
votes
0answers
16 views

How to connect excel to a table on a password protected website

I'd like connect an excel sheet to a password protected website that will automatically login(or prompt you to login) then pull table data. I've found a few questions like this but the problem I ...
0
votes
4answers
35 views

SQL Server 2012 Date Change

I am attempting to convert the DATETIME Column titled CREAT_DTTM to a simple "1/1/2014" format. I have looked at CAST, CONVERT and FORMAT functions but i just can't get it to work. Any guidance ...
-1
votes
0answers
14 views

Excel formula to highlight cells based on the data from the other table

I have data on excel like in the img below (not highlighted part). I need to write a formula (conditional formatting) to highlight the cells on the first table if their name and date criteria matches ...
0
votes
0answers
4 views

save html form data to excel sheet

how to save the html form data (in a website, when the user fills the form and clicks on submit button) to an excel sheet. Also do we have to install ms office on hosting server or without this can it ...
1
vote
1answer
22 views

Substituting all foreign characters in a string

In Microsoft Excel, I have a cell that contains the name of a product I'm selling. That cell has a possibility of containing foreign accents in it. What I would like to do is replace the foreign ...
-1
votes
2answers
20 views

Merge Rows with Same Column A

I am new to VBA and from what I have seen it will be the best way to go about doing what I want to do. I have an excel spreadsheet with Column A being the name of a company and Column B being the ...
-1
votes
0answers
9 views

In excel, how do I sort by one column but keep all adjacent columns also fixed to it?

I have a relatively simple excel issue, but I can't seem to get it working. Here is my chunk of spreadsheet : For some reason, when I sort by "Resource" column(ascending), it only will sort the ...
0
votes
1answer
20 views

VBA For Each Loop only excutes once and then stops

I made a VBA macro that has the goal of doing several find and replaces on a database using a set of items in a table. I used a for each loop to try to iterate through each cell in the first column, ...
0
votes
1answer
24 views

Comparing two worksheets with different column order

I'm trying to compare two worksheets in excel to find new/updated records using vba. (assume worksheet 1 is old, and worksheet 2 has the potential new/updated entries) These sheets have very similar ...
1
vote
1answer
19 views

Handling data truncation in Talend

I am copying data from Excel sheet to the SQL server tables. In some of the sheets I have data bigger in size of the Table's schema in SQL. i.e. Table's column has data type nvarchar(50) where as my ...
0
votes
1answer
11 views

Conditioned Date Ranges-Month&Year table Excel

The Setup: (Dummy setup) Have a Data Set with Columns for Year and Month Year Column: 2014,2013,2014,2014,20113,2014... and so on in that pattern Month Column: 1,12,3,4,5,1,2,3,2,2,11,1,1,3,2.. ...
0
votes
0answers
24 views

Excel Changes Cell Formula

Alright, So I work with an excel file approx. 10 000 rows on each of 12 sheets. This file is used quite a bit to pull data from (i.e. sorted, filtered, changed manually) but I never tamper with the ...
-1
votes
0answers
22 views

How to loop through files, copy from open file and paste to a single file?

This is my first time using Excel and I'm not a programmer. This code is from another post. I've been trying to replace the bold selection inside the loop with something that will select and sum the ...
-1
votes
0answers
16 views

REPOST: How to get numbers to not convert to decimals when converting xls to csv using python?

I am trying to insert excel data into a table (postgres) using a python script. I am running into an issue though where all the numbers get converted to decimal (ie 8 -> 8.0). I realized this is ...
0
votes
0answers
11 views

Excel Workbook opening issue using VBA

I have a VBA application and I need to deal with these 3 cases: (1) When I double click in a .xla file from Windows Explorer (2) When I click in the Excel button icon from Start Menu (3) When I ...
0
votes
0answers
7 views

MVC ExcelDateReader - Identify Data?

Is it possible using ExcelDateReader to identify if data being returned from a cell, belongs to a specific column? Below is a sample of the code I am using to open an Excel spreadsheet, but I need to ...
-1
votes
0answers
10 views

Take data from a specific site with search

Take data from a specific site with search I am new in VBA and i am trying to find a way to take some results of a specific search in the web site to my Excel. I have to two problems. First I can't ...
0
votes
1answer
13 views

Google Script - How to set formula to adjacent cell

I am trying to set a formula in Google Spreadsheet F2:F if E2:E has a date. If E2:E is blank, then no formula is set to F2:F. My Code so far. Any Help or suggestions would be much appreciated. ...
1
vote
0answers
13 views

Creating an html formatted file to be opened by Excel

I am trying to export a spreadsheet file from a website. The data is a bit too complex for a simple csv, so I figured the best way to do it was to format it into a file containing nothing but an HTML ...
1
vote
1answer
19 views

Is it possible to insert text boxes/labels into a chart using vba?

I'm currently writing a program that will graph an x-ray spectrum, and then calculate where all of the peaks are, and what they should be labeled. However, I'm not sure how I can add the labels of ...
0
votes
0answers
4 views

Offset function in Excel for position mismatches

I have a workbook that contains two spreadsheets where I organize my data according to dates. In one of them I run a data query and in the other one I organize the query's data otherwise. In my data ...
-1
votes
1answer
16 views

Encountering Error when trying to INSERT INTO an excel file

I'm trying to figure out how to insert a row of data into an existing Excel file. The file is simple with ONLY 3 headers, CITY STATE and ZIP. I've selected the 3 cells in Excel and named the ...
0
votes
0answers
24 views

Simple text coding/decoding Excel VBA

I have made nice macro that will send login details to API which will return as response security string that is used for sending further commands to API and executing them. I am a bit worried about ...
1
vote
1answer
22 views

application.run vba not working with sheet macros

My file has different sheets with the same-named sub routine inside each doing different things specific to the sheet. So, I'm trying to call dynamically a macro inside a selected sheet using ...
-1
votes
2answers
15 views

Loops with advanced filter, new criteria every Loop

I have this code: Sub omgifthisworks() Sheets("data").Select Columns("A:A").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:= _ Sheets("log").Range("A1:A4"), Unique:=False ...
1
vote
2answers
17 views

Excel - Count Unique String Variants

There could be quite a simple solution to this, but I am trying to find the number of times a unique variant (i.e. non-duplicates) of a string appears in a column. However this string is only part of ...
0
votes
0answers
4 views

Pasting into a dynamic number of columns

I am trying to take a number in a cell and paste it in to a dynamic number of columns. I would also like to put the years above the pasted numbers. To aid in explaining: If a project generates an ...
1
vote
3answers
36 views

How do I find a value in a row and return the column number with VBA?

My excel sheet is filled with zeroes except for one cell in every row. I want to find that cell and return the column. For example: In the cell T616 is a value other than 0. May it be -15400. I want ...
1
vote
2answers
22 views

Add formula to range using VBA

I would like to add a formula to the to a range of cells. It should multiply the a neighbor cell by 100. Therfore I tried the following: Range(Cells(row, col + 17), Cells(row + num_positions, col + ...
0
votes
0answers
22 views

Convert datatable to .xlsx format

public static void ExportToExcel(DataTable dtExcel, string fileName) { string attachment = "attachment; filename=" + fileName + ".xlsx"; ...
0
votes
1answer
16 views

Uploading file to SQL Server, cannot retrieve it properly

My question is the following: I'm trying to upload an Excel file to database with this method: using (SqlConnection connection = new SqlConnection(@"Data Source=TESZT1\SQLEXPRESS;Initial ...
1
vote
1answer
9 views

Excel VBA - Paste into Find Command

This is my first time asking a question on stackoverflow (but I've found a lot of super helpful information here before!) I'm trying to create a macro which searches for a string of text that has ...
-1
votes
0answers
12 views

Excel macro - two sheets copy entire row to third sheet if column matched

I've two sheets (order + list of all products with description) which I need to match by one column (product code, C in 1st, N in 2nd) and those rows wicho match I need to copy entire row from the ...

1 2 3 4 5 … 985