|
|
Array formula with and/or statements by
Matthew[_4_]
Help please, this is more of a theoretical question.
Can you use and + or statements within an array formula.
if I have 3 columns a,b,&c and in these colums...
|
|
4 |
241 |
|
|
|
|
0 |
209 |
|
|
|
|
1 |
219 |
|
|
How do I stop the screen from jumping by
williamfedup
My screen keeps jumping; it nearly always returns to the top of the
screen.This happens in all programmes, emails and news items. I have a Dell
computer and...
|
|
2 |
243 |
|
|
combining data in multiple cells by
adkmayhem
is it possible to combine data from more than 2 cells without losing the data
from the cells? i know i can concatenate 2 cells, but what about data from 3...
|
May 15th, 2010 09:24 PM
by Mike H
|
1 |
217 |
|
|
pivot table space question by
rw9049
I have a pivot table with 3 months of data which takes up about 44M bytes.
I want to use this spreadsheet as a template to create a new spreadsheet
with a...
|
|
1 |
230 |
|
|
|
|
2 |
223 |
|
|
Multiple names by
freezerpang
I have a excel sheet full of my customers names and my staff names. would
like to sort out under each customer's company, shows who are the staffs are...
|
|
5 |
242 |
|
|
Formula Question by
Nikki
What formula could I use to pull 03275 from the below contents of a cell?
EA_1045_02949_03275 (John Doe)
|
|
7 |
280 |
|
|
Scheduling by
Matt
Hi
I'm trying to develop a system that will drag out a 16 week roster from a
monthly (annual)schedule.
I have seven worksheets,
One illustrates an...
|
May 16th, 2010 02:17 AM
by Matt
|
0 |
156 |
|
|
|
|
3 |
253 |
|
|
Excel Macro-enabled Workbook by
Salza
Hi all,
I share my Excel marksheet with many other teachers in the school. I
used Windows 7 and Excel 2007 and saved my file as Excel Macro-
enabled Workbook...
|
May 16th, 2010 03:57 AM
by Salza
|
2 |
343 |
|
|
Cracking VBAProject Password by
Lacty
Dear Group
Is it possible to crack a VBAProject password? If yes, are there any
add-in tools that do so?
Cheers
Lacty
|
|
1 |
238 |
|
|
|
|
2 |
242 |
|
|
Simple Form Entry not workin by
JohnH
I have been using a workbook for several years that takes advantage of the
ribbon based form that uses table headings as form labels. Stupidly, I merged
some...
|
May 16th, 2010 11:31 AM
by JohnH
|
0 |
216 |
|
|
excell by
tony
how do i copy a cell from one sheet to another
|
|
2 |
210 |
|
|
xlsx format by
Christelle
How do i open exel document saved i xlsx format?
I receive this format from one of my clients and must always ask them to
scan it and resend it as i can not...
|
|
1 |
157 |
|
|
Lookup for oldest date among different dates by
khaled shaheen
Hi all,
I badly need your help in the below formula
Example:
Structure : Account includes Sub-accounts and each sub-account includes dials
Formula : Account...
|
|
3 |
223 |
|
|
Look for Oldest date among different dates by
khaled shaheen
Hi all,
I badly need your help in the below formula
Example:
Structure : Account includes Sub-accounts and each sub-account includes dials
Formula : Account...
|
|
1 |
179 |
|
|
Excel Macro by
vikcool
I want a macro that will minimize the excel window and keep on refreshing my
screen by pressing F5 and and keyboard press will terminate the excel file.
|
|
0 |
180 |