|
|
advanced filtering by
[email protected]
I need to do a "reverse" advanced filtering. In other
words, I need to highlight a column of names and seperate
the "non" duplications. When I do the advanced...
|
|
5 |
195 |
|
|
|
February 8th, 2005 04:33 AM
by Andrew
|
6 |
195 |
|
|
|
|
4 |
195 |
|
|
Formula presumes cells have data by
Pat
The following formula presumes there is data in N75 and J75
=IF(ISNUMBER($R75)*($R750),"",IF(AND($N75-$J750,$Q75=1),0,$N75-$J75))
When no data can be...
|
|
1 |
195 |
|
|
Need Formula for Date Conversion by
Lyle
Hello. I am fairly familiar with Excel and have been racking my brain trying
to figure a formula out. Here is the scenario. The military uses dates in
this...
|
March 31st, 2005 12:09 AM
by Jim
|
4 |
195 |
|
|
|
April 12th, 2005 05:38 AM
by Biff
|
1 |
195 |
|
|
auto change number entries by
ToddG
Is there a way that I can change all of the hard 8's entered into a worksheet
(not the 8's resulting from formulas) to all hard 9's without re-typing all
of...
|
April 25th, 2005 01:46 PM
by ToddG
|
2 |
195 |
|
|
another text to column problem by
gbeard
I have a sheet with data in 4 columns. Column A is the clients name,
address and city. Column B is the state the client is in. Column C is the
zip code of...
( 1 2)
|
May 5th, 2005 07:20 AM
by gbeard
|
11 |
195 |
|
|
limit of 7 nested functions? by
Olympiad
I have the following formula working well, however as there is a limit of 7
nested functions and need some more, what is my options?
=IF(B5="P-NE","Pre App...
|
|
3 |
195 |
|
|
Logical Function - Multiple IF statements by
vnsrod2000
Can anyone help me figure out a formula for the following sliding bonus
scenario:
To receive a bonus, Gross Profit must be at least $250,000
Once minimum is...
|
|
7 |
195 |
|
|
create dropdown menu by
Anthony
Hi,
can anybody advise (or direct me to basic creation site) where I can create
a dropdown menu in excel.
the menu will hold seveal options ie Food, Drink,...
|
January 29th, 2005 01:30 PM
by JulieD
|
1 |
195 |
|
|
Computer crash on closing Excel by
Christiane Schmieger
I am using Excel for a long time now and it always worked fine.
But one week ago it started to crash my whole system whenever I close
it. This even happens...
|
|
3 |
195 |
|
|
|
|
2 |
195 |
|
|
enhance vlookup to not return #n/a by
Tom Leslie
I use the hlookup, vlookup and lookup functions in Excel a lot -- they're
really powerful for building automated reports. It's annoying that they
return #N/A...
|
September 21st, 2004 12:18 AM
by hgrove
|
2 |
195 |
|
|
|
|
1 |
195 |
|
|
|
|
6 |
195 |
|
|
|
|
6 |
195 |
|
|
|
|
1 |
195 |
|
|
Formula to Calculate Age by
Tabitha
I have an age column and a DOB column, What is the formula to calculate the
age by using the date of birth.
|
January 24th, 2005 04:09 PM
by Tabitha
|
2 |
195 |
|
|
calculation of interest between two dates by
Arvind Khanna via OfficeKB.com
i had a unique problem. i have to calculate interest on some amount with
relation to some period of fiscal year. for ex
interest on 100 from 1/7/2000 to...
|
|
2 |
195 |