User Kaz

15 votes

Multi-dimensional array sort and filter functions

answered Dec 18, 2015 at 23:13

15 votes

Accepted

Copying values from one sheet to another

answered Jun 16, 2016 at 15:51

15 votes

Macro that does some kind of duplicate check

answered Jun 20, 2016 at 13:11

13 votes

Accepted

Module for implementation in multiple version-controlled spreadsheets

answered Dec 16, 2015 at 22:10

12 votes

Accepted

Copy, Paste And Format

answered May 24, 2016 at 13:58

11 votes

Converting from .xlsx to .txt

answered Jun 23, 2016 at 12:01

11 votes

Accepted

Extract values within date and zone ranges

answered Dec 16, 2015 at 18:01

10 votes

Accepted

Excel Manipulation in Single Procedure part 2

answered Nov 28, 2015 at 22:23

10 votes

Accepted

Extracting Country Names from Cell Values

answered Apr 1, 2016 at 14:41

9 votes

Accepted

Deleting rows from a spreadsheet where Column C is blank

answered Jan 12, 2016 at 13:52

9 votes

Accepted

Summarizing data from multiple sheets

answered Aug 16, 2016 at 15:43

8 votes

Accepted

Pasting Values To/From a Calculation Model

answered Aug 3, 2016 at 11:52

8 votes

Accepted

ExcelVBA loop exports data from spreadsheet to table within Excel

answered Jan 14, 2016 at 13:48

8 votes

Life is a Game - Play it

answered Dec 22, 2015 at 11:13

8 votes

Accepted

Find value from other dataset based on 6 variables that must be equal in both datasets

answered Dec 20, 2015 at 2:01

8 votes

Using VBA to "apply names" to named range references

answered Dec 4, 2015 at 16:07

8 votes

Accepted

Code to find value into a table by 2 criteria (x,y)

answered Nov 26, 2015 at 14:40

8 votes

Accepted

Create a list of random numbers with sum = n

answered Jun 15, 2016 at 14:48

7 votes

Accepted

Concatenate disjoint Excel ranges to use as a single range in a formula

answered Nov 27, 2015 at 15:56

7 votes

Accepted

Analysis tool for a log file

answered Nov 26, 2015 at 13:55

7 votes

Accepted

Financial Data From Webqueries in Excel

answered Aug 31, 2015 at 1:54

7 votes

Web Scraping with VBA

answered Dec 2, 2015 at 22:29

7 votes

Word VBA function to find a specified heading & return its text as a string

answered Jul 15, 2016 at 16:16

7 votes

Accepted

Find cells with specific formatting

answered Jan 25, 2017 at 15:22

7 votes

Delete rows in spreadsheet where cells match some patterns

answered Feb 15, 2017 at 16:40

6 votes

Accepted

VBA macro - searches through a filtered table, stops when entry passes criteria

answered Jul 18, 2016 at 13:26

6 votes

Excel VBA used to fetch Access data

answered Jul 28, 2016 at 10:04

6 votes

Accepted

Filling a row with values

answered Jul 6, 2016 at 16:34

6 votes

Accepted

Raw exchange trade data analysis program

answered Dec 20, 2015 at 3:06

6 votes

Function to find the kth match (2)

answered Dec 21, 2015 at 0:31

Stack Exchange Network

91 Answers

Multi-dimensional array sort and filter functions

Copying values from one sheet to another

Macro that does some kind of duplicate check

Module for implementation in multiple version-controlled spreadsheets

Copy, Paste And Format

Converting from .xlsx to .txt

Extract values within date and zone ranges

Excel Manipulation in Single Procedure part 2

Extracting Country Names from Cell Values

Deleting rows from a spreadsheet where Column C is blank

Summarizing data from multiple sheets

Pasting Values To/From a Calculation Model

ExcelVBA loop exports data from spreadsheet to table within Excel

Life is a Game - Play it

Find value from other dataset based on 6 variables that must be equal in both datasets

Using VBA to "apply names" to named range references

Code to find value into a table by 2 criteria (x,y)

Create a list of random numbers with sum = n

Concatenate disjoint Excel ranges to use as a single range in a formula

Analysis tool for a log file

Financial Data From Webqueries in Excel

Web Scraping with VBA

Word VBA function to find a specified heading & return its text as a string

Find cells with specific formatting

Delete rows in spreadsheet where cells match some patterns

VBA macro - searches through a filtered table, stops when entry passes criteria

Excel VBA used to fetch Access data

Filling a row with values

Raw exchange trade data analysis program

Function to find the kth match (2)