|
|
|
|
4 |
142 |
|
|
Help with colour formula by
bill gras
In column W row 2 I have a formula eg:
=IF(AND(L2=5,V2=7.1),V2,"") copied down to row 1001
not every row has a result , lots of rows are blank .
The...
|
|
3 |
97 |
|
|
Inserting symbol by
judyl
I'm trying to insert a symbol next to a number in a cell that is totaled.
When I attempt this the number is not then recognized for the correct total.
Do I...
|
January 8th, 2010 11:11 AM
by Mike H
|
6 |
90 |
|
|
lookup over several columns by
Sander Nagtegaal
I'm trying to have a lookup over several columns
situation
sheet 1
A B C
56 110 50000
56 120 10000
56 130 5000
57 110 30000
57 ...
|
|
2 |
141 |
|
|
Check Box Question by
Ksean
How do I achieve the following?
If cell D10 has anything of any value in it I would like cell D5 to display
a result of ‘X’ however if cell D10 is blank...
|
|
5 |
141 |
|
|
|
|
1 |
109 |
|
|
Excel - IF formula with range of cells by
Chris
I am trying to create a formula that if a range of cells contains a specific
value AND a range of cells in the next column contains a specific value, then...
|
|
2 |
98 |
|
|
|
|
1 |
105 |
|
|
|
|
8 |
149 |
|
|
|
January 7th, 2010 11:10 PM
by Eva
|
3 |
132 |
|
|
Pivot Table (behind the scene) by
DHN
Hello MVPs,
I need help with a formula that would be able to do the same as a filter in
a pivot table. I have two filters that I would like to be able to...
|
|
8 |
145 |
|
|
Auto Calculate Question / HELP! by
Andy
When I click on the fill handle to drag the data down the cells fill with
data grabbed veritcally, for example: When I drag the fill handle down the
formulas...
|
|
2 |
107 |
|
|
Hide/lock worksheets by
McChas
I have a workbook with 10 spreadsheets. Each sheet/tab is for individual
employees. Is there a way to have a user sign in and only view their own tab
and not...
|
January 7th, 2010 06:50 PM
by Luke M
|
4 |
102 |
|
|
New Drop-Down Functionality in 2007? by
GregO
I've noticed when working in 2007 that I can reference field names as
, which show up as a drop-down menu. As soon as I type =[, a
menu pops up with a listing...
|
|
2 |
133 |
|
|
|
January 7th, 2010 06:23 PM
by Luke M
|
1 |
99 |
|
|
|
|
1 |
192 |
|
|
|
|
3 |
125 |
|
|
Lookup cell for documents in a folder by
Marc Trumpi
I am trying to create an overview of the time spent on projects. People hand
in weekly time-charts in excel format where the projects are referenced by a...
|
January 7th, 2010 02:17 PM
by JLatham
|
1 |
106 |
|
|
convert numbers by
ekkeindoha
Good day,
I would like to auto change the top number to 5 and descending to the last
one to be 2.
2868 5
1800
1800
1200
624
624
576
|
|
3 |
92 |
|
|
Timesheet formula problem by
Leo
Trying to add two rows of times with the result in one cell, but having
trouble. When I try to add the two rows together, I get a “$VALUE” result.
...
|
|
3 |
117 |