# Questions tagged [excel]

Only for questions on programming against Excel objects or files, or complex formula development. You may combine the Excel tag with VBA, VSTO, C#, VB.NET, PowerShell, OLE automation, and other programming related tags and questions if applicable. General help regarding Excel for single worksheet functions is available at Super User (http://superuser.com/).

265,240
questions

0
votes

0
answers

12
views

### Finding right price from an index list with priority in excel

I work in a world wide manufacturing company where we have warranty claims.
I need to make a list in Excel with priority that will find the right supplier => the right price for that warranty claim....

0
votes

0
answers

5
views

### Export data from Excel online hosted on sharepoint to fill out webform

Problem:
Data in an excel online workbook that is constantly beeing changed (rows added and data changes) contains data that is used to fill out webforms such as creating shipment slips. I want to ...

1
vote

1
answer

15
views

### Returning values of different columns with UNIQUE

So I have returned unique values from another sheet with =UNIQUE('sheet1'!A:A) and am now trying to also return values from one of those rows that are in different columns.
This is the kind of sheet I ...

0
votes

0
answers

9
views

### Excel: Save only filtered data model for Power Pivot and remove queries and connections

Good day,
This question has been asked on Stack Overflow but solutions are mostly for smaller datasets and the bigger ones don't have solutions yet (Sorry if missed it, but I couldn't find any on ...

0
votes

0
answers

4
views

### How to add two user adoption curves in excel dynamically?

I have the following problem: I created an s-curve cuntion (not with the built-in function, but with the mathematical function of an s-curve) which represents user inflow throughout the weeks.
e.g.:
...

0
votes

0
answers

16
views

### excel concatenate 3 cells

my question is when ever i try any combination i should get one of the result
row 1 is first letter of cells
row 2 is if Cell A is blank then two letter of Cell B then one letter of Cell C
row 3 is ...

0
votes

0
answers

11
views

### Postgresql: BIG (over 24h) Interval hh:mm:ss conversion to a date (excel, power query, power BI proper interval reading)

I am downloading data from PostgreSQL to excel, in interval format hh:mm:ss such: '233:51:46'. I need to use this data in such shape in Power Query, PowerBi and finally in excel.
To be honest excel is ...

0
votes

0
answers

14
views

### Defining Data Types in Excel and Building them in C#

I have excel spread sheets that define data types and then provide the data for these types. The excel file has a sheet for the classes, enums and data. I'm trying to read in the data in C# and export ...

0
votes

0
answers

8
views

### Interest and principal component calculation on excel not matching with amortization schedule shared with bank

I am trying to calculate the interest component and Principal component for a given outstanding amount in Excel and am trying to match it with the numbers given in the amortization schedule provided ...

0
votes

0
answers

7
views

### Best way to modify the result of a query before converting to excel in a Dtsx

I have a dtsx that performs various tasks, one of them is to retrieve data from a query and convert it for saving in an excel file
Some rows have a column with duplicate data, what I should do is make ...

0
votes

0
answers

14
views

### Excel: Nesting AND and COUNTIF in an IF

I'm struggling to count cell based upon criteria. I can make each formula work by itself but trying to nest them together turns it into scrambled eggs. What am I doing wrong?
=IF(
AND(
ATTENDANCE!$A:$...

0
votes

0
answers

10
views

### Dynamic List using VBA

I have a table in excel (image1)
enter image description here
I want to create a list as (image2)
enter image description here
The Category list once clicked will contain the table heading (OSAT) in ...

1
vote

1
answer

20
views

### Excel VBA CASE compare to list

Not too familiar with VBA but was able to google/modify the below macro. Macro is to look at column header and delete columns that do not match certain text. Macro has worked as intended. I'm trying ...

0
votes

1
answer

13
views

### Compare two columns in same sheet f excel and return unmatched records

I have an excel sheet with Gui-id in two column. I see GUID's does not get sorted in order(asc/desc).How can we Compare two columns in same sheet of excel and return unmatched records.
Example
name ...

-1
votes

0
answers

20
views

### VBA get value without using worksheet functions [duplicate]

I'm trying to do a macro that does a sumif and countif of Table1 to Table2 without using any worksheet functions. (Sumif, countif, etc.)