|
Cross-referencing content of one worksheet with another
Hi All
I have a little puzzle.
I have a workbook with two worksheets.
In Sheet 1 , column D contains a number to 2 decimal places , and column
E contains a reference number.
In Sheet 2 , column A contains equally a number to 2 decimal places ,
and column B contains a Reference Number.
I need a formula or a macro which will check the Reference Numbers in
sheet 1 with sheet ...
|
6 |
1/1/2009 12:37:17 AM |
|
|
creating formula to return one of several values
Have column with dollar values that correspond to fractions representing
thickness of materials (ie cell shows $7.00 - which is the cost of 1/4"
material)
I want to create another column which will parse the cell with the dollar
value and enter the corresponding fractional value for material thickness
based on the 6 different cost values that could be in the cell and the
related fractio...
|
1 |
1/1/2009 12:31:00 AM |
|
|
Find Cells that add up to Specific Sum
I have a list of about 30 numbers in individuals cells in a column that added
up to over 200,000. I need to find the numbers within the 30 numbers that
add up specifically to 109,484.60. What formula can I use?
--
BeachLover...
|
4 |
1/1/2009 12:30:03 AM |
|
|
Data Form
How would I create a data form which opens/appears upon opening of spreadsheet?
--
Jeff...
|
4 |
1/1/2009 12:10:02 AM |
|
|
Round to a particular tolerance
Hi All,
Is there a way to round to an even numbers, or odd. It doesn't really
matter. Basically this is what I need:
120=120
121=120
121.999=120
122=122
123=122
124=124
125=124
126=126
127=126
128=128
129=128
130=130
or maybe even change it later to
120 to 122.999 = 120
123 to 125.999 = 123
etc...
the one catch is, it must round down to that number. When I looked at ...
|
3 |
1/1/2009 12:04:01 AM |
|
|
Ranking numbers that are a variance of 100%
How can i rank numbers that are a variance of 100% when being over or under
100% has the same score?
Example
-3.09%
6.04%
1.82%
1.46%
-4.14%
-0.73%
0.96%
4.60%
I want to rank the above numbers which are all a variance from 100% but the
closest to 100% are the top ranked numbers. -.73 would be number 1 and 6.04%
would be number 8. 4.6 would be 7th and -4.14 would be 6th. Thanks...
|
4 |
12/31/2008 11:51:01 PM |
|
|
round a formula's result
in a single cell, i need a formula for compounding inflation, and i need to
have that result to be rounded (example, one result from the formula is
$877,394) I want to have that number read $877,400, but within the same cell,
not in a different cell or column. how do i get both formulas in a single
cell? i've got the formulas for interest and for rounding but i can't get
them to work tog...
|
4 |
12/31/2008 11:22:07 PM |
|
|
vlookup
i'm doing a profit and loss account using figures from a transaction data
sheet, the data have a lot of different figures of something i.e. sales. how
do i get excel to lookup a category (sales) from a table of data then then
adding all of the sale figures together to give the total sales. i've tried
vlookup but it only gives one of the figures instead of all of them added
together. i mi...
|
3 |
12/31/2008 11:06:01 PM |
|
|
Complex text extraction formula
I receive monthly volume reports from my distributors with data arranged by
each of their customers. They arrive formatted in Excel 2003 or better that
has been generated from their ERP platform. The problem is they are not
easily sortable because of the layout: The first row for each customer
contains account information as a single text string including #, name,
address, etc in Col. A...
|
5 |
12/31/2008 10:39:52 PM |
|
|
How do I set more than 1 target cell using MS Solver?
I am trying to build a spreadsheet to adjust a certain flow rate to maintain
a specified tank volume. For instance, I want to maintain a tank volume of
234000gal. I have a water demand that varies from 1400-2400gal/min (gpm),
with an average of 1600gpm. The supply flow rate can range from
1200-1800gpm. I want to be able to adjust the supply flow rate to maintain
the tank volume. The...
|
3 |
12/31/2008 10:35:33 PM |
|
|
Extract last part of email address and add "www." before the @ sig
I have searched, tested and walked away. I cannot figure how to:
Cell A1 = anyone@aol.com
In cell A2 I'd like to extract "aol.com" and add "www." so the result =
www.aol.com
I've tried
=MID(A1,FIND("@",SUBSTITUTE(A1,"@","www.",LEN(A1)-LEN(SUBSTITUTE(A1,"@","www."))))+1,LEN(A1))) and I know I'm doing it wrong.
Thanks for helping!
--
Thank you,
scrowley(AT)littleonline.com...
|
5 |
12/31/2008 10:20:26 PM |
|
|
retain value and delete format
Hello:
I would like to know how to retain the value thats in a cell but delete the
formatting of the cell. Below is a column of numbers that represent response
times (in seconds). I've used special paste to retain the values and reformat
the values to number or general (under formatting), but to no avail. I want
to see what response times exceed our 8min 59sec (or 539 seconds). To do this...
|
7 |
12/31/2008 10:05:06 PM |
|
|
VLOOKUP Converted to VB
After days of running into Excel limitations I have resorted to trying to do
this in VB (definitely not my strength). I have too many nested conditionals
for Excel to handle so I wanted to create a function in VB. I need to
convert VLOOKUP(D50,INDIRECT(D50&"_Contract"),2,FALSE) to the VB equivalent.
DLookup looks to be the best I could find, but one clear problem I forsee is
DLookup i...
|
2 |
12/31/2008 9:41:01 PM |
|
|
Macro to select cells without a certain value and select a menu it
I need a way to auto select all cells within a particular range that do not
have a certain value, (Bye), and if possible to also select a custom menu
function. The menu function is a 'random sort' feature that I have on my menu
bar and I wish to select a certain feature under the dropdown menu (random
sort selected cells) with this macro. I would like to have a macro to do both
with one ...
|
4 |
12/31/2008 8:18:54 PM |
|
|
Run macro Once
Can anyone let me know how to get this code to work when there is a null
entry in X1...
Worksheets("qry_aga_corps").Activate
Range("X1").Select
If ActiveCell isnull Then
"Run Code"
Else
MsgBox ("The Macro has already been activiated once, cannot run
twice")
End If
Regards - Paul
...
|
5 |
12/31/2008 7:59:07 PM |
|
|
Active sheet instead of a "sheet1" for Macro
I have this code in a macro:
If Sheets("Sheet1").[A1] = True Then
ActiveWindow.SmallScroll Down:=-9
Application.Goto Reference:="R17C3"
Range("C11:C17").Select
Range("C17").Activate
Selection.Copy
My questions is how do I make this macro work in any worksheet not
only only in sheet1, what do i have to change from "Sheet1" to make it
work.
thank you,
Pamela...
|
8 |
12/31/2008 7:47:40 PM |
|
|
Content of cell in Vlookup function
Hi
I have 52 files named "Losses " plus 2 digit week no 01 to 52 plus ".xls"
I have a summary sheet with week numbers in row 2 E to AZ and branch
locations in column C. I want to summarise the losses for each branch for
each week no. I have used a VLOOKUP function which I can manually replicate
for each of the 52 weeks, but it would be nice to pickup the week number
from row 2 and ad...
|
4 |
12/31/2008 7:16:49 PM |
|
|
(WWW.IOFFERKICKS.COM)nike shoes:$32,handbag:$35,NFL:$20,jeans:$30,UGG boot:$50
Get Nike Shoes at Super Cheap Prices
Discount Nike air jordans (www.iofferkicks.com)
Discount Nike Air Max 90 Sneakers (www.iofferkicks.com)
Discount Nike Air Max 91 Supplier (www.iofferkicks.com)
Discount Nike Air Max 95 Shoes Supplier (www.iofferkicks.com)
Discount Nike Air Max 97 Trainers (www.iofferkicks.com)
Discount Nike Air Max 2003 Wholesale (www.iofferkicks.com)
Discount Nike...
|
1 |
12/31/2008 7:11:15 PM |
|
|
Formula help
I am hoping that you can help me with a formula
I want to look up data in one column and search for a specific value and
then return a value from the same row, several columns before.
I want to search for the number 1 in G7:G23
If 1 shows up in G18, I want to have the contents of A18 appear in the new
cell
Any suggestions?...
|
14 |
12/31/2008 7:08:15 PM |
|
|
Rounding time values up and down
Sorry if this has been asked before but i have time values in cells
formatted h.hh
I need to round the values to the nearest hour for example a time of
13:15 needs to be rounded to 13 and a time of 08:45 would be rounded
to 09
Hope this makes sense
Martin...
|
4 |
12/31/2008 7:02:01 PM |
|
|
Total cells when range is unknown
Thank you to any who dare... this may not be possible but I appreciate your
comments.
I have an extracted range and need to add a total to the next row after its
last extracted record each time it runs.
Some times I get 2 records, sometimes 70, but in each case I need the next
row after the last record to contain a sum of all values in a given column,
but only in the extracted data (a...
|
5 |
12/31/2008 6:41:04 PM |
|
|
matching data to dates - please help
Hi all,
I'm having trouble finding the best way of acheiving this, hoping someone
can advise.
In column A I have a date range of 1/2/07 to present
In column B I have data corresponding to column A
In column D I have dates on odd days between 1/2/07 to present
In column E I have data corresponding to column D.
I want to have the data in column E in column C where the date in column A ...
|
6 |
12/31/2008 6:41:03 PM |
|
|
Formulas
I need a formula that will do the following function.
If the number is E2 is 0 then put "MT" if the number is NOT 0 then do
SUM(56-E2)*113.63....
|
11 |
12/31/2008 6:33:06 PM |
|
|
Do not prompt to update links--Excel 2000
I would like to have the ability to update links manually, as well, without a
prompt at startup.
In the <edit> <links..> menu, there is an option to update manual, however,
it is greyed.
I am unsure how to allow....
|
4 |
12/31/2008 6:20:01 PM |
|
|
www.iofferkicks.com china cheap wholesale nike shoes,air jordan shoes,air force one shoes.
Get Nike Shoes at Super Cheap Prices
Discount Nike air jordans (www.iofferkicks.com)
Discount Nike Air Max 90 Sneakers (www.iofferkicks.com)
Discount Nike Air Max 91 Supplier (www.iofferkicks.com)
Discount Nike Air Max 95 Shoes Supplier (www.iofferkicks.com)
Discount Nike Air Max 97 Trainers (www.iofferkicks.com)
Discount Nike Air Max 2003 Wholesale (www.iofferkicks.com)
Discount Nike...
|
1 |
12/31/2008 6:10:36 PM |