Top "Excel" questions

VBA Macro On Timer style to run code every set number of seconds, i.e. 120 seconds

I have a need to run a piece of code every 120 seconds. I am looking for an easy way to …

vba excel timer scheduling

PivotTable to show values, not sum of values

I'm wanting to display a pivot table and for it to show me the actual values, one on each row, …

excel if-statement excel-formula excel-2007 pivot-table

Find if value in column A contains value from column B?

I have two columns- column E which extends upto 99504(values) and column I which extends to 2691(values).Both the columns …

vba excel excel-2007

what is this value means 1.845E-07 in excel?

I am reading the excel sheet from C# by using interop services. My sheet has one of cell value as 0.00. …

excel scientific-notation

`IF` statement with 3 possible answers each based on 3 different ranges

I have 3 ranges of numbers and the answer depends on the range. 75-79=0.255 80-84=0.327 85+ =0.559 I tried to create an equation …

excel if-statement worksheet-function

VBA: Conditional - Is Nothing

There is an If condition in a VBA application as seen below: If Not My_Object Is Nothing Then My_…

vba if-statement excel excel-2007 nothing

Convert xlsx to csv in Linux with command line

I'm looking for a way to convert xlsx files to csv files on Linux. I do not want to use …

linux excel csv converter xlsx

Excel - find cell with same value in another worksheet and enter the value to the left of it

I have a report that is generated in Excel which contains an employee's number, but not his/her name. Not …

excel excel-formula spreadsheet vlookup

DataRow: Select cell value by a given column name

I have a problem with a DataRow that I'm really struggling with. The datarow is read in from an Excel …

c# .net excel datarow

In Excel, how do I extract last four letters of a ten letter string?

For example, if I have ABS YUR YUAO HFH IWO OQNX YQO PQM QUCC How do I extract the last …

excel extract excel-formula