|
|
SUMIF by
eliwaite
I'm trying to add up values in one row if the values in two other rows (in the same column) fall in the right values.
In Sheet 1 I have a list of dates, Y or...
|
|
2 |
133 |
|
|
Conditional Formating cocor VBA by
Shpendi
Hi all
I have the following code to change the color of the cell(
the cell underneath from where the data is).
I have values from 0 to 100 in Range...
|
August 3rd, 2004 11:33 AM
by
|
4 |
118 |
|
|
Re Target Times by
Bill
Thanks everyone Reference Thread preceding this text
Background
I need to show a minus figure in the total if the result
is better than target
ie target (c40)...
|
|
1 |
256 |
|
|
Match customer number to customer name by
Johnnyb
Hi,
I have a sheet (sheet1) with 2 columns, column 1 has customer name with
duplicates and column 2 has customer number with duplicates. I have
removed using...
|
August 3rd, 2004 01:02 PM
by JulieD
|
3 |
310 |
|
|
|
|
1 |
436 |
|
|
Excel Subtotal by
LPS
Using Excel 2000 is there a way to do the following:
Copy collapsed subtotals to another location and paste
them so they do NOT expand into the detail; only...
|
|
2 |
125 |
|
|
vlookup help by
Jambruins
I have attached a small portion of my file. In worksheet 1 the only
thing I want to have to change is the date (cell A1). I want cells
B2,B5,B8 to select the...
|
|
9 |
190 |
|
|
multiply multiple cells by a specific value by
german calvo
i have office 2003. im trying to multiple a range of cells by a specific number dont know how to do it. im hoping anyone can help resolve this. i want all the...
|
|
3 |
586 |
|
|
finding duplicates?... by
Dan B
Hi,
Is there a way in Excel to find duplicate names or numbers in a list?
Thanks,
Dan
|
|
1 |
82 |
|
|
Formula for rounding down numbers by
Rod J
Is there a formula for rounding down numbers to nearest
100 after they have been added together?
For example:
$861,771
+$35,357
=$897,128
rounded to $897,100.
|
August 3rd, 2004 07:28 PM
by
|
5 |
398 |
|
|
|
|
3 |
269 |
|
|
|
|
9 |
417 |
|
|
week ending "Sunday" date function by
krislyn
I would like the date in cell B1 on a weekly timesheet to always be the
previous Sunday's date when I open it. (once a week to update for
previous week's time)...
|
August 3rd, 2004 09:33 PM
by krislyn
|
4 |
219 |
|
|
Adding Debits & Credits within One Column by
S Philpot
I have a checkbook register in Excel. I have some columns that
contain both debit and credit items. I need to know how to tell Excel
to find the difference...
|
|
2 |
369 |
|
|
Skipping to the next cell in a worksheet by
Lo
If I have data beginning with cell A1 and want to 'count'
every 14 rows and pick up the data in the next cell (e.g.
A15) in my next line item, how do I put in...
|
|
3 |
128 |
|
|
|
|
1 |
218 |
|
|
"Conditional formatting" via VB? by
Trista
I created a workbook which uses about 3000 cells that have
conditional formatting.
Basically, the cell uses a dropdown and if "A" is chosen,
the cell turns...
|
August 3rd, 2004 10:43 PM
by Trista
|
2 |
515 |
|
|
Left function returning first word by
Richard Ruda
We've done a search under help for a "left" function that will return the
first word in a column (so theoretically, the funtion is searching for the
first...
|
|
4 |
297 |
|
|
|
|
1 |
421 |
|
|
Countif from multiple pages by
Clyde Lomax
Good evening,
I need help again. I have 31 sheets labeled 1st, 2nd ... 31st.
Data on column "e2:e15" on each sheet that I want to countif to a summary
page...
|
|
4 |
264 |