|
|
Vlookup by
pawan
vlookup funtion is returning me #N/A but can I get this replaced with 0 or
blank
|
|
4 |
117 |
|
|
|
May 20th, 2009 10:07 AM
by Gaffnr
|
1 |
106 |
|
|
|
|
1 |
105 |
|
|
Hiding Page Breaks by
Joe
Hiding page breaks in excel 2007 is now a painful multi-step process that
requires you to select the office button, hit "excel options," select the...
|
|
3 |
124 |
|
|
Conditional by
PAL
This formula works nicely as an array for counting the number of values.
=COUNT(IF(('Enroll I'!$C$2:$C$2741=A4)*('Enroll
I'!$H$2:$H$27410)*(YEAR('Enroll...
|
|
1 |
86 |
|
|
Excel 2007: complex COUNTIFS() by
David Aukerman[_2_]
I am trying to do a COUNTIFS() function in which I need to compare the
difference between two numeric cells in the same row. In my spreadsheet,
column G and...
|
|
8 |
183 |
|
|
Hi Could you please help? by
Cazumel
I have the following situation
Column A Column B Column C
M Project# R Project#
M0001 ...
|
|
7 |
235 |
|
|
distributing days by
KANDLEZ
I need a formula to distribute 3 days per year evenly. I have a cell with
the start date this include month, day and year. I want to distribute the
day...
|
May 20th, 2009 02:01 AM
by Max
|
1 |
100 |
|
|
conditional formula by
PAL
I have a worksheet with ~10 columns and a 1000 rows.
In column F, I have a date that has a range of several years.
In column H I have a value, which...
|
|
5 |
93 |
|
|
RANK dates from the middle of the month. by
Paul Moles
I am paid on the 15th of each month, my bills are spread throughout the month.
I am trying to find a formula or system to automatically rank the payments
as...
|
|
1 |
81 |
|
|
Max if less than, Non-continuious array by
ToddEZ
I have dates in cells A1, C1, and E1. Cell F1 = 1/1/2009.
What formula can I use to find the maximum of cells A1, C1, and E1 IF AND
ONLY IF the date is is...
|
|
7 |
236 |
|
|
|
|
1 |
104 |
|
|
Track Changes Not Working Properly by
Gina
Hi. I've been having my employees use the track changes feature in MS Excel
2007; however when I go through to highlight the changes on my computer, it
only...
|
May 19th, 2009 11:43 PM
by Gina
|
0 |
81 |
|
|
overriding formulas by
Kay
I have the formula if($0$3=20,2) I want to over ride to equal 0 (zero) if
cell D60 = N
--
KK
|
|
3 |
156 |
|
|
If funcion on big formula by
willemeulen[_14_]
I have the following formula:
Schematic:
(A+C+E) + 0,57(B+D) - 3,14d
Excel:
=(Sheet1!M3+Sheet1!O3+Sheet1!Q3)+0.57*(Sheet1!N3+Sheet1!P3)-3.14*Sheet1!F3
|
|
6 |
143 |
|
|
Overriding formula by
KANDLEZ[_2_]
I have a if formula in a cell, but need to override it from another cell.
what formula can I use.
--
|
|
2 |
79 |
|
|
Cells Appear Blank but aren't by
Jennifer
Why do the cells in Excel sometimes appear blank but in the function line it
shows that it has info in it?
--
Jennifer
|
|
5 |
92 |
|
|
calculating by
KANDLEZ
I am trying to create a timesheet using "v" for one vacation day and "1/2v"
for a half of vacation day. function to count so that the total be 11/2 (one
and...
|
|
3 |
80 |
|
|
IF formula by
Jeannine
I am trying to lookup an exact value (1113) in one cell and one column. then
move across the row to a different colunm to add the values in that column.
If...
|
|
5 |
143 |
|
|
|
|
17 |
245 |