How to sort a table with only formulas?
I have a table (several rows and columns) which I want to sort. All
cells are formulas which references to other cells outside the table I
want to sort. When trying to sort, Excel (both XP and Mac) sorts but a
split second later it goes back to original non-sorted.
Any suggestions? I could put the sheet on a webpage for you to see.
Formulas are sorted based on their value at the time of the sort, but
then are reevaluated as if they were copied from the original cell to
the cell where they end up, which usually means they change.
You can either change all the cell refe...Help with formula #33
I need to change this formula to include 3 more numbers.
I need to also have .0217 and .0204 and .0850 in this formula. Is this
possible? any help at all! Thanks in advance!!!
May be this=85
On Jul 14, 4:54=A0pm, Bob <bobandrich...@comcast.net> wrote:
> I need to change this formula to include 3 more numbers.
> I need to also have .0217 and .0204 and .0850 in this formula. Is this
> possible...Need to duplicate (cut / paste ?) formulas but can't use $ (F4)
I have a massive array of formulas in three columns that I need to
duplicate to the next three columns exactly as-is. I cannot use F4
b/c there are too many formulas to edit individually.
If I cut the original columns, I can paste the contents into the new
three cols, but I can't re-paste them back into the original columns.
This would be ideal, but I don't know how to do it.
Is there another way to exactly replicate the contents?
One other complication is that the target cells do not sequence with
the parent cells (rows = columns & vice versa; they're transposed and
nonse...show items with no data option in pivot tables
Can anyone help with some bizarre results I'm experiencing with the show
items with no values check box in the field settings menu for pivot tables.
It appears to be showing field headers that don't exist in my data????
I'm using Excel 2000.
Debra Dalgleish has some techniques at:
In fact, she has an addin that you may like:
> Can anyone help with some bizarre results I'm experiencing with the show
> items with no values check box in the field setting...A cell displays many ###'s instead of the text data.
Cell is formatted to wrap. Surrounding cells are ok.
How do we display the text?
Expand the column width?
"BelAir" <BelAir@discussions.microsoft.com> wrote in message
: Cell is formatted to wrap. Surrounding cells are ok.
: How do we display the text?
This usually means the column isn't wide enough.
mvpearl omitthisword at verizon period net
"BelAir" <BelAir@discussions.microsoft.com> wrote in message
news:C236A226-F2...Help with setting up a formula
Hi. I need some help setting a formula for the following:
Info on Sheet1
Operation Item A Item B Item C
1.Cut 10 min 12 min 15 min
2.Trim 22 min 19 min 17 min
3. Polish 13 min 14 min 16 min
Info on Sheet2
01/11 02/11 03/11
Item A 9 units 5 units 5 units
Item B 0 units 2 units 3 units
Item C 0 units 2 units 1 unit
Info required on Sheet3
01/11 02/11 03/11
1. Cut (tot min) (tot min) (tot min)
2. Trim (tot min) (tot m...Can I add html to publisher doc for anchored link?
I am creating a simple one page newsletter in publisher to send out via a
mailing list. It has brief synopsis-articles that have hyperlinks to my web
page to the more detailed articles.
I would like to be able to add the html code for an anchored link to the
exact location within/down the page for a given article.
I know the coding, I just don't know how, or if it's possible to add it, or
edit the hyperlink that you insert via the menu.
Thanks for any input! --Jeff
Insert the anchor into the web page using insert > html code fragment.
<A NAME="READHERE"></...How do I make a formula that uses the fist cell as a starting posi
How do I make a formula that uses the fist cell as a starting position and
then counts 4 cells down as the next result?
A1 start cell, then A5, A9, A13, A17 etc.
Have a look in help index for OFFSET
"mrbshansen" <firstname.lastname@example.org> wrote in message
> How do I make a formula that uses the fist cell as a starting position and
> then counts 4 cells down as the next result?
> A1 start cell, then A5, A9, ...newbie needs help with data storage
Hi, i have a problem which i am sure you can help me with.. i have
written a spreadsheet which decides which horses to bet on in a race.
one minute before the race a set of data is imported into the sheet and
one two or more horses are picked. then one minute before the next
race usually ten minutes later a new set of data is imported and the
process begins again deleting all the info from the last race and
replacing it with the new . now what i want to be able to do is store
the name of the horse which appears in say cell a1 or a2 or a3 from the
first race in order to use it to establ...How to use a text formula as code formula
Hello. I have this formula loaded from a text field on a form:
val([field10])+val([field20]) and I would like to use this as a code formula.
I mean, if I use that in VBA code it works, but If I load from a text field
it doesn't work.
I need that my form use that formula stored in a text field to calculate
Regards in advance,
Take a look at the Eval() function.
Microsoft Office/Access MVP
"Marco" <Marco@discussions.microsoft.com> wrote in message
> Hello. I have this for...Traditional Chinese / Simplified Chinese Conversion in Office 200.
I can't do any offline Tradition Chinese / Simplified Chinese Conversion in
Office 2007 English version? Anyone can help?
high quality Soccer jerseys NBA Jersey tracksuit and jackets, GHD
hairstraightener supplier from www.willpa.com
Are you a Retail businessman who bother by the purchase price? China
Cheapest TOP wholesale website can help you
we are specialize in replica sport goods manufacturing in china, we can
offer you all kinds of soccer jersey, NBA jersey,shoes and so on. they are
the best brand replica goods whih are look the same as the original goods.
exce...Access 97 to 2000
I have an Access 97 application - runs in two databases -
forms/reports in one database linked to the other database
containing tables/data. We're updating to 2000. So I plan
to issue a CD-ROM which installs a 2000 version of the
code database and an empty 2000 table database.
Need to convert the 97 data to the 2000 'data' database.
One set of databases lives in C:\ProgramFiles\CSS and the
other will install into C:\ProgramFiles\CSS2000. What's
the best way to get this data over?
Do I ignore the empty 2000 'data' database, and have
everyone manually con...How do you add text to custom columns created thru the Field Chooser pls?
If I create a custom text column via Field Chooser - New, how can I
enter text into it afterwards?
I'm looking to add an "annotation" column and not have it sent if/when
I forward or reply to the message.
Outlook 2003 with Exchange 2003.
If you directly want to fill it out in the message list you'll have to
enable "allow in-cell editing" for your view.
The technique would be similar to;
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
http://ww...Formula help #38
In cell A2 I input a year (2008, 2009 ect) in cell A11 I need a formula
which will return a value which represents the first day of January of the
year displayed in cell A2.
On Thu, 21 Feb 2008 09:10:21 -0800, "Patrick C. Simonds"
>In cell A2 I input a year (2008, 2009 ect) in cell A11 I need a formula
>which will return a value which represents the first day of January of the
>year displayed in cell A2.
Microsoft MVP Excel
SalesAid Sof...If this or that Formula
need help with a formula. Lets said I have three columns
that contain price:
L M N
..02 .026 empty
I want to do if L has price use that price. If is empty,
and N has price, then use N price. If L and N are empty,
then use M price. If L,M,N empty then show EMPTY.
So basically. COlumn L is first, N is second and M is
I'm not too familiar with a comlex If statement.
Hope I make sense, Any help would really be very
> need help w...Formula assistance required
Hi guys, am sure you'll be able to help with this but I just cant figure it
Worksheet looks a little like this;
A P U
14 27/02/10 Y 10.00
15 04/03/10 Y 15.00
16 05/03/10 N 0.00
17 06/03/10 N 0.00
18 07/03/10 Y 12.00
My data is in rows 14 to 1000. Col A is the date the claim has been
submitted, Col P is Yes or No to whether claim has been accepted and Col U is
the Loss value.
I have a summary table set up and am wanting to have a weekl...How do I do formulas?
How do I do formulas?
I want to change numbers to forlumas.
How do I do this?
Can it do done?
If you mean you want the sheet to display the formulas instead of th
reults you can do it by
pressing the Ctrl key & the ' key
Tools Menu > Options > View Tab > Tick Formula
mudraker's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=247
View this thread: http://www.excelforum.com/showthread.php?threadid=27107
Also, make sure your Formula b...Multiple combined formulas ?
I am not sure what combinations of formula’s are needed to lookup an item,
evaluate multiple results and list the result.
Here is a sample scenario:
ID Item Result
1234 Degree 30
1234 Degree 15
1234 Method Hand
456 Style Green
789 Degree 30
1023 Degree 15
1023 Degree 10
1023 Method Foot
I need to be able to lookup the ID number e.g. “1234” in column A, evaluate
all the item responses for 1234 that match, e.g. “Degree” in column B and
then evaluate the results for all the items called “Degree” for ID 1234 and
then if the Result is e.g. 30, record 30 in the cell.
Hope I have explained it...Merging multiple personal data files possible ?
When I viewed a friends outlook data file location list (in Outlook XP/2002 (Not: Outlook Express))
I was rather surprised:
There were up to 10 different *.pst files listed.
We decided to remove some of them resp. to merge them into one (or at most two of them).
I am not sure about the dependencies of these multiple *.pst files.
If there are more than one *.pst file in this list: Does that means that e.g. an eMail "xxxxxx"
is stored in only ONE of them or is a copy if this eMail stored in each of them?
Is there a way of merging all these *.pst files into one of them ?
Autoarchiv...Help needed to understand Vlookup Formula
I've just taken over someones job and I have a problem with a couple of
Excel 2000 spreadsheets. One of the spreadsheets picks up some data from
another one using a vlookup formula. The formula is below but could someone
please tell me what it is actually looking for by breaking down the
=VLOOKUP(V11,'C:\Deliveries\[Buy Del.xls]Buy Delivery
When this spreadsheet is opened and the vaules updated from the other
spreadsheet it is linked to I also get an "out of memory error". Both
spreadsheets are quite small and my PC is P4...using if function to specify range in formula
I am trying to use the median function, but only apply it to certai
values in a range. It is easy to do this with the average functio
using sumif and dividing it by countif, but is there any way to do thi
on other functions
Message posted from http://www.ExcelForum.com
use the following array formula (entered with CTRL+SHIFT+ENTER):
> I am trying to use the median function, but only apply it to certain
> values in a range. It is easy to do this with the average function
> using sumif and divi...By Passing Reports with no data
I have a series of query driven reports that are run from the on click
command of a button on a form. These reports are not opened or printed
but saved in a folder on a network share. Once the reports have been
created an email is send to specific people letting them know that new
reports have been created. Below is the code I am using so far.
This code works fine other than it creates a blank report if there's
no data to be displayed.
I am looking for a way to run the reports but ONLY save reports if
they actually have data.
Private Sub Command38_...combine formulas into 1
In the examples below, is it possible to combine the 2 formulas into one?
I need to simplify my spreadsheet if possible.
Thanks very much for any help.
As they have different tests/outputs, how do you want them combined? Also,
there are two IF functions, but only one set of outputs. Perhaps these are
an AND condition? A simple way (with a lot of assumptions made):
=IF(AND(M3>=H1,MAX(H3,H7,H11,H15,H19,H23)>=MAX(H5,H9,H...Calculate a field in Access, using a formula from a text string
Does anyone know of a way to calculate a field in an Access query using
different formulas entered in a database table, as a text string? I have
gotten around this before by splitting up these equations into their
different variables and storing the values into a table. However, that only
works if the equation format stays the same. I no longer have formulas that
closely resemble each other in format and differ only in values.
Could you provide an example or two for clarification?
Microsoft Office/Access MVP
"ALF" <ALF@discussions.microso...formulas #18
hi people...doing a finance assignment using an excel model...just struggling
abit with some of the formulas - any input is appreciated: