Formula Question... LookUP
I am using the follwing formula to calculate the last entry in a range..
=LOOKUP(1,1/(1-ISBLANK('04&05 Details'!C416:C428)),'04&05 Details'!C416:C428)
Is there a simple way to calculate the last but one ???
Any help greatly appreciated..
rephrase your question. I'm not sure what you mean by this. Are you trying
to calculate its position on the worksheet?
Message posted via http://www.officekb.com
>Is there a simple way to calculate the last but one ???
Does that mean if your formula returns the value in C420
you now want a formula ...isv.config spontaneously rolls back to random date!
If I use deployment manager to publish changes to CR< then it appears
that the isv.config file is replaced with an old version with n
apparently random date.
For example I currently have an isv.config file containing some
changes made on 1/3/05. I then use deployment manager to add some
more, unrelated, changes to CRM. When I now look for my changes in CRM
they are missing and the isv.config file has been replaced with one
dated 25/2/05. The changes made in deployment manager should not alter
anything in isv.config.
At present I backup the isv.config file and then restore just that
after...long datatype to date string
In my cell I have a long datatype value, like 1046101500. Now I want to have
this converted to a
date string like 'dd/m'/yyyy hh:mm:ss', so my example would be converted to
Is this possible?
How does your data type correspond to the date? Where is the year? Month?
"Candy" <andy_hilvenNOSPAMPLEASE@hotmail.com> wrote in message
> In my cell I have a long datatype value, like 1046101500. Now I want to
> this converted to...how to disable "auto repair" function in Excel XP?
I just bought a new PC with OEM Office XP standard version, before that I'm
using my old PC with Office 97 standard version. I copied all of excel file
to my new PC. Now, when I open any Excel (with MACRO), it said my Excel with
something error and automatically repaired, I worry it will make any change
of the excel files, it that possible to disable the "Auto Repair" function to
let it stop to repair my files, thanks very much.
I tried to send those files to another PC and tried to open via Excel 97,
but it's still no any error.
...Auto fill Column based on data in other columns
I have a report I'm downloading into Excel each day. Columns A, B, and C
have the same number of rows populated. Columns D and E don't. I want to
populate columns D and E with code the same number of rows Columns A, B and C
are. I want to auto fill Column D with the text "ABCD" and Column E would be
the current date in 06/05/06 format. I would like to put this code into an
existing Macro. Any help you can give me is appreciated.
Double click on the fill-handle
If you want to simulate with a macro
Filldown as..."Auto complete" function
Help me please!!!
How can I turn off the "auto complete" function in Excel?
Tell me the steps I have to do?
lexx's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1549
View this thread: http://www.excelforum.com/showthread.php?threadid=27074
Tools - Options - Edit, There is a box at the bottom for Auto Complete
unclick that, ????
scottymelloty's Profile: http://www.excelfo...Date Formatting #2
Is there a way to propogate the current date into a cell
with just one key stroke?
Quick attempt, though I am sure you will get more detailed responses in due
Assign a short cut key for a macro using the =Today() function, and format
NB. will apply to active cell.
"Parry" <firstname.lastname@example.org> wrote in message
> Is there a way to propogate the current date into a cell
> with just one key stroke?
CTRL+; will insert the current date. CTLR+SHIFT+: will insert the
current time. These ...Filling an Autonumber 1-whatever down on a Sheet Programmatically
I have a Microsoft Query that retieves data from an Access Query an
puts it into an Excel Worksheet named AllData starting at cell B2.
have a sub named FormatDates that formats various column
appropriately. What I need to do is add to this sub a procedur
starting at cell a2 going down to the last row of data and filling
number starting with 1 to howver many numbers of rows there are to thi
Just like edit Fiil down when you have the number 1 and 2 highlighte
and you fill down the range to the last row of data.
Thanks Here is my sub below
I have set up my line chart in 2007 with dynamic paramaters (names) and since
then the date catagory is controlled by horizontal(values). The axis values
are numbers even though the labels appear as dates. I have to use the
microsoft numbers to determine the axis start and end limits. What happened?
Perhaps I can better explain my problem. When I select the x-axis to
reformat instructions are that I should be able to change axis type. That
assumes I have horizontal (catagories) listed. I have horizontal(values) and
there is no type to change.
"Gene" ...Frequency of date
I have a list of dates over a two year period (in this example it is over
2006-07; although it will vary given different data sets). I would like to
create a table show the frequency of dates in each month.
Jan -06 5
Feb -06 1
Is there an easy way to do this count.
By far the easiest way is a pivot table. If you're new to Pivot Tables,
"PAL" <PAL@discussions.microsoft.com> wrote in message
>I have a ...How do you insert a date time stamp into a CString?
I need to know, how would you properly insert the current
date time as ( mmddyyyy_hhmm ) into a CString? Thanks in
Use CTime::Format ("%m%d%Y_%H%M"), it returns the formatted date/time
as a CString object.
CTime oTime (2003, 7, 11, 15, 38, 0);
CString strDateTime = oTime.Format ("%m%d%Y_%H%M");
"Jaime Rios" <email@example.com> wrote in message news:<firstname.lastname@example.org>...
> I need to know, how would you properly insert the current
> date time as ( mmddyyyy_hhmm ) into a CStr...Which Date does the system use for Date filter in Acvitities view?
CRM 3.0 Activity window in web client offers Date as a built in filter
criteria. Which date does it use? It does not appear to use Due Date as the
filter. The built in filter of Today vs Overdue does not bring up different
How does this thing work?
I ran into the same problem and found a hot fix that resolved the issue. You
will need to contact Microsoft to have them send you the hot fix.
"Winnie" <Winnie@discussions.microsoft.com> wrote in message
CRM 3.0...Finding Min In Calculated Pivot Table Formula
I didn't have much luck on another list, so I thought I'd try this one.
Any thoughts on the below would be appreciated.
I have a pivot table with a calculated field for which the equation is
[Sum of Dollars / Count of Instances]. So in turn I'm rendering the
average cost for a list of items in a group. The table is set up such
that each column contains a week number and the rows contain a list of
items within a grouping. For example, I might be listing average cost
of apples, oranges, and peaches for each week under a grouping called
fruit. The next grouping is bread, where I...Compare sheet utility that can compare formula too
I am using MS Excel 2003 runs in vista.
I need a utility program that can compare two worksheet, not only just the
value but the formula as well.
File 1: cell a = 5, b = 5, c = 5 , d = a + b = 10
File 2: cell a = 5, b = 5, c = 5 , d = a + c = 10 (note that d having same
value as file 1 but formula is different)
Will it be more reliable to use microsoft office product rather than 3rd
party program? Any free MS product available for download?
It is easy enough to do it quickly by hand.
Copy the workbooks to preserve the originals, th...Which formula do I need?
Would appreciate any help you can send my way:
I have a sales spreadsheet showing sales per month for last year versus
the current year. The data is input for all of last year and the data
for the current year would be available through the current month.
There are totals at the end of each row and I'd like the total for the
prior year to add through the current month.
First Row: JAN thru DEC sales
Second Row: JAN thru AUG sales
The total column for the first row would only add the sales from JAN -
I tried using SUMIF but don't think I...IF/OR formula
I have this formula in a cell:
I also want to apply this formula to the same cell:
Both formulas work independently, but the first one is for if NUMBERS
are entered in column F and the second formula is for if specific TEXT
is entered in column F. How could I combine these two formulas? I think
I need to have the formula first identify the type of contents in column
F in order for this to work...?
=IF(ISNUMBER(H71),IF(H71>0.99,(K71/RIGHT(F71,3))/H71,"n/a&quo...Sorting search results by date created for multiple file types?
I am trying sort files that were created in a certain folder since
December 5, 2009 until the current date. These files can be of the
following file extensions PDF, ZIP, RAR.
The files should be sorted in descending date created order with the
oldest files on top. This works when one file type is involved.
However, when the "Date Created" column is clicked, with multiple
files in the search results; it does not sort correctly in descending
or ascending order.
How do I make Window XP sort the file search results in descending
"Date Created" order with multiple...Budget dates
Is it possible to customize the dates in the budget, instead of having
calender months? e.g. 010106 to 020606
Microsoft MVP - Money
For UK tips & fixes see
I do not respond to any emails that I have not specifically asked for.
"Boenerge" <Boenerge@discussions.microsoft.com> wrote in message
> Is it possible to customize the dates in the budget, instead of having
> calender months? e.g. 010106 to 020606
...Text cell complains about date
I have a column containing ratios like 3/4, 3/0, 5/2, etc.
I have them all formatted as text.
All of the cells that have a zero as the second number (3/0) get a
little green triangle and a warning that I have entered a "date string
with only 2 digits for the year".
How is "3/0" a date string with 2 digits for the year?
And, why is it complaining about a text field?
More importantly, how do I get Excel to stop being so "helpful" and
leave my damned text data alone -- unexamined?
Remove the warning in Options, Tools>Options>Error Checking in 2003...Pattern Fill for lines with Vista
JoAnn, I hope you are there... I love Publisher (2007, well all of them),
though not so sure about Vista, and this problem also occurs with Word.
Anyway, if I want to print a shape that is filled, then, even with a plain
colour fill, I have to go into Pattern Effects and ensure both the foreground
and background colours are set to the colour that I want inside my printed
shape. Note that the screen display is OK. Annoying... but it works!
I also have to do the same procedure if I want to print a Line... funny
really, because I only want a Line... I don't even want it 'fi...Auto date changing in Excel is maddening
I'm using MS Office Excel 2003 (11.6113.5703) to post data that spans over
or try http://tinyurl.com/6f8zn
We had to jump through all kinds of work-arounds in order to accomplish
this. It was not a straight-forward process, though it should have been.
When I enter the date format, for example, as
Format > Time > 3/14/01 13:30
And then enter 11/17/04 0:30:30, it enters okay, but when I double click on
the cell to edit it, Ex...Formula #68
When ever I type a formula in a cell (For Ex: =sum(A63:A77)), I see the
formula in the cell. I am not able to see the value (result) of the formula.
I am not sure what setting was changed and how it was changed.
Can you please let me know how to revert the settings so that I can see the
resultant value of a formula in the cell?
Thanks and Regards,
1. clear the cell
2. Format > Cells... > Number > General
3. retype the formula (DON'T PASTE IT FROM ELSEWHERE)
Your problem is probably that the format is Text.
"Cha...formula for subform nested into a subform
Hello!!!,,,I need an urgent help in a formula.
I have the tables:
IdShip (keyfield) ----------------> IdShip
DateShipped IdInvoice (keyfield) --------->
I have a form A, which contains a key field &quo...Linking sheets which must update the date first.
I have 50 clients, each with an Accounts Recievable worksheet. Past due is
determined by using the =now and =today functions. This information is then
linked to a Master sheet which displays all 50 clients at one time.
The problem is: When I open the Master sheet, the dates on the 50 'feeder'
sheets do not update the date. Only if those sheets are opened does the date
Is there a command to open and close those 50 sheets or a recalculate
command or perhaps, a macro is needed to open then close the 50 sheets.
I posted the same question abou...Change the name of an auto save
I am trying to write a macro that will save the file to a specific cell
reference. The reference is a specific name that is automatically generated
by another macro function.
Any suggestions on how I could do this?
IS thsi what you want?
sFilename = Format(Worksheets("Sheet1").Range("A1").Value)
ans = MsgBox("Save file as " & sFilename)
If ans = vbOK Then
If this information was helpful, please indicate this by clicking ''Y...