|
|
Offset 2nd ref. by
houAstros1989
A B
ONE 1
TWO 2
THREE 3
ONE 4
Is there a way I can use the offset to look up a duplicate reference? To
where I ref ONE...
|
|
3 |
101 |
|
|
Not to inlcude zero in COUNT by
enna49
Hi
Please can you help with this problem.
I need a count in a column with amounts. The problem being I do require to
count the Credits and Debits, but NOT...
|
|
9 |
88 |
|
|
Data validation - restrict duplicate value by
Michelle
Hi!
How to set data validation function (in column B) to restrict user from
entering same invoice number from same supplier?
Column A: Supplier
Column B:...
|
|
8 |
111 |
|
|
Summary by Months by
Furby73
I am trying to make a summary of deliveries on a monthly basis
A B
1 1/11/09 20.19
2 ...
|
|
2 |
108 |
|
|
totaling data from a drop down list by
cp
Using Excel 2007, I have created a survey and some cells have drop down list.
For example, the responses include items such as private practice, physician...
|
December 1st, 2009 05:50 AM
by cp
|
2 |
149 |
|
|
|
|
2 |
104 |
|
|
|
|
2 |
128 |
|
|
Current Month with real date by
Keyrookie[_33_]
Hey all,
I'm trying to have a cell always reflect the current month and year.
I'm sure it's a simple formula but I need some help. I'm wanting this
formula...
|
|
2 |
101 |
|
|
|
|
1 |
105 |
|
|
attendance with sorting by
cathyong
hi. Needs help. I have an attendance workbook with the 400 names listed as
present, absent or excused. Our office needs to see at a glance who are
absent for...
|
|
4 |
145 |
|
|
summing adjacent data in a worksheet by
Suzie
I have a column of data and I need to sum the values in adjacent cells when
they are bounded before and after by cells that contain a value of 0. Then I
need...
|
December 1st, 2009 02:17 AM
by Pete_UK
|
3 |
131 |
|
|
|
|
0 |
113 |
|
|
Room Occupied Checker Formula Help by
Dax Arroway
I have a worksheet with Headers: A:Name, B:StartDate, C:Room#, and D:EndDate.
I'm looking for a formula that will check the availability of a room based
on...
|
|
5 |
90 |
|
|
Validation list based on criteria by
Gotroots
Hi
I want to create a data validation list based on certain conditions.
Let me try to explain by example.
A1 = oranges B1 = oranges
A2 = apples B2 = no...
|
November 30th, 2009 11:22 PM
by Gotroots
|
0 |
80 |
|
|
|
|
2 |
96 |
|
|
SumProduct - With Or Function by
Benjamin
=SUMPRODUCT(--(A1:A24="Tom"),--(B1:B24="May"),--(C1:C24))
First Array (Names) & Second Array (Months) and Third Array is numbers to
sum up.
Now I can easily...
|
|
3 |
95 |
|
|
Printing issues by
DJ
I can print some pages within an Excell workbook, but not all of them. I am
getting a security warning.
--
DJ
|
November 30th, 2009 09:34 PM
by DJ
|
0 |
84 |
|
|
PRINTING ISSUES by
DJ
I am having trouble with one page not printing within a workbook. I can send
some pages to the printer and they will print but one page in particular will...
|
November 30th, 2009 09:32 PM
by DJ
|
0 |
95 |
|
|
|
November 30th, 2009 09:06 PM
by Luke M
|
2 |
142 |
|
|
Comparing 2 worksheets in Excel 2007 by
Sue
I am trying to compare 2 worksheets in a large workbook. One sheet is named
1st Proposed HMIs. The other is named 2nd Proposed HMIs. Both spreadsheets
are...
|
|
1 |
132 |