• ## Other - General

### Forum Guide

by Published on 2016-11-07 12:48 AM

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

#### Formulae / LOOKUP help

Great. Thank you so much!...

Beddy Boy Today, 02:32 AM

#### Formulae / LOOKUP help

I mentioned it's a pivot table; it needs refreshing: right-click it and choose Refresh.
Because it's a pivot table, if the size of source data changes,...

p45cal Yesterday, 11:01 PM

#### How to Copy From Multiple Sheets Based On 1 Sheets Input

The attachment in msg#9 has been updated to cater for that.
If the Data sheet is empty, that too will cause an error - I haven't done anything about...

p45cal Yesterday, 10:57 PM

#### Looking for Excel formula

For reference

Assuming valid date is in A1:B999,

C1=IF(A1="","",SUM(OFFSET(B1,,,MIN(IF(A2:\$A\$999"",ROW(A2:\$A\$999)-ROW(),999)),1)))...

caabyyc Yesterday, 09:10 PM

#### Formulae / LOOKUP help

Yeah sorry, Q3 - that's a typo...

Sorry for my ignorance but your Table 3 does not change if I change the scores in Table 1 and re-create...

Beddy Boy Yesterday, 09:01 PM