|
|
|
April 14th, 2010 02:40 PM
by UKMAN
|
0 |
196 |
|
|
|
|
3 |
220 |
|
|
|
April 14th, 2010 01:18 PM
by Eduardo
|
2 |
232 |
|
|
Vlookup and if formula by
edwin
EUR GBP USD
Jan-09 1.1205 1.0000 1.4500
Feb-09 1.1261 1.0000 1.4573
Mar-09 1.1317 1.0000 1.4645
Apr-09 1.1374 1.0000 1.4719...
|
|
2 |
165 |
|
|
|
|
7 |
193 |
|
|
|
|
1 |
146 |
|
|
SumIf by
Debi
I am creating a holiday card for staff in the office and wanted to know if
there is a sumif function for adding up the number of times a specific letter...
|
April 14th, 2010 10:25 AM
by Mike H
|
3 |
159 |
|
|
Vlookup & relative cell reference? by
Cecilia
Hello--
I have a formula entered as follows:
'=VLOOKUP(A8,Sheet1!$B$22:$O$22,2,FALSE)
My Sheet 1 - match column is this:
Row Column B
22 ...
|
|
2 |
161 |
|
|
|
|
1 |
244 |
|
|
Countif for finding a Time input by
Meebers[_4_]
Got a big long column D containing times formatted as i.e. 13:30. I am
trying to do a countif function for finding the count of inputs between 6 am
and...
|
|
4 |
164 |
|
|
SUMIF Function by
Traci P.[_2_]
I would like to use a SUMIF formula to add multiple columns. For instance, I
have a list of materials in a range from A6:A2403 and sales dollars for each...
|
|
2 |
158 |
|
|
Assigning a number value to text by
SoupNazi
Does anyone know how to get Excel to recognize a word as a numeric value? I
have gone into InsertNameDefine and assigned a numeric value to the word.
Lets...
|
|
5 |
144 |
|
|
Days in Text to Dates SPECIAL by
DOUG
Through great effort, I have sorted and averaged the patient demand for
appointments over the last three years. For instance, now I know how many
patients...
|
|
1 |
156 |
|
|
|
|
1 |
156 |
|
|
Find and Replace by
Pierre
Good day all,
I am trying to change this number 01-465-9273 to show up as 014659273. It is
easy enough to make the (-) go away but it takes the zeros at the...
|
|
4 |
131 |
|
|
Help Creating Excel Formula by
jamesvh
Hello All,
I'm having a hard time creating a formula to collect data for work. Here is
what I'm looking to do:
To explain I will use cells A1, A2, A3 & A4....
|
April 13th, 2010 09:12 PM
by jamesvh
|
4 |
164 |
|
|
changing formula by
Excel formula
I have the formula bellow, which is getting a number from a worksheet within
the permanent file to be added to the monthly...
|
|
0 |
163 |
|
|
|
|
11 |
350 |
|
|
|
|
3 |
228 |
|
|
Counting with 2 criteria by
Amethyst
I need to be able to pull counts from a frequently updated list based on
associate's name and status of order.
--
Amethyst
|
|
3 |
110 |