blocks

I am hoping someone can help me out. I am using a program to track my time used on projects (Toggl), but I have found that I have some missing time blocks. Instead of finding the time blocks manually, I'd like to use Excel to do this. The spreadsheet from Toggl looks like this <tbody>...

Hi all, I'm trying to use a formula to count the number of unique "blocks" of values. Below is an example. <tbody> Row # Column 1 Column 2 1 1 A 2 2 B 3 2 B 4 2 B 5 2 C 6 2 C 7 3 A 8 3 A 9 3 A 10 3 B </tbody> In this example there are 3 blocks: Block one is rows 2-4...

Hi all, I'm trying to use a formula to count the number of unique "blocks" of values. Below is an example. <tbody> Row # Column 1 Column 2 1 1 A 2 2 B 3 2 B 4 2 B 5 2 C 6 2 C 7 3 A 8 3 A 9 3 A 10 3 B </tbody> In this example there are 3 blocks: Block one is rows 2-4...

Hi there, it's my first post to this forum, which has been quite useful for my first steps on VBA. I need to loop through blocks of data set and export the data to a different sheet and predefined positions. I cant upload screen shots trough MrExcel add ins, so i will try to explain: There are...

Goodday everyone. I am preparing data to backtest a sector rotation momentum investing strategy, which is a part of my research project. For this I use intraday data. However, the query does (of course) not arrange the output like I would want it to. I have found a macro that adds a based on a...

Hi everyone. I need some help with my spreadsheet, maybe someone can figure it out. Basically i need excel to insert a block of cells from another sheet (including the dropdown menus and formulas in the blocks.) Ill try and draw what i mean: This would be what you see whe you begin...