|
|
Need help displaying odd numbered month by
Greg L[_3_]
I'm trying to get the odd numbered month (Jan, March, etc) and
display the next tenth of that month.
For example: If its the 9th of Jan, display 1/10/current...
|
June 30th, 2009 04:27 AM
by Sheeloo
|
3 |
90 |
|
|
count formula by
OKY
Hi
I am makeing a worksheet for the dispatchers ast works.
This is what I did so far.
TECH NAME JOB# TIME HHHC STATUS
LUIS G ...
|
June 30th, 2009 04:05 AM
by OKY
|
2 |
120 |
|
|
|
|
3 |
133 |
|
|
|
|
5 |
181 |
|
|
|
|
3 |
133 |
|
|
Multiple column filtering by
faraz316
Hi,
I am trying to group multiple non-consecutive columns so that all columns
can be hidden and each group can be displayed.
I have 40 columns with...
|
|
2 |
112 |
|
|
SUMIF, IF ? by
Steve
I have this formula:
=SUMIF($B116:$B124,"V",S116:S124)
In Q116:Q124, I have various numbers, such as 1300, 1400, 1500.
What can I add to the above formula to...
|
June 29th, 2009 11:23 PM
by Steve
|
5 |
162 |
|
|
|
|
3 |
121 |
|
|
|
|
4 |
125 |
|
|
Breaking links in Excel by
brosull
how do I break an excel link to another worksheet when "Break Link" work?
Thanks to Shane for replying.
|
|
2 |
84 |
|
|
Help with SUMPRODUCT by
EricB
=SUMPRODUCT((crq1!$B$2:$B$10000="app")*(crq1!$F$2:$F$10000="Sys")*(crq1!$H$2:$H$10000=""))
Column ‘H’ contains blank cells and cell with random...
|
|
5 |
125 |
|
|
Sorting 2 data columns in Pivot Table by
Alonso[_2_]
Hi everybody
I have a pivot table with 2 datas (HI and LOW) for each row
I want to sort them descending on BOTH columns -when HI has the same value
for 2 or...
|
|
2 |
100 |
|
|
|
|
2 |
156 |
|
|
Locking a Spreadsheet but allow inserting by
Tami
I have a Buyers spreadsheet that the majority of it needs to be
locked/protected. The buyer can then type in the styles names, units, cost
of styles they...
|
June 29th, 2009 07:04 PM
by Tami
|
5 |
158 |
|
|
|
|
2 |
123 |
|
|
Rolling 12 month total by
MH
Hi,
I have searched to message boards and can't quite find what i'm looking for.
I'm trying to keep a 12 month running tally (When I enter the information
for...
|
|
7 |
158 |
|
|
cell w/ drop down then reference by
Jackie
K, I have a drop down box in "Tracking" workbook B3 with "Part Numbers".
When I choose one of the part numbers from that drop down box I want C3
("Current...
|
|
5 |
119 |
|
|
|
|
1 |
177 |
|
|
|
|
1 |
101 |
|
|
|
|
3 |
97 |