• ## Other - General

### Forum Guide

by Published on 2016-11-06 11:48 PM

Getting the Most From Excelguru Forums
We take a lot of pride in providing good help, and really want our users to walk away with an answer to every question.

How the Forum Works

Using the Forum
Before you can post a question, you must register and log into the forum. This is generally a 3-step process:

1. Register
2. Activate

If you haven’t already done so, you need to register for an account by visiting our forum registration page. Fill out the form and click on the white “Complete Registration” button.

Once you’ve submitted your registration, you will receive a confirmation email from (webmaster)@excelguru.ca. Inside that email is an activation link. Please click it to confirm that you’re a real person. ...
• ### Recent Forum Posts

#### Sumproduct help!

You can do most of this with pivot tables. See Summary sheet, 2 tables at cells B21 and B36.
I added a New/Used column to the 2019-2020 sheet (column...

p45cal Today, 02:34 AM

#### Move a cell row to another worksheet based on cell value

Hi Treacy,

I assume that you were actually referring to me rather than the OP. The code modified as follows may actually suit you better:-...

vcoolio Today, 02:04 AM

#### Formula to Counting Customer Sums

Another solution
[code]
=SUMPRODUCT((\$A\$4:\$A\$22"")*(\$B\$4:\$C\$22>=A26)*(\$B\$4:\$C\$22=A26)*(\$B\$4:\$C\$22...

navic Yesterday, 04:27 PM

#### VBA or Macro to add rows between dates

From:

I can get you:

or:

Or is neither of these right?...

p45cal Yesterday, 01:52 PM

#### VBA or Macro to add rows between dates

Are those start dates right in both tables?
What's the relation between:
1/1/2015 and 15/1/2015 (14 days later)
2/4/2017 and 10/4/2017...

p45cal Yesterday, 01:00 PM