|
|
VBA - Data Validation (Looking for NERD help) by
Christoffer Bloch Andersen
Hi
I currently have a problem with my Data Validation.
I need to be able to copy paste (special - values) in the range of where my
DV is, but by doing so it...
|
|
2 |
158 |
|
|
Hiding Formulas by
Looking for help today
Looking for formula set up help. Current workbook I have for example,
information in cell A1 from sheet one formulated to sheet 2 for same cell as...
|
|
9 |
80 |
|
|
Name Sheet Tab to Reflect Edit Date by
Gerard Sanchez
'Hi,
'I got this simple code, I was wondering if anybody here can help me put
the 'value of "_timestamp" (see below) as name of my worksheet.
Private Sub...
|
|
3 |
57 |
|
|
Drop Down List Question by
nowhereman[_2_]
Does anyone know how you can make a cell show a different drop down list
to pick form depending on the contents of another cell.
example
i now have data...
|
February 23rd, 2009 07:14 AM
by T. Valko
|
5 |
85 |
|
|
|
|
7 |
74 |
|
|
Matching data in two columns by
Max
Hello,
I need help with finding the last game that two teams played each other,
either home or away.
This is to decide who will have the home town advantage...
( 1 2)
|
February 23rd, 2009 04:22 AM
by T. Valko
|
18 |
214 |
|
|
Moving cells by
robin
Hi,
In Microsoft Works, to change the order of a rows of cells, I can cut a row
of cells, paste it into another row, and it "bumps" all the rows beneath it...
|
|
5 |
68 |
|
|
SumProduct problem by
John
How do I fix the following to sum the column & not get a #NAME? error?
=SUMPRODUCT(--(IsNumeric($D$10:$D$500)), --($D$10:$D$500))
I appreciate your help,...
|
February 23rd, 2009 01:52 AM
by John
|
5 |
64 |
|
|
|
|
7 |
192 |
|
|
calculations - table, if, or, , etc etc by
Red_Goldfish
I need a formula to calculate redundancy payments in a table. The redundancy
payment due to each employee depends on his or her age and length of service...
|
|
5 |
65 |
|
|
Which function do I use? by
Zong
Workbook with 2 spreadsheets. I need to look up a part number in one column
and have it give me the value in another column on the same row.
PS# ...
|
February 22nd, 2009 11:20 PM
by T. Valko
|
7 |
77 |
|
|
Excel Pivot 2007 Report Format by
Susan
I am trying to format pivot to better display of an Event Timeline. I have
one Pivot by Category, Sub-catetory, etc. and the other Pivot by Date, Tim,...
|
February 22nd, 2009 10:24 PM
by Alojz
|
4 |
98 |
|
|
Excel 2003 Worksheet by
Jan
When I add color to cells in a worksheet, the gridlines disappear. How do I
get them back?
|
|
1 |
61 |
|
|
Counting cells that contain a substring by
John
How do I count the number of cells in a range that contain the character
substring xxx?
I know =COUNTIF($G$8:$G$11,"kkkk") counts cells that are exactly...
|
February 22nd, 2009 04:59 PM
by T. Valko
|
3 |
74 |
|
|
Cross tab table by
liem
I do not want to use Pivot function
I have a table of 5000 row with five column
Division District Salesman Factor result
If I want to recap the result...
|
|
7 |
135 |
|
|
Questionnaire by
pkuphenix
Hey, folks, I am doing a key project at Beijing University on culture
discrepancy, and I am honored to have you fill out the following
questionnaire. Your help...
|
|
0 |
100 |
|
|
How do I apply a rounding rule by
riffmastr7
Hi, I need to apply the rounding rule below for conducting our business when
dealing with a number that has a 0.5 ending:
Example:
If the average is 54.5, I...
( 1 2)
|
|
15 |
201 |
|
|
|
|
4 |
86 |
|
|
protecting certain cells in Ecxel 2007 by
Energizer Bunny[_2_]
I've created a spreadsheet for my work to calculate the number of patrons and
sales. I would like to protect only the cells that have formulas in them, so...
|
|
2 |
75 |
|
|
|
|
3 |
75 |