|
|
Function NOW by
PeterW
I would like to have the function “NOW” on more then one place in a worksheet
and be able to choose when each cell is calculated
|
June 15th, 2009 02:54 PM
by PeterW
|
4 |
126 |
|
|
Sorting in Pivot Table by
Volkan Cetin
How can i sort data in pivot table when i selected more than one item in raw
section.?
|
|
1 |
179 |
|
|
Function for tax? by
TB in DC
Let's say I get a hotel for two nights at the same hotel.
One night costs $50 and the second night $55.
The total bill is $105. The tax is 12.75.
Is there a...
|
|
2 |
140 |
|
|
Help me! by
Razzak
Please help me. I would like to separate one word from a cell.
Example : Cell A2 = The Quick Brown Fox
Question-1: How to separate "Fox" from Cell...
|
|
3 |
134 |
|
|
|
|
2 |
138 |
|
|
excel formulas by
moumin
what is the meaning "the formulas in the cell idiffers from the formula in
this area of the spreadsheet"?
|
June 15th, 2009 12:18 PM
by Jock
|
3 |
156 |
|
|
Tab naming from a Reference cell by
Finance Guru
Hi All,
Using Excel 2007
Can I name a worksheet tab from a cell contained within the worksheet. I
want to name a worksheet from the date contained in say A1...
( 1 2)
|
|
14 |
334 |
|
|
|
|
2 |
103 |
|
|
Reference to next non-blank cell by
Hilvert Scheper
Hi there Dear specialists,
Can I Please have some help with this;
I want a Formula that finds and returns the Text-string from the next
Non-Blank Cell in the...
|
|
5 |
134 |
|
|
|
|
11 |
268 |
|
|
|
June 15th, 2009 09:35 AM
by fake_be
|
2 |
170 |
|
|
Match multiple values by
willemeulen[_41_]
I need to match 3 values as follows:
B5 match with sheet1!A3:A194
C5 match with sheet1!B3:B194
D5 match with sheet1!C3:C194
Return value from column...
( 1 2)
|
|
15 |
226 |
|
|
Text file import by
Boris
Hi,
I have an external data query and am trying to create a formula that returns
the name of the file from which the query data is taken. This is of course...
|
June 15th, 2009 08:41 AM
by Boris
|
0 |
115 |
|
|
Time Situation by
Jafferi[_2_]
Cell A1 ~ 8:00
Cell A2 ~ 17:00
Cell A3 ~ ABS(A2-A1)=9:00 XXX
How can I formulate that Cell A3 is equal to 8:00 after minusing lunch of 1
hour. I keep on...
|
|
1 |
124 |
|
|
SUMIFS by
MurrayBarn
A B C D
1 01/11/2008 Motor -10,039.24 -1,232.89
2 01/11/2008 Non-Motor -12,414.70 -1,524.61...
|
|
4 |
183 |
|
|
Protect selected settings in 'options' by
John
In a particular workbook I have selected certain settings (tools, options,
view), namely not showing the sheet tabs, horizontal scroll bar, formula bar.
For...
|
|
4 |
128 |
|
|
|
|
3 |
145 |
|
|
|
June 15th, 2009 03:47 AM
by YS1107
|
2 |
169 |
|
|
"AverageIf" by
fozzie888
I want to create a formula along the lines of a "SumIf" but for averages -
the target cells are blank and will be filled in later, so until they are the...
|
|
4 |
151 |
|
|
|
|
7 |
176 |