|
|
Macro by
wrbmab
Can I create a macro in one of my spreadsheets and send it to another user so
they could use it on their adta in their computer?
|
|
4 |
146 |
|
|
|
|
3 |
129 |
|
|
Linking two VLOOKUP functions - Excel 2003 by
watermt
Worksheet 1 has one VLOOKUP function that provides an employee ID number
after it has been placed in a cell (via the drop-down list selection of the
last...
|
|
1 |
102 |
|
|
Hiding Column Issue by
Amy
I have a very large worksheet and need to hide addt'l columns. However when
I try to hide them I get the error message "Cannot shift objects off sheet" ...
|
|
1 |
114 |
|
|
|
|
0 |
97 |
|
|
Refer to current row in formula by
willemeulen[_12_]
I want to do a Hlookup which has to return the value from the row it's
standing in.
=HLOOKUP(L3,Sheet4!B2:AE35,????,FALSE)
L3 gives a code which is on top of...
|
|
5 |
119 |
|
|
Getting a percentage by
Enrique
I have several columns with 1 of 4 values (Y,N,N/A,blank). I need to
calculate the percentages of Y's. For example if there are 6 columns, 3 with
Y's, 2...
|
|
3 |
84 |
|
|
What function to use for filter of data? by
TashaBrighton
I have a worksheet containing Customer feedback data which I continually add
to. This is structured by employee, data, comment and so on.
I want to be able...
|
|
1 |
73 |
|
|
IF, Else functions by
MikePearl
Hi all,
I have an issue, where I have a formula to capture a month and its data.
The month on the columns keeps changing, example A1=Jan and the follwong...
|
|
0 |
79 |
|
|
Total amount By word by
art
Hello:
I have the following chart:
A
1 1 Plastic 2 Wood 1 metal
2 5 Plastic 2 Metal
3 4 Metal 3...
|
|
2 |
105 |
|
|
|
|
3 |
105 |
|
|
SUMPRODUCT by
Rich
Hi,
I have a formula which works...
|
|
2 |
104 |
|
|
SUM DATE on two worksheets by
barry
I have two worksheets - 1st one is Played 2nd one is Score
in first work sheet i have columns n "points" column o "date" in worksheet
two i have column c...
|
|
1 |
88 |
|
|
customize date by
enrico via OfficeKB.com
i customized a cell with a now() date field so that it's date is always
updated. i also designed the cell and add a "th" word so that today would be
shown like...
( 1 2)
|
|
11 |
243 |
|
|
The last word by
John
How do I extract the last word in a character string of words and spaces?
I appreciate your help, -John
|
|
6 |
85 |
|
|
How to select the best 2 values by
Mr.Param
hi,
I have 3 values, e.g, A1=67, B1=89, C1=92
At cell D1 and E1, how to get the best two highest values appear
automatically. TQ
|
|
1 |
78 |
|
|
Links Between Folders by
Kathryn Gies
Hi
I have a number of workbook that are linked together. Each workbook
represents one month of data and the current month links to the previous
month. All...
|
|
4 |
72 |
|
|
|
May 19th, 2009 02:15 AM
by Peter
|
2 |
107 |
|
|
|
|
3 |
91 |
|
|
|
|
2 |
133 |