- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
If it's an updraft, filter may be at bottom of unit. Filters are usually installed in the return air side of the system. If you have a return air plenum it may be under a removable plate cover. Also check you return air grill inside your house, filter may be inside this grill,which have opening latches.
To reference the first letters in a cell, use the left function. The syntax is =left(cell,#). So, to return the left two letters from cell A1, you use =left(a1,2). You can put that in a cell or incorporate it into some functions.
There are a couple of types of spreadsheet - Depending on the size of the data you are working with - filter may the quickest option or Query report.
Your worksheet will contain all your data i.e. Customer, contact no, outstaning actions and due date - You can create a filter aon this set criteria on the due data - as less than or equal to todays date - which will only display your outstanding actions required by today or earlier.
Another option if you have installed MS Query, is to create a seperate report - again using the criteria of due date being less than or equal to today.
Producing this from your existing data is much easier than trying to re-create your data - But I can send you how I would create this sheet if the above explanation is not easy to follow - If you let me have your email address.
Do a list of the different cat, and use sumif
For cat 0101 (in cell F1)
formula to put in G1
=sumif($A$1:$A$7000;F1;$D$1:$D$7000) where F1 contain 0101
expand the formula for other cat. (G2, G3, etc)
You can use a assistant to extract the distinct cat from A1:A7000, sorting them and copy the result in F (Menu Data-> Filter -> elaborate filter)
First thing is to check all your hoses, and filters. Filters rob your vacuum of air flow which equals power.. I don't think that you have a clog so much as I am inclined to think that you have dirty filters. In a wet vac, you can rinse your filters out, but they will eventually need replaced. It's a good idea to have an extra filter around for such an instance.
For Current Date - you can use the =Now() function in your cell where you want the date.
For Contract #, I don't know what you're using, but you can link to a database of contract #s (see below), or you can name a range like current contract #, which gets updated by 1 each time you add another contract, which then is automatically posted on your EXCEL
DGET(database,field,criteria) Database is the range of cells that makes up the
list or database. A database is a list of related data in which rows of related
information are records, and columns of data are fields. The first row of the
list contains labels for each column. Field indicates which column is used in the
function. Enter the column label enclosed between double quotation marks, such
as "Age" or "Yield," or a number (without quotation marks) that represents the
position of the column within the list: 1 for the first column, 2 for the second
column, and so on. Criteria is the range of cells that contains the
conditions that you specify. You can use any range for the criteria argument, as
long as it includes at least one column label and at least one cell below the
column label in which you specify a condition for the column.
mmm...could be tricky......you could try the argument IF THEN ELSE in the functions list, in conjunction with additional columns to carry out the intermediate calculations, then you can hide those columns. perhaps you could also make use of conditional formatting. any problems come back to me.....could you place a snapshot of the sheet you are designing ? just highlight the cells , copy them, and use edit "paste special", tick values when pasting into this forum.
×