|
|
Restrict data entry to specified cells by
ajsguinness
Hi, I'd like to be able to restrict new data entry to specified cells in a
workbook. I'd like a method to say where data should be added, and then for
that...
|
|
2 |
128 |
|
|
Problem with Using "Multiply by 1" by
A
I am having an issue that is driving me crazy. I have always had a trick of
converting numbers in cells using the formula "*1". Example, if you have a
zip...
|
June 11th, 2009 03:27 PM
by A
|
5 |
160 |
|
|
IF or VLOOKUP - help please ..... by
Eán[_2_]
I have a coloum of dates dd/mm/yyyy and would like to return in a separate
coloum the month eg, dd/04/yyyy = 'APRIL' can you let me know what formula I
would...
|
|
4 |
100 |
|
|
If or VLOOKUP by
Eán[_2_]
Hi
I have a coloum of dates dd/mm/yyyy but would like in a separate coloum to
show only the month - how would I write a formula to return "April" for all...
|
|
4 |
113 |
|
|
|
June 11th, 2009 01:23 PM
by Roman
|
0 |
100 |
|
|
|
|
3 |
114 |
|
|
Give me a Function by
Fareez
Dear Friends
Lokking at folowing chart ,please help me solve my...
|
June 11th, 2009 01:09 PM
by Eduardo
|
1 |
102 |
|
|
use sumif / Sumproduct for year data by
Chris26
Hi
I have a set of daily data (total rainfall) for100 years.
What would be the easiest way to extract the total rainfall for:-
January Year 2000-2100,...
|
|
5 |
100 |
|
|
|
|
2 |
110 |
|
|
Counting in columns by
Deb
Hi all - I have a column which can include a date (eg format 10 June 2009)
and I want to be able to count the total number of times a date appears in
that...
|
|
5 |
97 |
|
|
|
|
1 |
117 |
|
|
|
|
7 |
79 |
|
|
excel by
Beautiful
how can a formula reference data containd in several sheets or books?
|
June 11th, 2009 04:07 AM
by JLatham
|
3 |
83 |
|
|
need lookup help by
Mike Coleman
I need to lookup a value in a range based on a cell then return the value of
the 1st row of the column the found cell is in. here's my...
|
|
3 |
86 |
|
|
|
|
0 |
100 |
|
|
default border color by
DeAna
On a few of my worksheets I save and use again I am unable to select a border
without having to change “color” from “automatic” to “black”. How...
|
June 11th, 2009 12:19 AM
by DeAna
|
2 |
81 |
|
|
excel by
bbillybax
I have created three workbooks that have a series of links/formula that
update sheets/cells within the other workbooks on my desktop computer. When i...
|
|
1 |
72 |
|
|
how do i count using two criteria by
IHF
I have varying dates in D:D and different names in F:F such as
5/1/09 splmd2
6/1/09 armd4b
12/01/09 carbdp
the names repeat as wil some of the dates.
I...
|
|
3 |
113 |
|
|
Bin Array--Frequency by
Excel User
I want to set a bin array for only five numbers. I have entered the results
of a survey asks people to answer on a scale of 1 to 5. I want to find out
how...
|
|
1 |
99 |
|
|
Count w/ multiple variables & text values by
king60611
I'm trying to get a count of how many times a value appears in either of 2
columns vs. a set column. In plain English, how many times does Bonds appear
as...
|
|
5 |
80 |