|
|
| Find any cell with a specific format |
| I am looking for a formula I can use to determine whether a cell contains
variable data, but of a certain criteria. For example, I am looking to
determine if column A has an Arizona license plate or... on 20-Nov-09 |
| |
|
|
|
| copy conditional formats |
| I have a column that has been conditionally formatted with equations, using
the "fill" command to color the cells based on the relative values of cells
in other columns. I want to copy only the col... on 20-Nov-09 |
| |
|
| Excel 2007 Form errors in calculations |
| I created a form in Excel 2007 that uses calculations. The
calculations in the form work great on my home computer (WINDOWS 7,
Excel 2007), BUT the calculations do not calculate at work using the
sa... on 20-Nov-09 |
| |
|
| Challenging Sort Problem |
| Have a spreadsheet with items.
A = Multiple Locations
B = item id (in each location)
C = Description
D = Qty on Hand (some have zero)
E thru J = has misc data
I am trying to sort by D - Highest qty... on 20-Nov-09 |
| |
|
| how to do in excel |
| hi all
if i have the following coulm
26
26
22
23
24
26
25
24
12
i want formule to remove duplicate so the result will be as following
26
22
23
24
25
12
and other formule if it is possible to gi... on 20-Nov-09 |
| |
|
| Count YEAR value? |
| I need to count the number of certain years in a row with date values.
Something like "number of cells in a1..a99 where year=2008"
I tried various ways of using COUNT and YEAR functions, but have n... on 20-Nov-09 |
| |
|
|
|