|
|
copy drag financial years by
Ben
Hi i use financial years a lot and was wondering if there was a simple way to
copy, paste/drag the years down a column so they expand? For example when i...
|
|
4 |
200 |
|
|
IF Function with Dates by
Bagia
Hello,
I hope someone can help me. I would like to create an IF function for dates
in my worksheet. I have a Start Date column and End Date column. If the...
|
March 8th, 2010 06:45 AM
by Vijay
|
9 |
154 |
|
|
cell reference by
Peter
I have several sheets in a work book that need a range of cells deleted
before inputting more data. The range to delete is A15 to D540. Then I need
it to go...
|
|
2 |
154 |
|
|
Data to another sheet by
nandu1256
I have a table for marks of students. I have their ranking in the last col.
In the next sheet I have another table in which I want the names of the first...
|
|
1 |
111 |
|
|
Vacation Tracking formula by
Rehab brain
I am trying get my formula for hours accured in a vacation tracker
spreadsheet to show up as 60 minutes in an hour instead of 100...
|
|
2 |
121 |
|
|
|
|
11 |
215 |
|
|
#DIV/O! by
painter50
I get this #DIV/O! when I divide two cell that both total 0.
These cell will not always be used in the spreadsheet. Is there any way to
show the total of...
|
|
5 |
140 |
|
|
Please help by
cccc[_2_]
I am really sorry I have left msg here a week ago but I can not find it now.
I found out what I need to do.
Here is example
A B C ...
|
|
2 |
95 |
|
|
vlookup 3 sheets by
Ben
Hi,
I have 3 worksheets and want to combine a vlookup to find the sum of the
unique criteria. I can get it to work with 2 spreadsheets but not 3.
The...
|
|
1 |
125 |
|
|
|
March 7th, 2010 09:09 PM
by Mike H
|
5 |
117 |
|
|
|
March 7th, 2010 08:47 PM
by dave
|
6 |
102 |
|
|
vlookup multiple data by
Art
Is it possible to have a cell contain two pieces of informaton (e.g., A1 =
"Me, You"), a vlookup statement to look for each pece of informaton in that
cell...
( 1 2)
|
|
11 |
189 |
|
|
Matching function or no match by
Donna[_5_]
I am using this formula to compare 2 list to see which numbers are not
included in both column A and Col C. The formula I am using below pulls out
the ones...
|
|
3 |
124 |
|
|
SUM all Instances Q by
Seanie
How could I achieve the following via formula
I want to add up all the instances that certain numbers appear in Col
B with their corresponding values in COL D...
( 1 2)
|
|
15 |
200 |
|
|
What does " mean in excel by
Jane
When working in excel and doing my labs, I am often told to use " " in my
formulas but I don't know what " " stand for and the ! is also used, can
someone...
|
March 7th, 2010 01:58 PM
by JLatham
|
5 |
123 |
|
|
|
March 7th, 2010 01:52 PM
by JLatham
|
1 |
141 |
|
|
protection indicator by
nader
Hi
I write two question a bout this but no answer
pleas, if possible I want a function that if worksheet protected write a
text in a cell
like "protected" if...
|
|
1 |
105 |
|
|
|
|
1 |
118 |
|
|
|
|
1 |
98 |
|
|
Sumproduct and dynamic data by
jtfalk
Good afternoon,
I have an Excel 2007 workbook that I am having issues with. I have set up a
dynamic graph that allows me to put in a start and finish date...
|
|
1 |
111 |