|
|
|
|
1 |
125 |
|
|
|
|
2 |
156 |
|
|
If date in range is before today by
mjones
Hi All,
I'm getting #VALUE! with this formula.
=IF('AP-AR'!B43:'AP-AR'!B297TODAY(),"AP-AR needs updated","")
I've probably made a right mess of it, but...
|
|
3 |
156 |
|
|
VLookup with multi-condition by
anthony alvarez
I am doing a vlookup with regard to time keeping
A B C D
ID Date Time Status
0001 01/01/2010 7:25AM IN
|
|
2 |
221 |
|
|
Count if equal to first non error cell by
John
Hi I tried to post this once so apologies if this is second post...
I want to count the number of times 3 or -3 occurs in range A8:A15 depending
on whether 3...
|
January 11th, 2010 02:56 AM
by John
|
0 |
190 |
|
|
Same cell but different worksheet by
mjones
Hi All,
Can I make a cell the same as the cell, but in a different worksheet.
It's a text field.
For example A1 in worksheet Marketing Report should be the...
|
|
3 |
166 |
|
|
|
|
3 |
227 |
|
|
count text occurance in range by
Stehy
I am working in Excel 2003 and would like to enter a formula counting the
number of times a specific word (sometimes in a sentence) appears in a range
of...
|
January 10th, 2010 10:55 PM
by Garyj
|
3 |
134 |
|
|
array frequency data search by
bishee
Hi.
I need to list, in order of frequency, the five most frequently occurring
numbers from a cell series (say A1:J10). I have been stumped for weeks on...
|
|
1 |
137 |
|
|
freeze pane option not available by
dave f
The freeze pane option is not highlighted on my toolbar. Consequently, I
cannot select it for use. As best as I can determine the worksheet is not
procted.
|
|
1 |
159 |
|
|
count the presence of a date as 1 by
WLWTNG
I am building a sales tracking chart which includes a date when an item is
sold. I need to count the number of sales based on whether or not a date has
been...
|
|
2 |
160 |
|
|
|
|
2 |
145 |
|
|
Trying To Put IFs into a Function by
SkippyPB
Ihave one thing I do in a formula that I don't know or haven't figured
out how to make it work in a function.
The formula looks like...
|
|
2 |
170 |
|
|
Automatic Sorting? by
Ted[_15_]
I have a worksheet.
Row 1 contains column headers
Row 2 is blank
Rows 3 through row 548 contain data in columns A through W
First sort condition: Column F,...
|
|
6 |
143 |
|
|
|
|
1 |
148 |
|
|
SumProduct not right by
Steve
This formula is summing ALL the incidences in the N column of what's in E2. I
want it to sum ONLY those that are in E2 but also also matching what's in...
|
January 10th, 2010 03:41 PM
by Steve
|
7 |
226 |
|
|
|
|
3 |
144 |
|
|
|
|
2 |
165 |
|
|
Editing time that has its colon removed by
rhhince[_2_]
I have a large CSV file that has the time column stripped of its colon
meant to distinguish hours and minutes.
ie. 9:20 is displayed 9200.
23:55 is...
|
|
1 |
157 |
|
|
|
|
2 |
147 |