• ## 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
Step 1 – Register, Activate Your Account and Log In
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

#### Delete rows depending on values in other rows

Hello there

Trying to sort out some rows in a sheet...

there is also a column name equipmentType (I) and contains "Wire"...

bdgull Today, 05:36 AM

#### Automatic quarterly date change

If cell D7 contains the date of a past bill, then in any other cell:
=EDATE(D7,3*(QUOTIENT(DATEDIF(D7,TODAY(),"M"),3)+1))
will give...

p45cal Yesterday, 09:59 PM

#### Partial Lookup Text with variable lookup values

try:

Code:
`=IF(SUMPRODUCT(ISNUMBER(SEARCH('Quality List'!\$C\$2:\$C\$500,F2))*(A2='Quality List'!\$A\$2:\$A\$500)*(LEN('Quality List'!\$C\$2:\$C\$500)>0))>0,"Yes","No")`
...

p45cal Yesterday, 06:48 PM

#### Excel 2002 Check if all six numbers have won before

Closed thread and anon125 knows why....

p45cal Yesterday, 03:37 PM

#### Automatic quarterly date change

Well true that was a mistake it should say may 17 now but after that it should say August 17

Sent from my Pixel 5 using Tapatalk...

Luigi802 Yesterday, 02:43 PM