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/).

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....
user avatar
  • 13
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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.: ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 99
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 ...
user avatar
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 ...
user avatar
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:$...
user avatar
  • 43
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
-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.)
user avatar

15 30 50 per page
1
2 3 4 5
17683