|
|
FIND IF A CELL CONTAINS TEXT by
Tree
We need to have a formula that can find a text in a cell and if text is in
the cell, return that text, otherwise, leave the cell blank.
|
April 17th, 2009 04:41 PM
by Tree
|
3 |
83 |
|
|
Apply Global Formula by
Donna K.
I want to take a range of numbers in separate cells and divide them all by 2
and have the results replace the numbers listed. Is this possible in Excel?
|
|
1 |
93 |
|
|
IF Formulas by
Clara
I have a column for every month (12) and I have criteria that must be met all
months in order for annual points to be awarded. How can I tell cell P5 that...
|
|
2 |
71 |
|
|
|
April 17th, 2009 04:08 PM
by Mike
|
3 |
94 |
|
|
|
|
4 |
91 |
|
|
Sumproduct Question by
ShagNasty
I have a spreadsheet with 1-5k rows (and growing) with A-I columns -- Cols
A-G text fields, Cols H-I number fields. H&I are YTD totals. Can
SUMPRODUCT()...
|
|
2 |
79 |
|
|
Macro by
Lois
Hi
i have the following macro set up & linked to a customised button on my
toolbar:
Sub Ken_Full_Screen_View()
'
' Ken_View Macro
' Macro recorded 01/04/2009...
|
April 17th, 2009 01:54 PM
by Lois
|
3 |
66 |
|
|
|
|
1 |
78 |
|
|
Subtracting Military Time by
Randy
I have a timesheet that I enter in and out times for workers. This is all in
the same cell. Example: 1300-1515. In the next row i enter how many hours it...
|
|
4 |
163 |
|
|
Format single character by
alex
Hello All,
Using Excel '07...
Is there a way to use conditional formatting (or something else) to
color a single character in a string.
E.g., change the...
|
|
4 |
85 |
|
|
normalize score by
austuni
I work in exam department and there are several people who marks the same
question. In order to be fair on the candidates, I would like to normalize
the...
|
|
1 |
88 |
|
|
matching Data by
Hardeep kanwar
Hi! Experts
I have 2 sheets in a workbook.Sheet1 is a master sheet with Customer code
and there Sale.And Sheet2 is the sheet which has only Customer...
|
|
2 |
71 |
|
|
|
April 17th, 2009 04:15 AM
by nikko
|
3 |
507 |
|
|
Pickup the content of Cells ( in formula) by
Frank Situmorang[_3_]
Hello,
My VBA below is to extract the information from each individual workbook and
cosolidate it
But now I want to take just the content of the cells (...
|
|
0 |
69 |
|
|
How to convert PDF tables into Excel?? by
Pedro Sanchez IV
I have a HUGE PDF with many collums and rows of data that I want in
Excel. Is there a way to convert this to XLS format?
Software or setting?
Thanks
|
|
2 |
93 |
|
|
SUMIFS and dates by
JLR-Mart
I have some data and wish to use the sumifs function to add up sums when a
criteria is true and the date is less than a month ago. I have tried using
date-30...
|
|
3 |
54 |
|
|
Advanced Criteria for SUMIF by
Roberto Villa Real
I need to sum some values in Column C, but with 2 criterias (one criteria for
column A and another criteria for column B).
Exemple:
I need the SUM of values...
|
|
4 |
97 |
|
|
Slicing Data (Alternative to SUMIFS) by
Marcelo[_2_]
I’m having some trouble with Excel. In essence, I’m trying to perform
SUMIFS without using the formula (due to backwards incompatibility
with 2003). Below I...
|
|
2 |
86 |
|
|
|
|
3 |
82 |
|
|
Formula Help by
CHerzog
Here is the function I am using.
=IF(C3=0,NETWORKDAYS(A3,Holidays!A1,Holidays!A3:A30),NETWORKDAYS(A3,C3,Holidays!A3:A30))
I have two questions first is there a...
|
|
1 |
51 |