|
|
Having trouble with vlookup and match by
ADiscrete1
If column a has a limited # of phone numbers in 1 sheet and in the 2nd sheet
I have those numbers embedded with many others as well as additional
information...
|
|
8 |
113 |
|
|
Specifiying the worksheet name in a cell by
adiss
I have several different xls with multiple worksheets in each I have
written the report that generates the data but I must manually go into
each field and...
|
April 28th, 2006 12:26 PM
by adiss
|
2 |
78 |
|
|
SUMPRODUCT by
Aditya
Hello.
I am trying to calculate minutes from a conference
database record within a given period.
This is what my sheet looks like.
Date Time Country...
|
September 24th, 2004 04:15 AM
by Biff
|
1 |
82 |
|
|
keyboard shortcut by
Aditya
We know the keyboard shortcut for selecting the total column (CTRL+spacebar).
once when i was using this, some how it got removed. Can any one of you
helpme...
|
|
1 |
274 |
|
|
Applying formula on formula by
Aditya Kumar
I have used IF formula on 10 grid values to get desried values.Further, on
these values i want to apply average formula.
Whenever i apply the average onto...
|
October 31st, 2007 04:26 PM
by ilia
|
6 |
56 |
|
|
|
|
1 |
111 |
|
|
SUM OF GROUPS by
ADK
I have two columns.
Column C is labeled: Group
Column D is Labeled: Weight
I have 27 rows with data. I would like to tally the group weights
example: 5 of...
|
October 28th, 2005 08:04 PM
by ADK
|
5 |
93 |
|
|
back date calculation? by
[email protected]
I would like to find out what each entry date would be if I had a
global start date, each entry had a day count and the result would be a
backwards calendar...
|
January 15th, 2006 06:10 PM
by Paul B
|
1 |
86 |
|
|
IF, between two numbers by
ADK[_2_]
How would I use and if statement based on between two numbers??
Example---
For cell A6: IF A5 is between .99 and 5, 1, 0
A5 = .25 ....so A6 is 0
A5 = 1...
|
|
2 |
49 |
|
|
Closest value lookup? by
ADK[_2_]
I have a sheet with specific numbers. On another sheet, the user would input
a value. I like excel to find that number or the closest number then return
the...
( 1 2)
|
|
12 |
179 |
|
|
formula range by
ADK[_2_]
is there any way to make A2 in the formula a function of a cell value?
=VLOOKUP($B$1,A2:D1969,3,FALSE)
Example: if F1 = the value of: "A50"
So the formula...
|
|
5 |
58 |
|
|
which function can get the desired result? by
ADK[_2_]
Is there a function for this:
example:
cell B1 = 115
cell B2 = 120
cell B3 = 200
B1 thru B3 are variables that will change based on user input.
I want cell...
|
|
3 |
76 |
|
|
random by
ADK[_2_]
I have cells A1 through A10 with player names (John, Joan, Tom, etc.)
I would like to generate 5 teams by random. How can I do this with excel?
....without...
|
|
1 |
59 |
|
|
create a master list from other sheets by
ADK[_2_]
I have 12 sheets that consist of bill of materials. I would like to have a
master sheet which combines all the sheets into one bill of material.
Problem:...
|
|
0 |
134 |
|
|
if between two dates by
ADK[_2_]
B1= 1/1/2007
B2 = 10/3/2007
A3 = 1/12/2007
B3 = X
(X being the letter X ...so "X" in formula)
B3 exquals X if A3 is between or on B1 & B3 otherwise cell...
|
|
5 |
84 |
|
|
end date by
ADK[_2_]
If I input a start date in a cell, and give the number of days required to
complete the task in another cell.......How can I compute the end date
omitting...
|
|
3 |
76 |
|
|
|
May 25th, 2007 08:05 PM
by Adlin
|
3 |
61 |
|
|
Formula with natural English language by
adman4
I've been having the hardest time figuring this out. Maybe someone here could
help?
A column in my table has a series of city names. I have another table on...
|
January 22nd, 2009 04:16 AM
by adman4
|
3 |
64 |
|
|
|
May 23rd, 2006 02:46 PM
by ADMIN
|
0 |
63 |
|
|
Excel changes my text by
admin
Help! When I type "HSA" into a cell, which is formatted as text, Excel
changes it to "HAS" and I can't figure out how to change this. Thanks!
--
Admin
|
|
3 |
95 |