Minimum value look up
Mon, 6 Oct 2008 15:23:49 -0700 (PDT)
I have a giant list of PNs I've complied from several different quotes
from the vendor for 26 FGs. I need a formula to return the minimum
value from the list for a look up against specific PNs.
So in the formula cell I need to sort of vlookup the value I'm
interseted in from the list, but return the lowest ...
|
How to return the last non-blank cell in a column that is TEXT
Mon, 6 Oct 2008 15:14:11 -0700
In any cell of column C of Sheet 2, I want it to return the last non-blank
cell from Sheet 1 Column D...being the last non-blank cell in or ABOVE that
row. Column D in sheet 1 has TEXT and no numbers. My range I'm working from
on sheet 1 is D7:D7000. ...
|
"If" formula
Mon, 6 Oct 2008 15:04:52 -0700
I'm trying to set up a spreadsheet to help me with my job. I track/audit
accounts for a man that does private lending. Here is what I'm trying to do:
I need a formula for "if the date in column A is 26th of each month or
later, I need column E to be a late fee of $86.72"
I really seem to have problems wh ...
|
optional calculations
Mon, 6 Oct 2008 14:47:56 -0700
how do I create an option within a cell to display a different set of values
in a range ? EG MPH/ KPH.
I saw this in a spreadsheet today but could find no formatting etc to reveal
how it was achieved.
It was in the style of an option box,,, click here (spot in a circle) for
set of values 1,,, click here (s ...
|
Nested IF compatability error with Excel 2007
Mon, 6 Oct 2008 14:36:32 -0700
I am using Excel 2007, co-workers still on Excel 2003. When I work on
something, I save to 97-2003 .xls to be able to share files. I only use
Excel 2007 file save when I am downloading data from a database that needs to
use more rows..anyway...I had a file someone shared with me (created in Excel
2003) and ...
|
2 VB Questions
Mon, 6 Oct 2008 14:08:21 -0700
1) If I'm writing a worksheet_change for sheet1, how do i get it to reference
sheet2? That is, I want Sum(Sheet2!A2:A10)?
2) If I have A1=Sum(Range("A2:A10")) written into VB, how do I make it
update automatically when I change the value in, say, A3?
Thanks.
JRD-CFW ...
|
Vlookup With Multiple Instances in Data Table
Mon, 6 Oct 2008 13:52:52 -0700 (PDT)
Hello all,
First I have to say that I've not posted a question in over 5 years
due to the fantastic results I've had searching for solutions in this
group.
I'm developing a Pivot Table to calculate PO balances. The problem
I've having is that a PO number resides in every row in the database.
I'm looking f ...
|
|
|
I'm trying to add columns and getting errors
Mon, 6 Oct 2008 13:42:10 -0700
I am working on a very large spreadsheet, grouping columns. I am trying to
add additional columns and keep getting the error " Cannot Shift Objects off
sheet".
I don't want to delete any of the columns, but how do I get past this error
and what does it mean? ...
|
Variable file reference
Mon, 6 Oct 2008 13:41:26 -0700
I am trying to use a date field in a column header to point to a file name to
pull data from and cannot get the formula to execute. Example:
B2 =10/2/08 B3=10/3/08 B4=10/4/08 ... etc....
formula in B3 = "=CONCATENATE("='Report
",MONTH(GL$3)&"-"&DAY(GL$3)&"-"&YEAR(GL$3),".xls'!Data"
where the report is ...
|
Conditional Sum
Mon, 6 Oct 2008 13:25:15 -0700
Hello,
Can someone please help with this formula.
I have a worksheet called Template and another called Tenure 9.14.08 and the
tab on that spreadsheet is called "Previous Week."
On my Template spreadsheet I am trying to set up a formula that will look in
Column A for an X in the Tenure 9.14.08 spreadshe ...
|
