|
|
|
|
0 |
122 |
|
|
|
|
3 |
247 |
|
|
Averaging unique values by
DamienO
Hi all,
I have rows of data being recorded for different dates. The number of data
points for each date changes (normally 1-4). Since I don't know in advance...
|
April 14th, 2010 09:53 AM
by DamienO
|
2 |
143 |
|
|
Cell Styles on Ribbon by
Stephen J
The context window that should "pop-up/out" when I click on Cell Styles on
the Home tab is "locked" on to my ribbon. Normal, Bad, Good, etc. is on one
line...
|
|
1 |
166 |
|
|
Hyperlink mapping by
mamalhe
Is there a way to show the mapping of hyperlinks on a worksheet?
--
mamalhe
|
April 14th, 2010 05:14 AM
by mamalhe
|
0 |
105 |
|
|
Use module globally by
chrissy2391
Thanks to the Disscusion groups I found the following to delete blank rows:
Sub macro_der()
Dim i As Long, nLastRow As Long
Set r =...
|
|
1 |
131 |
|
|
Excel Sudoku by
ernie
Hello!
I know this sounds crazy. But does anyone know how to create a sudoku game
using excel 2003 that has a timing function to it. Meaning, I am able to...
|
|
1 |
144 |
|
|
|
|
1 |
114 |
|
|
|
|
1 |
129 |
|
|
Formula to return a formula by
Pelldom
At least I think that's what I'm looking for. here's my situation:
I've got a sheet where there is a variable (X) that changes depending on
what row it is on....
|
April 14th, 2010 02:23 AM
by ck13
|
1 |
91 |
|
|
Sumproduct Question by
JCS
Hi All,
I've been experiementing with the Sumproduct function in Excel 2007 and ran
across a problem with the function that I cannot figure out. The...
|
|
7 |
119 |
|
|
Match or Vlookup by
Rob
I have the following data and need to extract only the data where the value =
false
The true / false is Column D with Column H
A B C ...
|
|
4 |
110 |
|
|
Average using Sumproduct or .... by
heater
I have 12 tabs (same worksheet) that I need to average a number in cell b6.
The issue is sometimes there is a zero in b6 and I do not want to count it in...
|
|
3 |
200 |
|
|
|
April 13th, 2010 11:53 PM
by ieberry
|
4 |
169 |
|
|
|
|
12 |
263 |
|
|
|
|
2 |
136 |
|
|
Count function not working in one workbook by
Carolyn
The count function is not working in one of my workbooks. It works in others
and in new ones. The workbook it is not working in was created last week.
It...
|
|
8 |
135 |
|
|
Command botton by
Lou825
I need help with Excel 2003. I have different conditional formatting in
columns A through S. I've intentionally left row 2 blank. What I am trying
to do...
|
|
3 |
138 |
|
|
Custom Number Formats for Excel 2007 by
Brian O[_2_]
Hello
I open several Excel spreadsheets daily that include a date/time column.
Every spreadsheet that I open I have to change the column formatting to "dddd...
|
|
1 |
109 |
|
|
First Pivot Table by
Linda RQ[_2_]
Hi Everyone,
Using Excel 2003. I created my first pivot table being guided over the
phone and didn't quite remember how I got it grouped by years and...
|
|
4 |
129 |