|
|
select records with a specific value by
AMK
How can I select only those records with a "1" in col A and highlight only
col C of the same record(s) for copying? I'd like to put this in a...
|
|
3 |
108 |
|
|
|
May 27th, 2006 11:14 PM
by amk005
|
4 |
105 |
|
|
Formatting Cells by
amkake
I enter 5562815 in a cell, then try to format it to currency. I've tried all
the choices and it changes to $5,562,815.00 instead of $55,628.15 like I want
it...
|
December 20th, 2006 04:14 AM
by Banker
|
2 |
69 |
|
|
Multi Level Subtotals and SP2 by
amkazen
Hi, I have searched and read the search results for the problem I am having.
The problem is the subtotals are not being staggered properly, appearing in
their...
|
March 1st, 2006 05:25 PM
by CLR
|
3 |
82 |
|
|
Multi IF statament by
AMM19
I am trying to build an IF statement that would apply and I could copy
accross as a formula. I want to include in the cell C3 an IF query that would
populate...
|
October 3rd, 2006 09:09 AM
by Max
|
2 |
124 |
|
|
"Find" through entire Workbook by
AMMC
How do I use the "Find" function to search through an
entire workbook instead of just one sheet in the
Workbook?? Any advice would be greatly appreciated.
|
|
3 |
193 |
|
|
|
|
2 |
387 |
|
|
look up tables by
amn164
I have a drop box that is getting number-letter part numbers for me and telling me if they have been superseeded by another part number. However I have one...
|
|
1 |
86 |
|
|
|
|
2 |
72 |
|
|
Excel - Change cell display limitations by
AmnNkD
Does anyone know if there is any way to expland the limitations set to
display the number of characters in a cell. I understand that the cell can
contain over...
|
May 2nd, 2006 06:51 PM
by AmnNkD
|
2 |
81 |
|
|
Activate cell in protection mode by
Amnon Wilensky
Hi,
I have a code that by clicking on any cell on the spreadsheet passes the
information to predefined cell.
The problem is that when I protect the...
|
|
6 |
76 |
|
|
Passing data to fix cell by
Amnon Wilensky
Hi,
Is it possible to pass data from any cell on the spreadsheet by clicking on
it, to a predetermined fix cell?
Thanks,
Amnon
|
|
4 |
56 |
|
|
Twin cells by
Amnon Wilensky
Hi,
Is it possible to make two cells "Twins"? What I mean is if I'll input in
cell A1 the number 1 it will appear on cell B1, and vice versa?
Using Excell...
|
|
5 |
74 |
|
|
Vlookup problem by
Amnon Wilensky
Hi,
I have a problem with the Vlookup formula. It`s only works right on the
first time when I entered the formula but the results don`t change when I am...
|
|
3 |
70 |
|
|
Combo Box by
Amnon Wilensky
Hi,
I have to columns of data. The first is with the Months and the other is
with Numbers, For example, in column A1:A12 there are the months (January,...
|
|
2 |
80 |
|
|
Painting equal cells by
Amnon Wilensky
Hi,
I have to columns, side by side full with 248 rows of data.
How can I paint, using conditional formatting, the cells with equal data?
Thanks,
Amnon
|
|
2 |
50 |
|
|
Painting blank cells by
Amnon Wilensky
Hi,
How can I use Conditional format to paint all empty cells on a certain range
(say A1:D24) with yellow color?
Thanks,
Amnon
|
|
4 |
72 |
|
|
Ignoring empty cells by
Amnon Wilensky
Hi,
how can I force excel 2003 to ignore in calculation empty cells but not
cells with zero.
For example:
the formula =If(d4=0,e4*f4," ")
brings 600000 in...
|
|
6 |
48 |
|
|
Stop zero on cell by
Amnon Wilensky
Hi,
How can I stop Excel formula to consider a blank cell as a zero?
I have a column with zeros and blank cells. I need the formula to consider
the cells with...
|
|
7 |
56 |
|
|
Activating object from Excel cell by
Amnon Wilensky
Hi,
I have a worksheet full with numbers. Every number represent a scanned page
with a data. How can I retrieve the page when I am clicking on the number in...
|
|
2 |
81 |