|
|
vLookup and Line Breaking by
Jon M.
Greetings all,
I have a worksheet where cell B8 and B10 perform a vLookup based on a data
validation in B6:...
|
March 10th, 2010 06:56 PM
by Jon M.
|
0 |
101 |
|
|
Macrs with Validation Rules by
Chris
I have a spread sheet with a tab called Estimnates once the Validation Item
for the estimated item is changed to "Contracted" I want it to Copy the
Entire...
|
|
1 |
125 |
|
|
Month (MMM) from date (dd/mmm/yy) by
Annie1904
In my spreadsheet I have a date column (col A) which I have in format
(dd/mmm/yy). I need to show the corresponding month in Col B, in MMM format
- April,...
|
|
1 |
127 |
|
|
report by date from a list of records by
UKMAN
Hi
The list is made up of records for training courses and includes start and
end dates and course duration, i.e. Name of person, start: 1 mar 2010, ends 4...
( 1 2)
|
March 10th, 2010 04:50 PM
by UKMAN
|
13 |
358 |
|
|
Custom Cell Formatting Using % With Dates by
Jason McDonald
First, thanks in advance for any help.
I'm using the NETWORKDAYS function along with the TODAY function to
calculate the amount of time that has elapsed for a...
|
|
2 |
157 |
|
|
|
March 10th, 2010 04:12 PM
by Pete_UK
|
2 |
129 |
|
|
Dynamic Named Ranges - is this possible? by
Code Numpty
Is it possible to take 2 dynamic named ranges that are effectively side by
side and print them on one piece of paper, one below the other?
I hope so........
|
|
2 |
110 |
|
|
Matching Data by
Alex Hammerstein
Hi
I have two sheets in a single workbook
I want to look up where data in sheet 1 Column A matches the data and sheet
2 Column A and where there is a match...
|
|
1 |
112 |
|
|
Prevent dragging cell contents by
GS
I am trying to prevent dragging cell contents in a form. I cleared "Allow
cell drag and drop check box" under Tools. But it works in only one computer.
If I...
|
March 10th, 2010 03:41 PM
by GS
|
0 |
115 |
|
|
Removing Hyphen(s) by
Curtis[_6_]
I have numbers separated by Hyphen(s) and I am looking for an easy way to
remove the Hyphen and just leave the text
My data could be
1410-4031 or...
|
March 10th, 2010 03:37 PM
by Iriemon
|
2 |
124 |
|
|
Locking a cell reference in a formula by
odonnjk
I have a worksheet that has formulas built within 6 columns. I want to drag
the formula in each column down 100 rows, but as I am calculating a date that...
|
March 10th, 2010 03:36 PM
by Iriemon
|
1 |
154 |
|
|
Text Function by
UlvaZell
Is there a text function counterpart to the SUMIF. A concatenate if? I have
a table of data and based upon a numeric value in the data I would like to...
|
|
0 |
94 |
|
|
|
|
1 |
94 |
|
|
|
|
2 |
129 |
|
|
validation by
selvaraj
hi, every one..
How to validate between two workbook..?
Is there any option on this
|
March 10th, 2010 01:14 PM
by Eduardo
|
2 |
89 |
|
|
Sum and Percentage Question... by
Doofus
Hi,
I'm after some help on what should be a fairly simple formula...
I have 2 columns of data as follows:
Column A - Product Name
Column B - Quantity
In...
|
March 10th, 2010 10:56 AM
by Doofus
|
2 |
94 |
|
|
Cells with time constraint by
Freshman
Dear experts,
In my worksheet, column A is for default dates of each month and column B is
for recording staff's reporting time. I want the cells in column B...
|
|
4 |
130 |
|
|
Pivot Table Defaults by
btexprs
In the pivot table field list, whenever I create a new pivot table and I am
inserting fields into the value area, I generally get as default field
setting...
|
|
1 |
109 |
|
|
|
|
5 |
156 |
|
|
|
March 10th, 2010 06:01 AM
by Max
|
4 |
154 |