|
|
autofilters by
Diego Villaseñor Fernández
Hello,
When i use autofilters, sometimes appaers the count of articles founded, and
sometimes not. What do i have to do to to make it appears...
|
|
0 |
92 |
|
|
|
|
6 |
125 |
|
|
|
January 14th, 2005 02:47 AM
by S.C
|
0 |
155 |
|
|
Pivot Table % calculation by
CSAH
I need to calculate a % based on a grouped totalin a pivot table. I've tried
calculated field & items but can't get them to work. If I use a calculated
item I...
|
|
1 |
120 |
|
|
|
January 14th, 2005 05:46 AM
by Max
|
10 |
232 |
|
|
need to show date countdown by
petergw
have a column showing date of action next column shows next action date as 12
months date. next column needs to show days couning down from 365 to 0
|
|
1 |
94 |
|
|
|
January 14th, 2005 02:13 PM
by Gary T
|
2 |
254 |
|
|
SUMPRODUCT help by
benb
I'm still learning all the capabilities of the SUMPRODUCT function and need
help adapting it to my current purpose. I have a column of dates, and I am
trying...
|
January 14th, 2005 02:47 PM
by benb
|
8 |
109 |
|
|
tally by
Stan Altshuller
I have 100+ funds with ratings from different managers that I need to
summarize across each fund.
so
manager 1 manager2 ...
fund 1 buy sell ...
|
|
1 |
84 |
|
|
Excel worksheet tabs navigation by
Donald
I have a workbook with 100 tabs. Can I build a search button to find the
correct tab(sheet) from anywhere in the workbook?
|
|
1 |
179 |
|
|
|
|
2 |
303 |
|
|
LEAVE BLANK IF NEGATIVE by
Carolan
I know this can be done.....just don't know how. Trying to create a formula
that would leave the cell Column C1 empty if the result of Column A1
minus-Column...
|
January 14th, 2005 05:01 PM
by Carolan
|
3 |
125 |
|
|
Week Ending Date by
Superslinky
I need to change the date of my workbook to the week ending date. In other works, when I open my workbook on any given day of the week, it will adjust my date...
|
|
0 |
212 |
|
|
|
|
2 |
360 |
|
|
|
|
1 |
156 |
|
|
Hyperlink Length by
Jason
Hi,
I'm trying to insert a Hyperlink into a cell. The length of the hyperlink,
is 322 characters. When I use the Insert Hyperlink menu, the hyperlink...
|
January 14th, 2005 05:49 PM
by Jason
|
0 |
165 |
|
|
Shuffling Data To Make Lists Match by
Dmorri254
Hello,
I have two list that contain matching data. I need to be able
some how programatically shuffle the data in both list without going one by
one to make...
|
January 14th, 2005 05:58 PM
by Hook
|
1 |
277 |
|
|
|
|
2 |
252 |
|
|
copy and paste formulas by
Jim
HI,
I currently use this formula:
=SUMPRODUCT(--(AM3:AM10000=TIME(0,0,0)),--(AM3:AM10000=TIME(0,29,59)),--(AO3:AO10000=1))
How do I paste this into...
|
|
4 |
306 |
|
|
|
|
0 |
282 |