• ## 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

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 Today, 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 Today, 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 Today, 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 Today, 09:01 PM

#### Creating an invoice number based on todays date IN EXCEL

=TEXT(TODAY(),"dmyy")&ROW(A1) copy down...

caabyyc Today, 08:53 PM