Skip to main content
Kaz's user avatar
Kaz's user avatar
Kaz's user avatar
Kaz
  • Member for 10 years, 3 months
  • Last seen more than 1 year ago
  • London, United Kingdom
15 votes

Multi-dimensional array sort and filter functions

15 votes
Accepted

Copying values from one sheet to another

15 votes

Macro that does some kind of duplicate check

13 votes
Accepted

Module for implementation in multiple version-controlled spreadsheets

12 votes
Accepted

Copy, Paste And Format

11 votes

Converting from .xlsx to .txt

11 votes
Accepted

Extract values within date and zone ranges

10 votes
Accepted

Excel Manipulation in Single Procedure part 2

10 votes
Accepted

Extracting Country Names from Cell Values

9 votes
Accepted

Deleting rows from a spreadsheet where Column C is blank

9 votes
Accepted

Summarizing data from multiple sheets

8 votes
Accepted

Pasting Values To/From a Calculation Model

8 votes
Accepted

ExcelVBA loop exports data from spreadsheet to table within Excel

8 votes

Life is a Game - Play it

8 votes
Accepted

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

8 votes

Using VBA to "apply names" to named range references

8 votes
Accepted

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

8 votes
Accepted

Create a list of random numbers with sum = n

7 votes
Accepted

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

7 votes
Accepted

Analysis tool for a log file

7 votes
Accepted

Financial Data From Webqueries in Excel

7 votes

Web Scraping with VBA

7 votes

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

7 votes
Accepted

Find cells with specific formatting

7 votes

Delete rows in spreadsheet where cells match some patterns

6 votes
Accepted

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

6 votes

Excel VBA used to fetch Access data

6 votes
Accepted

Filling a row with values

6 votes
Accepted

Raw exchange trade data analysis program

6 votes

Function to find the kth match (2)