|
|
Match by
Zhead
In coloumn A some cells contain "Y" coloumn F also has cells that contain a
"Y" i would like to know how to sum which same rows in A and F contain "Y"
|
July 16th, 2009 06:54 PM
by Zhead
|
4 |
94 |
|
|
|
|
2 |
100 |
|
|
|
July 16th, 2009 06:41 PM
by Zhead
|
2 |
122 |
|
|
Hide Columns based on a cell value by
Tami
I have a spreadsheet that i want to hide columns a:H if the value in cell
L1="N" and unhide if theres a "Y". i'd prefer for the "macro" to be
real-time...
( 1 2)
|
|
10 |
198 |
|
|
text string by
Dinesh
I have a following formula to extact text string.
=IF(ISERROR(SEARCH("Blind Discount",A3)),"","Blind Discount")
I want to add one more criteria. If the text...
|
|
2 |
109 |
|
|
SUMIF FORMULA? by
Yoli
How do you state this as a formula? If A4:A8 is the number 23, then add only
the hours in B4:B8 that go with 23.
A B
23 1.5
15 1.0
17 1.0
12 ...
|
|
1 |
107 |
|
|
Search by
BadBoy
I have a workbook that has the first sheet named ‘totals’ and 20 other sheets
which are named as employee names.
The totals page sums all the numbers of...
|
July 16th, 2009 05:45 PM
by BadBoy
|
2 |
96 |
|
|
|
|
1 |
120 |
|
|
Calculation using a date by
KKH
I have worksheets where I have a formula to calculate the number of years and
months of service. I would like to use that date to calculate excess annual...
|
July 16th, 2009 02:46 PM
by KKH
|
5 |
87 |
|
|
Sorting on multiple worksheets in Excel by
T.W.
I need what I sort on page one to sort on the page I have it linked to and
carry over all information. It sorts on the linked page what is in a
specified...
|
July 16th, 2009 02:24 PM
by T.W.
|
0 |
101 |
|
|
Format of cells Changing on thier own by
GCC
Hi,
I use spreadsheets daily and for months now I have been having an issue
where all my cells that are formatted as 'General' change themselves to...
|
July 16th, 2009 02:09 PM
by GCC
|
0 |
128 |
|
|
|
|
2 |
104 |
|
|
SORT data containing formula by
Abrar
How to sort data containing formula For example
Column A Column B Column C
1 10 =B1-B5=4
2 9 =B2-B5=3
3 8 =B3-B5=2
4 7 =B4-B5=1
5 6 =B5-B5=0
Now if I sort in...
|
|
5 |
122 |
|
|
Date Range within a date range - try again by
MoonBlosm
I have a start and stop date. I want to see if any part of that start/stop
range falls within another date range.
Start: 9/15/09
End: 10/1/09
Date range...
|
July 16th, 2009 01:22 PM
by Luke M
|
2 |
114 |
|
|
Coping a Coloured cell by
The Message
I expect there is any easy answer to this but I am basically wanting to copy
the details of one worksheet into another. Using the basic '= Sheet 1! etc.'...
|
July 16th, 2009 01:20 PM
by John
|
4 |
103 |
|
|
Comparing worksheets & input data by
Caseymom
Help please....I am trying to compare data in 2 sheets to get the difference
from month to month
#1 (previous month's forecast)
Customer Part number ...
|
|
2 |
156 |
|
|
Covversion of date formats by
The Message
Is there a way to make date formats read 1/1/2009 when you converty them to
mmm-yy, instead of them staying at their original format.
Basically, if a cell...
|
|
2 |
101 |
|
|
OFFSET Function by
April
Hello,
I am linking the data from one sheet in my workbook to another, and
previously the way it was set up was to use the offset function. So, the
data in...
|
|
1 |
72 |
|
|
|
|
0 |
140 |
|
|
duplicate entries accross a workbook? by
Lianne
I currently have a workbook set up with various tabs, ideally id like to
find a way that when I am entering text, ie a surname in a cell it will
prompt me if...
|
|
1 |
89 |