|
|
|
|
1 |
147 |
|
|
conditional format help by
hj
column A is my finished date, column C is my serial #. If I enter the same
serial # within 180 days of my finshed date what formula can I use to turn
cell...
|
|
3 |
170 |
|
|
Conditional Formatting - stuck on formula by
Awrex
Hi - Thanks beforehand!
I'm stuck on a formula for a condition and hoping someone can help.
=AND($H23="stalled",$G23TODAY())
Is currently what I have and...
|
|
3 |
147 |
|
|
|
May 3rd, 2010 11:48 PM
by Zuo
|
3 |
190 |
|
|
|
|
2 |
176 |
|
|
|
|
1 |
202 |
|
|
Excel and consecutive number by
Shadowkiller361
Is there a way to have excel locate a set number of consecutive non-zero
numbers and give me an average of those numbers?
trying to get around this problem:
5...
|
|
2 |
154 |
|
|
IF function by
winnie123
Hi there,
I am trying to project FY sales based on open orders,shipped orders and
forecast.
I have pulled together the 3 lots of data and used SumProduct to...
|
|
4 |
225 |
|
|
countif/sumproduct + month by
MM
Hi all,
Fourth try's a charm....I'm getting errors trying to post my question. Here
it is...
1 workbook, 4 worksheets each named for a different...
|
|
1 |
178 |
|
|
|
|
1 |
206 |
|
|
Proper Formula is stuck and does not work by
Diggsy
Hello,
I was wondering why my text formula of proper is not working. I have placed
the formula =proper(f2) in column e2 All I get is the formula =proper(f2)...
|
|
4 |
130 |
|
|
Lookup / Summary Table by
Joe
I want Excel to lookup a value in a table and return each row it finds that
value in.
As an example:
Lookup Value: Ford
Lookup Table:
A1: Ford B1: Focus
|
May 3rd, 2010 08:44 PM
by Joe
|
0 |
142 |
|
|
|
|
0 |
127 |
|
|
complex lookup by
Doug
I have a lookup table that I need to reference. based on a 3 digit # such as
"2.22", I need to be able to find the cross section on the lookup table.
Based on...
|
|
8 |
241 |
|
|
|
|
8 |
230 |
|
|
code to copy range by
smith82
Hi anyone,
I’m having two sheets in my workbook where I have named them as
“Receipt” & “Price Range”.
I'm searching for a formula that would copy the...
|
|
1 |
152 |
|
|
Using Fill command in Editing Group by
Caz
Hi,
I am trying to find more info on how to use the functions on the Fill
Command in the Editing group especially regarding dates as I cannot seem to
get...
|
|
2 |
207 |
|
|
Macro for Time Recording by
karim
hi,
I want to record current time into cell(A2) when cell (A1) does contain
value with macro.
I want to record it automaticaly without using any shortkey or...
|
|
2 |
145 |
|
|
Format Ratio Q by
Seanie
How can I express below in a ratio format? It returns an invalid
error. If I was to just do it without the text, I'd simply FORMAT,
custom 0.0" :1", but it...
|
|
2 |
141 |
|
|
|
|
5 |
197 |