Kaz's user avatar
Kaz's user avatar
Kaz's user avatar
Kaz
  • Member for 7 years, 5 months
  • Last seen more than a month 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

Deleting rows from a spreadsheet where Column C is blank

10 votes
Accepted

Excel Manipulation in Single Procedure part 2

10 votes
Accepted

Extracting Country Names from Cell Values

9 votes
Accepted

Summarizing data from multiple sheets

8 votes
Accepted

Pasting Values To/From a Calculation Model

8 votes
Accepted

Create a list of random numbers with sum = n

8 votes
Accepted

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

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

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

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

Deca dimensional ascending and descending array sort function

6 votes
Accepted

Reading XML files from RSS of different websites in PHP

6 votes
Accepted

Spreadsheet Manipulations in Single Procedure