|
|
|
|
1 |
559 |
|
|
How to retrieve data from a table by
GRK
I have built a Table (sheet 1) that includes 7 columns (A – G) and 11 rows
with the first row being titles. The titles in order are # of Users; Code 1;...
|
|
1 |
235 |
|
|
sizing in Drop Down lists by
Banker
I have attached drop down lists to a cell on my worksheet. The items in the
list are wider than the cell that it will be viewed in. I know I can format
the...
|
June 17th, 2009 10:23 PM
by Banker
|
6 |
269 |
|
|
Line of Characters by
[email protected]
I have cell A1 with a number, let's say 21
I need to find a way to automatically show 21 C's or B's or any
character in cell A2
If A1 changes to 24 then A2...
|
|
2 |
213 |
|
|
SUMPRODUCT Difficulty by
Pam
Hi,
After reading thru several posts and figuring out that I could not use
COUNTIF on non-adjacent cells, I tried using SUMPRODUCT but am still having...
( 1 2)
|
|
11 |
423 |
|
|
unprotect sheet (icon is greyed out) by
dj888de
I put a protection on the sheet so it is a read only, but I need to go back
in and unprotect it to change some of the cells. The icon is greyed out so
it...
|
|
1 |
224 |
|
|
|
|
3 |
196 |
|
|
Conditional format refers to two cells by
DOUG
How would I tell excel to format a cell based on values in the cell PLUS a
date formula in anouther cell? For example, "if the date in cell P2 is
greater...
|
June 17th, 2009 07:29 PM
by Luke M
|
1 |
217 |
|
|
How can I set the scaling in my macro? by
Gator
I am trying to edit my macro so that it selects fit to page 1x1. How can I
move the selector button in my macro to this field?
I have added the following...
|
|
1 |
141 |
|
|
lookup number greater than by
Ade Taiwo
I want to Look in a one-row or one-column range for a value and return a
value from the same position in a second one-row or one-column range, but
instead of...
|
June 17th, 2009 06:43 PM
by Luke M
|
1 |
141 |
|
|
|
June 17th, 2009 06:33 PM
by Rick
|
0 |
138 |
|
|
If Statement for a date by
jlo
In cell A6 a date is entered. In another cell is a total number of items.
To get a total price for the items, I take Total Number of items and multiple
by...
|
June 17th, 2009 06:02 PM
by jlo
|
4 |
160 |
|
|
lookup number greater than by
Ade Taiwo[_2_]
I want to Look in a one-row or one-column range for a value and return a
value from the same position in a second one-row or one-column range, but
instead of...
|
June 17th, 2009 05:52 PM
by Mike H
|
3 |
170 |
|
|
|
June 17th, 2009 05:49 PM
by BEEJAY
|
0 |
136 |
|
|
Excel Tables by
dwolter
Is there a way to turn off table calculations once calculated (besides the
tool - options-calculation - automatic except tables).
Does hiding a sheet with...
|
|
2 |
155 |
|
|
|
|
3 |
149 |
|
|
|
June 17th, 2009 04:24 PM
by Kim
|
2 |
173 |
|
|
|
|
5 |
172 |
|
|
If statement comparing times by
GoBrowns!
Hi;
I am trying to write a formula that will let me compare times and assign a
shift value (1st or 2nd Shift) based on that..... and I can't get it to...
|
|
1 |
106 |
|
|
Splitting Data in Cell by
[email protected]
I have a database that lists addresses in the following format:
111 Maple Dr.
I want to split the street number from the Street name so that I can
sort on...
|
|
5 |
174 |