|
|
|
|
1 |
967 |
|
|
HLookup? by
wagz
I have a sheet that is comparing vendor's pricing. I am using the MIN to
find the cheapest cost, but now I want to find out which vendor it is based
on the...
|
|
2 |
965 |
|
|
State Machine in Excel by
Alex Gildenberg
Hi,
I need to implement state machine in Excel as follows:
There are 6 valid states: S1,S2,S3 and B1,B2,B3
Valid moves between...
|
|
1 |
964 |
|
|
Multiple Conditions and Multiple Solutions by
Frank Kabel
Hi Richard
try
=IF(A1="O",B1*C1,IF(A1="F",D1,IF(A1="D",B1+C1,"no solution")))
HTH
Frank
Richard wrote:
I am trying to work out a formula for multiple...
|
|
0 |
962 |
|
|
Formula to pull the lowest supplier name by
Cassius
I need assistance creating a formula to extract the supplier name associated
with the lowest supplier bid. A sample of the data looks like this. I need
to...
|
|
3 |
961 |
|
|
|
March 21st, 2004 10:32 PM
by Michael
|
2 |
961 |
|
|
California Overtime Calculation by
Joe D.
Hello,
I'm looking for a formula that will calculate overtime. But here's the
problem... We do business in California and are required to pay overtime...
|
|
3 |
960 |
|
|
Import old dos sequencial data by
Rich Stone
I have an old database that stored it's data in a sequencial format with
fixed lengths for each field. As Windows 7 64-bit no longer allows the
running of...
|
|
3 |
960 |
|
|
Sheet Names by
Joseph M. Yonek
I would like to write a formula that will put the name of the sheet on that
page.
i.e. the sheet name is "Base Case", I would like to put a function in...
|
|
6 |
960 |
|
|
|
|
1 |
958 |
|
|
Size of file with pivot table by
Nadine
I have a file that was 8MB when I started. I created a pivot table pulling 7
fields from a worksheet. Now the size is 20MB. Any ideas why this one pivot...
|
June 4th, 2010 09:44 PM
by Nadine
|
2 |
956 |
|
|
Count using IF / AND by
RERAA
If cell B3 is between a number range and another cell in same Row =(Z) count.
As cells are populated the count will increase. So the cell must be between
10...
|
|
2 |
956 |
|
|
|
|
2 |
955 |
|
|
Pivot Excel 2007 by
Dinesh
Hi,
Somehow my Pivot table is not summing up rows at the end when I have more
than two data field in excel 2007. It does sums up by columns. Does any one...
|
May 28th, 2010 05:02 PM
by Dinesh
|
2 |
953 |
|
|
Non-adjacent cell range in formula by
Kat
I am using the formula COUNTIF but this would apply to
any formula requiring range input.
Must the range be for adjacent cells?
I am trying to define the range...
|
June 18th, 2004 04:57 PM
by
|
4 |
952 |
|
|
Add to formula by
Pat
I want to add to the following formula a condition if PO04!$T$24:$T$1500
contains the letter "E" a value will be returned, if not leave cell...
( 1 2)
|
September 24th, 2004 03:38 PM
by Dave R.
|
16 |
951 |
|
|
Macro by
Nicole
I have created a macro in a workbook that has multiply
worksheets (tabs). The macro works great on the worksheet
where the macro was created. However, when I...
|
|
4 |
951 |
|
|
|
|
2 |
950 |
|
|
Yes - No Interactive Text Box by
DisMusBeDaPlaz[_2_]
Working in Excel, I am looking for help using interactive fill-in check
boxes.
I am creating a form.
Setting up a cell or a bunch of cells merged, or not...
|
May 31st, 2010 12:41 AM
by Normek
|
1 |
949 |
|
|
Multiple IF's with an OR by
Nadine
Cell DQ contains a formula that pulls in the status of the item.
Here is my existing formula so...
|
|
5 |
949 |