Re: If And Help?
Wed, 20 Aug 2008 07:35:11 -0700 (PDT)
I have one more question. I'm not sure if this can be written into
the array, or if I would maybe have to do a second column and do some
comparison.
The final array worked PERFECT! In the example, I changed column M to
DOS. In my project, I added *(info) to it to add it as a criteria in
the formula, won't d ...
|
DATA FOLLOWING SORTS
Wed, 20 Aug 2008 07:27:01 -0700
I have a multi-page workbook. The first page containes the master client data
in 5 columns. The other 12 pages (one for each month) containes both the
master data (transfered using the following formula; =IF('MASTER
LIST'!B3<>"",'MASTER LIST'!B3,"") ). There are then additional columns where
data is entered ...
|
macros
Wed, 20 Aug 2008 07:23:03 -0700
is it possible to create a macro that can take into account the number of
columns containing data? in a workbook i have a tab for each month of the
year for 2001-2008, and because each month has varying numbers of days in it,
the number of iterations i need to do differs, and the number of columns for
itera ...
|
Moving columns with formulas gives #REF!
Wed, 20 Aug 2008 07:12:12 -0700
I am trying to keep my formulas with the cells they are associated with even
if the column location is moved so that I don't get a #REF! error from the
other sheets which house the formula. I have tried Protect but I cannot add
any information into those cells unless I unProtect. Other people use this
worksh ...
|
Grouping - + and - not showing attop of sheet.
Wed, 20 Aug 2008 06:38:21 -0700
Hi,
I am grouping colums in a worksheet. I have three lots of groups - two of
them are fine and show a minus at the end of the group anda plus if I have
hidden the group. However the third (which is in the middle but had the same
problem when it was the second group of two) shows the lines but no minus
...
|
Invalid LOOKUP Function Results
Wed, 20 Aug 2008 06:35:01 -0700
The notes for LOOKUP function indicate the values in a row must be sorted or
invalid results will occur. Is there a way to get around this? How can I
use the LOOKUP function or any other lookup function to correctly return
results on an unsorted row of data? Below is an example of what I need to
accomplis ...
|
Using the same macro on different sheets
Wed, 20 Aug 2008 06:19:02 -0700
I have a number of worksheets that employ the same macro and on occasions I
need to update the information with the macro. To stop having to repeat the
information a number of times I want to store all the macros in one sheet so
that I only have to update the information once. However I don't want the
shee ...
|
|
|
Is there a function or format to remove 'oz' from '12oz' in Excel?
Wed, 20 Aug 2008 06:03:01 -0700
I'm trying to see if there is a way to take another user's input of "12oz",
say in cell A1, and convert it to the numeric value of just '12' in another
cell, say B1, so I can use the numeric value for calculations? ...
|
How can I rearrange worksheets?
Wed, 20 Aug 2008 05:36:01 -0700
I'd like to rearrange worksheets within a workbook so that they appear in
alphabetical order. ...
|
can't open drawing function
Wed, 20 Aug 2008 05:29:01 -0700
Please show me how to open drawing function on my Excel, the Drawing on View
has been marked ...
|
