|
|
|
|
5 |
127 |
|
|
Sequence of Weeks in a month by
Elton Law[_2_]
Dear Expert,
Is there any functions that can identify the number and the sequence of week
in a month please ?
Weekday(A1) can only give Mon,Tue, Wed ....
Say...
|
|
4 |
71 |
|
|
Subtract 10 months from a Speficic Date by
AHizon via OfficeKB.com
I have a spreadsheet with an Eligibility Date for Upgrades, which is 10
months after it was upgraded. I need to determine when the device was
originally...
( 1 2)
|
|
11 |
106 |
|
|
Formula for attendance record by
Preschool Mike[_2_]
On sheet one of my workbook I have my daily attendance record (e.g., date and
names of children absent) on sheet two of the same workbook I have my yearly...
|
|
5 |
62 |
|
|
Copy only letters, not numbers by
Connie Martin
I have a huge long column of text---product codes, to be exact, that could
look something like this: CNUB275X3 or PB24X275. What I need is a formula,
which...
|
|
8 |
79 |
|
|
stacking if functions by
Idaho
I use spreadsheets for recording measured dimensions. I am trying to set up
my template so when I put the dimensoin in, it tells me if it is right or
not....
|
|
1 |
73 |
|
|
Summing a column by
Rooky228
I have a column of numbers - some with different colors. I'd like to sum
just the green or the red, etc. How do I write a formula that somes only
certain...
|
|
6 |
146 |
|
|
|
|
2 |
79 |
|
|
|
|
6 |
139 |
|
|
|
May 14th, 2009 10:11 PM
by ker_01
|
0 |
132 |
|
|
|
|
0 |
87 |
|
|
|
|
1 |
95 |
|
|
How do I format every 140th row? by
From the farm
I need to highlight every 140th row which, I assume, I would use conditional
formatting but I don't know how to do it.
|
May 14th, 2009 09:56 PM
by Paul C
|
2 |
107 |
|
|
Count based on two different criteria by
dabnat
Sheet name Active
column C has names of counties example: marion
column H has the way something sold example: estate sale
I need a count where column...
|
|
3 |
108 |
|
|
|
|
2 |
86 |
|
|
Vlookup by
Lorry
I am using the vlookup function and need it to return the match for the next
highest value, not the closest below the value. Example: Value is 61 and I
need...
|
|
3 |
110 |
|
|
Using INDEX & MATCH to VLOOKUP prior column by
TraciAnn via OfficeKB.com
Hello!
I use range names for all my functions and I'm trying to lookup a number
(LeadID) in a column (TechUserID) on another sheet (same workbook) and...
|
|
5 |
74 |
|
|
|
|
1 |
96 |
|
|
|
|
0 |
97 |
|
|
Applying users to site/names by
fgwiii
I have 20 or so excel workbooks that are created at an external source and
downloaded to our server. Each workbook contains a site and names that belong
to...
|
May 14th, 2009 07:38 PM
by fgwiii
|
0 |
82 |