"If in last week" formula
I have a number of simple two column sheets, one column contains dates.
Basically each sheet is an employee, and the items list the date and
notes for any "one on one meetings" that I have with that employee. I
want to have a summary sheet that lets me know when the most recent
I think it would be ideal to check sheet1-5, if date is older than 1
week, output false or true.
I can't find any formula example on the net that uses dates as a
condition of true or false. Can anyone point me in the right direction?
work for what ...See if cell is in Range
Thanks for taking the time to read my question.
I'm passing a string that is a cell reference to a function. In that
function I want to determine if that cell reference is within a predetermined
range. Not sure how to do that. Right now I have:
Function CheckRange(TheSheet As String, TheCell As Range) As Boolean
If TheSheet = "Sheet1" Then
if TheCell In Range("B4:B30") then 'This line is red as it is incorrect
CheckRange = True
What do I use instead of "In"?
Use something like:
If In...Editing in a cell
I am having a problem with a newly created workbook.
When I go to a cell that has data in it and try to add more data to the
existing string I lose all the previous information. The work sheet that I am
working in is protected and I have "edit directly in cell" checked in the
options section. It is almost like my double click (as well as F2) are being
treated as a single click.
I figured it out. For some reason "Hide" is selected for the unlocked cells.
"John English" wrote:
> I am having a problem with a newly created workbook.
> Wh...Money signs appear in my Cell and I don't want them there
Im trying to enter the numbers 2.9 in cell like AD and it turns it into
$2.90. That is not what I need, how do I stop that?
Format as General instead of currency
"kate" <firstname.lastname@example.org> wrote in message
> Im trying to enter the numbers 2.9 in cell like AD and it turns it into
> $2.90. That is not what I need, how do I stop that?
...How do I get a cell to remember the last entry and add to it?
I am using Excel 2000. I want my cell to remember the number in it and add
an additional number each time I need to retotal.
Sounds like you want that cell to be an accumlator cell.
Simple question with complex results.
You can have a cumulative total in a cell if you have a
separate source cell for adding a new total to the original.
Use at your own risk. I am Posting this just to show you how it can
be done, not as a good solution. You would be much better off to
have another column so you can keep track of past entries.
Goes like this: =IF(CELL("address")="$C$4&...Liaison Messenger vs. Forms Printer opinions needed
Hey everybody -
Can somebody give me some review of which product they prefer? We need to
send out invoices from GP with excel attachment and both of these products
look like they can do the job. Any suggestions?
I don't have as strong opinion, but i have worked with Liaison
Messenger mostly. It is easy to use and pretty functional and the
support is fabulous. My only issue (or thing that you need to be
aware of) is how it is structured. The machine the runs the server
application has to be logged in (it can be logged in and locked) with
the server app and outlook launched for ...How do I enter the date last modified in the footer of an Excel d.
How do I enter the date last modified in the footer of an Excel document?
I want to be able to distribute a monthly or weekly report in Excel to users
and have it automatically update the date last modified in the footer each
time I update the report.
You need to do that with a Before_Print event macro. If you search the
newsgroups from Google you will find lots of examples.
On Fri, 4 Feb 2005 09:33:04 -0800, "Last modified date in footer" <Last
modified date in email@example.com> wrote:
>How do I enter the date last modified in the footer of an Excel doc...Vlookup only the last 6 characters
I have a spreadsheet starting in cell A4. I want to lookup only the last 6
digits in column A and then lookup the value in column J and return the
appropriate value from column K.
The values in column A are 000322341; 000333456; etc.
The values in column J are 322341; 333456; etc.
Here is my current non working formula...
Any help would be appreciated. Thanks.
The RIGHT function is returning a text value, and I'm guessing that the
values in column J are true numbers. So you'd need to covert the text back
to numbers in order to...looking for range of text in a single cell
I just started a new job and my company already had a file with abou
16,000 records in it (called Products). This file contains all of th
parts numbers that they carry. In this file there is one column calle
"description". This cell contains the dimensions, color name and som
other information such as if the piece is flat or rounded. I hav
another file that has about 400 records and this file tells me "colo
name" as well as the "type" of stone that it is (called Stone_Type).
What I am trying to do is add a field to the Products file that wil
say stone type. ...Check Alignment accounts payable
What/How do I customize my check alignment to fit my chech stock? How can I
move around date, Invoice vendor name etc?
You will need to use Great Plains' built-in Report Writer to do this.
If you don't know how to use it, your best bet is to talk to a local Great
Plains partner organization that can teach you how to do it. Alternatively,
you could take an ecourse on Report Writer.
"David Chang" <DavidChang@discussions.microsoft.com> wrote in message
> What/How do I c...Do I need to run eseutil?
Was reviewing 1221 events in application log and spotted a jump in available
space from 500MB to about 3000MB in one night. Recently ran eseutil against
the database. Does this jump in free space mean I may need to run it again?
No, it just means you wasted your time the last time you ran it.
I see no reason to run an offline defrag unless you are out of disk
space and have no other options, are running against the 16GB standard
limit or have moved a "substantial" number of mailboxes and created a
large amount of white space in the database.
On Mon, 18 Oct 2004 15:55:08 -0700, ...To have a 'fixed cell' be equal to the last data entered cell in a column
Good Evening All,
I have a worksheet, example below.
I have frozen the panes to always show rows 1-3.
I wish the cell A3 to be the same as the last 'non-blank' cell in Column
A.(See explanation below).
2 Header Header
So in this case, at present, A3 would be M1001,(A9), but when I enter a new
value in A10, (eg M1008), I would like A3 to automatically update to A10 ie
I think that maybe INDIRECT or OFFSET maybe involved but am fairly
unfamiliar with ...PWA 2007 Database Field for Tasks Updates That Need to be Submitte
Does anyone know what project server database table and field that could be
used in a custom report to tell which task assignment updates that have been
saved but still need to be submitted to the project manager?
...How do I have a cell update itself only if it's currently blank?
I need to track to retain the first value of a date field. Each time
I load the worksheet the date field has the potential to change, I
need to keep track of the initial date in addition to the current date
that is in the field.
I have date columns called ASSIGNED and 1st ASSIGNED. The initial
value of both will be blank. At some point the ASSIGNED will be
populated with a date. When it is populated for the first time I want
to save this value in the 1st ASSIGNED column.
I need something like:
IF ( ISBLANK(ASSIGNED), "", ASSIGNED )
in my 1st Assigned cell, however, I do not ...Help
I need a formula that does this:
OK I'm going to draw a spreadsheet
so all I want is a formula that looks in Column B and if there is ANY
text at all, returns the value in Column A
So I want it to look into B1 and it will see text there and return
"100", but if it looks in B2 and sees that it is blank, it just won't
Can I do this? Seems like it would be a combination of IF and LOOKUP
----------------------------------...Changing Font Colour if cell is certain word?
Can I make the font of a certain cell change it's font colour to Red if
the word in the cell is, example, "Fail"? I want the change to apply
wuming79's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36037
View this thread: http://www.excelforum.com/showthread.php?threadid=560169
Use "Conditional Formatting". It's on the Format menu
Software Tester & Musicia
-----------------------------------------------------...Can I link *.jpg files to Excel cells?
I would like to connect pictures to cells on a spreadsheet. Ideally, I'd
like to connect more than one to a cell. Or to its row. That would work OK
Can I do it?
You can hyperlink a cell to an image stored elsewhere or to an image stored
within the workbook.
How you do it depends upon the purpose of the linking and the ultimate results
you are looking for.
Gord Dibben MS Excel MVP
On Fri, 25 Jun 2010 17:26:13 -0400, "LAS" <FakeMail@Hotmail.com> wrote:
>I would like to connect pictures to cells on a spreadsheet. Ideally, I'd
>lik...Macro-unknown num of lines
I am currently trying to write my first macro! I have written the macr
and it does what its meant to. However, every day the file the macr
works on is of different length and when i look into the VB part of th
macro in the code its only performing the action to 250 lines. Is ther
any way to set the macro to check how many lines are in the file fo
that day and then to run on that many lines? If that makes any sens
i'd be grateful for any help!
Message posted from http://www.ExcelForum.com
Something like this ?
Dim L As Long
L = Sheets(1)...I Need Script create account email
Hello partners and happy year, to have if you can throw a help. Am I looking
for a script automatically to create mail bills in Outlook 2003, that is to
say, to pass him/her a script to a commercial one that requests him/her user
/ password - POP Servant / SMTP and does the bill believe, is it possible to
locate him in some place?. There is looking for for Google and I don't see
...Adding random cells togethr
I want to be able to add
y2,aa2,ac2,ae2,ag2,a12,ak2,am2,ao2,aq2,as2,au2,av2,ax2,az2 together and
return the result in bb2
I am using =sum(y2,aa2,ac2,ae2,ag2,a12,ak2,am2,ao2,aq2,as2,au2,av2,ax2,az2)
however I only see the actual formula returned in the cell not the result. I
have been able to do this in the past. Can anyone help with this problem?
Perhaps BB2 was formatted as text before you entered the formula. Select it
and hit F2 and Enter.
"Kaylean" <Kaylean@discussions.microsoft.com> wrote in message
news:0DF3C2DC-8918-...Cross Tab Line Numbers
I have two fields, Emp_ID and Proj. Each employee could have as many as 10
projects at any given time. What I want to do is build a CrossTab Query that
has the emp_id as column headers and under each name the list of projects
assigned to them. So what I was trying to do is to create a linenumber of
some sort between 1 and 10 to go with each record so that when I pull the
Query into the Cross tab query I could use the number as row headers. Pleae
Example of what I want limit to 5 to save space (not 10):
no. Emp1 Emp2 Emp3 .....
1 proj1 proj2 proj8
2 proj3 proj5...cell ranges in formulas
When referencing a cell range in a formula, is there a way
to represent the cell range by referencing another cell.
What I want to do is this, for example:
say cells a1 thru a100 contain a number of values.
I want to sum a certain subset of these today, but
tomorrow I want to change that subset, so I'd like to
enter the starting and ending point for my sum range into
another cell, say b1 & b2
So if I enter the text "a6" in cell b1, and "a25" in cell
b2, my sum formula should look like =sum(a6:a25). This
give me the flexibility to change my sumrange very e...Rename a sheet tab when cell contents change
I would like to rename a sheet tab when a specific cell's contents
change...is this possible to code? I am using Excel 2003 (but need some
"Michelle" <miki@spam_me.net> wrote in message
> Hi all,
> I would like to rename a sheet tab when a specific cell's contents
> change...is this possible to code? I am using Excel 2003 (but need some
> backward compatibilty...)
>...Diagonal Cells format
How do I format the Label Row of a spreadsheet to be 45 diagonally instead of
the standard horizontal format?
select the cells, choose format / cells - go to the alignment tab and play
with the little dial on the right hand side of the dialog box (or type
numbers in the box underneath).
"Ross" <Ross@discussions.microsoft.com> wrote in message
> How do I format the Label Row of a spreadsheet to be 45 diagonally instead
> the standard horizontal format?
&g...CRM 1.2 to CRM 3.0 Upgrade Active Directory Issues
It was decided to reinstall CRM 3.0 after a successful upgrade from Version
1.2 (Except reporting services).
As part of the install a mistake was made and therequired groups for CRM 3.0
upgrade from 1.2 were deleted (PrivUserGroup, SQLAccessGroup, UserGroup,
ReportingGroup). We manually recreated them.
Now in trying to reinstall CRM 3.0 on an already upgraded and exsitng MSCMR
Database, we keep getting stopped at the Verification Tasks under the section
of "Microsoft CRM User Input" with a error that "One or more of the Microsoft
CRM Groups do not exist".