|
|
|
|
3 |
142 |
|
|
|
|
2 |
150 |
|
|
General Excel question by
dolpandotcom
I have two columns in an excel sheet. One column shows 1 representing male
and 2 represnting female. In the second column I have marks scored by males
and...
( 1 2 3)
|
|
24 |
471 |
|
|
|
|
1 |
166 |
|
|
Multiple sear criteria by
Shah Alam[_2_]
Dear experts, in a work sheet i want four or five searching key cells with
subtotal.
suppose, i want to search with "StartDate and enddate" "Region",...
|
|
2 |
162 |
|
|
|
June 23rd, 2009 10:02 AM
by Sheeloo
|
1 |
150 |
|
|
|
June 23rd, 2009 07:17 AM
by Ron@Buy
|
1 |
149 |
|
|
SUMIF on a collection of individual cells by
Fred Holmes
Excel 2000 R1C1 reference notation
What is the syntax for the SUMIF function if the range to be summed is
a collection of indivicual cells - separated by...
|
|
9 |
263 |
|
|
counting values ignoring duplicates by
matt3542
Hi there,
I am trying to count the number of values in a column (A2:A217) ignoring
duplicated values. As an eg, applying this to the data below I would...
( 1 2)
|
June 23rd, 2009 03:10 AM
by Gary
|
12 |
312 |
|
|
CountIf question by
Stuck
I'm having an issue adding additional criteria to my formula. Here is my
current formula:
=COUNTIF(OFFSET($P$9,0,0,(COUNTA($A:$A))-2,1),$P3)
Column A has...
|
|
2 |
149 |
|
|
Rental yeild formula? by
Scoober
Hi,
Can someone help me with
=IF(AND(V24="",H24=""),"",SUM(V24/H24))
H24 = Property value
V24 = Rental return
W24 = Answer from equation
|
|
1 |
166 |
|
|
extract cusotmer name from test string by
Dinesh
I have long string of text that start with customer name. Immediately after
the text string, it populates either the schedule # (which start with "sch")
or...
|
|
5 |
160 |
|
|
Macros by
Noxzema
My office just upgraded to MS Office 2007 and I am having some problems with
the macros in Excel and Word. I have recorded them correctly and most of
them...
|
June 23rd, 2009 12:07 AM
by Noxzema
|
7 |
136 |
|
|
Autopopulating formulass horizontally? by
Leonhardtk
If I create the formula in A1:
=Worksheet!I4
I want to drag this to the right to copy the formula to other cells to the
right.
By default, A2 would...
|
|
4 |
140 |
|
|
Last "non-blank" value in a Row... by
Leonhardtk
I've found solutions for finding the last non-blank/non-zero value in a
column, but I couldn't figure out how to convert for a row:
Previously I had five...
|
|
2 |
112 |
|
|
desperate.. convert to number column... by
triple
I've tried this for couple hours and it's time to seek help now.
I have a big chunk of data importing from Klippel, a software that I believe
most people...
|
|
1 |
141 |
|
|
One workbook with 62 worksheets by
Colts41
I have an old Excel workbook that might have started out as a Lotus 123
workbook. The original creator of the workbook is long gone and forgotten.
My...
( 1 2)
|
June 22nd, 2009 10:38 PM
by Colts41
|
11 |
288 |
|
|
|
|
2 |
150 |
|
|
Sumif based on dates by
IlliniEric
I have a table that in one column lists a date and in another column a dollar
amount.
On the same sheet I have second table that in one column lists a date. ...
|
|
3 |
125 |
|
|
Formular Function by
Kanmi
Please can anybody explain this formula function =VLOOKUP($C14,'WPS Detail
Dates'!$B:$H,4,FALSE).
|
|
2 |
138 |