|
|
Changing default font in Excel 2003
I'm using Excel 2003 on XP Pro.
I want to change the default font so that all new text will be in the
specified default.
I went to Tools > Options > General > Standard Font and set the
desired font. I closed Excel and reopened it, but new text does not
use the new default.
What am I missing?
|
6/6/2010 5:28:12 PM
|
0
|
info...@mindspring.com
|
Can anyone provide me the fomula ?
Hi, I need the fomula for below scenario,
A4 = start date (exp.= 01.03.2007)
B4 = end date (exp. = 31.05.2012)
D1 = 01.04.2007
D2= 31.03.2008
E1= 01.04.2008
E2= 31.03.2012
F1 = >31.03.2012
at D4 = fomula to get the answer of days which fall between A4 & B4?
(365days)
D4 = fomula to get the answer ? (1460days)
G4 - total period which date fall>D1 (answer shown in month and days. Ans =
5 yrs & 2 mths.
Any solution ? Thanks.
Thanks.
|
6/6/2010 4:10:55 PM
|
1
|
=?Utf-8?B?VFE=?= <...@discussions.microsoft.com>
|
Formula
I'm in need of a formula in C1 that gives me the value of A1 divided into
60 if B1 is empty, however if B1 has a value (not zero) then C1=B1/60.
THANKS.
|
6/6/2010 3:36:31 PM
|
4
|
=?Utf-8?B?VHJhaW5lZQ==?= <Trai...@discussions.microsoft.com>
|
Excel 2010
I have installed Excell 2010 and now when I open the program, it opening all
the excels files. It also is trying to open the other files like .doc in
that same directory. How can I stop this from happening.
|
6/6/2010 3:04:38 PM
|
1
|
=?Utf-8?B?Q29tcHV0ZXJMYWR5MTQz?= <ComputerLady...@discussions.microsoft.com>
|
Pivot Table Formulas
I need to create a variance formula for the data selected in a pivot table.
My problem is that the data is coming in from one column and I don't know how
to distinquish the data by year in the formula. I have put a small selection
of my data below. I would like to show the variance between 2009 and 2010
for all months selected in the pivot table.
WDS# EA UOM PRICE EXTENDED Month Year
0623864 6 EA 9.73 58.38 Jan 2010
4286879 2 EA 2.784 5.568 Jan 2010
0623864 9 EA 9.73 87.57 Feb 2010
4286879 1 EA 2.784 2.784 Feb 2010
3514738 1 EA 13.72 13.72 Feb 2010
0623864 5 EA 7.85 39.25 J
|
6/6/2010 2:17:48 PM
|
0
|
=?Utf-8?B?QUo=?= <ihavequesti...@microsoft.com>
|
blank cells having no value
Hi,
though this is Steve's account it is his wife Val writing with my problem.
Back in the old days of DOS there was a function which allowed you to set all
blank cells as blank - that is = not having a value of Zero.
I am working on Excel 2003 at home and 2007 at work so am at the moment
somewhat confused and cannot find that facility on either system.
What I am trying to do is:
I have two cells one E6 representing "goals For" and another F6 representing
"goals against"
I have the following simple formula. =IF(e6>F6,3,IF(e6=F6,1,0))
this works fine when the figures are in an
|
6/6/2010 12:46:34 PM
|
2
|
Steve Hayes <hayes...@telkomsa.net>
|
|
|
Help! how to cross - data with excel??
Hi, I'm required to present some info at my work, using two excel files. This
is the task:
File 1, has ID numbers in column A, and column B is blank.
File 2, has ID numbers in column C and column D has the date the person
joined the company
File 1 es a select grop of people (about 2500), whereas File 2 is the
general database (about 30thou)
They're asking me to match the data, in order to end up with the
coresponding date they joined the company in column B on File 1 (obtained
from column D on file 2), how to do it? taking in account that File 1 is
outdated and some peo
|
6/6/2010 8:13:07 AM
|
3
|
=?Utf-8?B?Z2xvcmlhbWFy?= <gloria...@discussions.microsoft.com>
|
How to determine the value?
Does anyone have any suggestions on how to determine the value within lists?
For example,
[1]
There is a given date in cell A1, 06-Jun without concerning year, I would
like to determine the value within column C, it should return 6 in cell A2,
because 06-Jun is equal to or larger than 05-Jun and less than 21-Jun.
[2]
There is a given date in cell A1, 05-Jun without concerning year, I would
like to determine the value within column C, it should return 6 in cell A2,
because 05-Jun is equal to or larger than 05-Jun and less than 21-Jun.
[3]
There is a given date in cell A1, 07-Mar
|
6/6/2010 5:17:38 AM
|
2
|
=?Utf-8?B?RXJpYw==?= <E...@discussions.microsoft.com>
|
Find certain "Text" in a specific coloum, add corres. values
Hi,
I have two coloums. One has text and the other has Values.
I need excel to search through a whole coloum, and summerize the results.
My coloums look like as follows
A 2
B 5
A 2
The results should look like
A 4
B 2
How can I achieve this?
Thanks
|
6/6/2010 3:58:29 AM
|
2
|
=?Utf-8?B?QXJ1bSBLaGFu?= <Arum K...@discussions.microsoft.com>
|
Converting XLS file to QIF or to OFX
How do I safely and securely convert an excel file (xls) to a QIF or OFX file?
|
6/6/2010 3:18:20 AM
|
1
|
=?Utf-8?B?ZHJlYW1jaGFzZXI=?= <dreamcha...@discussions.microsoft.com>
|
Copying rows of data into new worksheet but placing data into colu
I have a spreadsheet which contains 3375 records (Excel 2007). My quandry is
the following:
I need to reformat the rows into columns for each Dealer (starting a new row
for the next Dealer).
CURRENT SPREADSHEET:
DEALER LOCATION VOLUME AMOUNT
123 Anytown, USA 155 $24,100
123 Hometown USA 145 $25,000
123 Thistown USA 455 $56,000
123 Our town USA 687 $68,000
123 Their Town USA 767 $989,000
245 Anytown, USA 155 $24,100
245 Hometown USA 145 $25,000
245 Thistown USA 455 $56,000
245 Our town USA 687 $68,000
245 Their Town USA 767 $989,000
818 Anyt
|
6/6/2010 3:01:24 AM
|
1
|
=?Utf-8?B?VGhhbGFyY3Rvcw==?= <Thalarc...@discussions.microsoft.com>
|
how do we get 2003 .xlb toolbars and custom macros to show in 07
I have custom macros that are saved in an .xls file under the XLStart/ folder
in Excel 2003. These macros are referenced by an Excel11.xlb file that holds
the toolbars. All of these automatically open because they are under the
XLStart/ folder. How do I get them into Excel 2007 so they will open
automatically and how can I get the custom toolbar file to show up.
|
6/5/2010 11:23:04 PM
|
1
|
=?Utf-8?B?YmlnZGVhbA==?= <bigd...@discussions.microsoft.com>
|
Nested AND OR expressions
HI
I need to express something in VBA , and am having trouble with it.
I need to say this :
IF E1 CONTAINS "1bx" OR "2bx" OR "3bx" AND J1 =11 THEN PUT 1 , OTHERWISE
PUT J1
Can someone assist with some code to make this happen , please?
Grateful for any help.
Best Wishes
|
6/5/2010 6:44:24 PM
|
7
|
Colin Hayes <Co...@chayes.demon.co.uk>
|
formula for moving information from one sheet to another sheet
I have information in column A of a task sheet. The information goes from row
1 thru 35. Column B is where I place a "x" to say the task need to be
completed. Is there a formula that can check each row in column B to see if
the "x" exist, until it reaches the end. If the "x" exist in any of the rows,
then move the information into a blank sheet called assignment. Example
B1,B3,B4,B20 all have a "x" in the field, now I need to move the information
in A1, A3, A4, A20 to row1 thru 4 of a blank work sheet. Is this possible.
|
6/5/2010 5:59:22 PM
|
4
|
=?Utf-8?B?UHV6emxlZA==?= <Puzz...@discussions.microsoft.com>
|
can't "undo" to original document
I accidentally hit Ctrl S and saved a document. Unfortunately, I meant to do
a Save As, instead. Is there anyway to recover my original document? I
haven't closed the file, yet. I know in Word you can "undo" multiple actions.
Is it possible to do that in Excel, also?
|
6/5/2010 2:40:06 PM
|
2
|
=?Utf-8?B?bG92ZXRvc2hvcDExMjg=?= <lovetoshop1...@discussions.microsoft.com>
|
Formula Questions
Having trouble with formulas. I have two work sheets. Work sheet1 is a work
order. Work sheet2 is what needs to be done by a certain date. What I need to
do is type in a date in work sheet 1. At that point the date has to find the
date on work sheet2. Once the date is found the formula needs to check if
anything is in b2 in work sheet2, and if it is, move what is in a2 into work
sheet 1. Highly confused. I have never attempted this before. Any help would
be highly appreciated.
|
6/5/2010 2:40:05 PM
|
6
|
=?Utf-8?B?UHV6emxlZA==?= <Puzz...@discussions.microsoft.com>
|
Re: Sorting a list of numbers
Option Explicit
Sub SASLineEmUP()
Dim lr As Long
Dim i As Long
Dim lc As Long
Application.ScreenUpdating = False
Columns(1).Clear
lr = Cells.Find("*", Cells(Rows.Count, Columns.Count) _
, , , xlByRows, xlPrevious).Row
For i = 2 To lr
lr = Cells(Rows.Count, 1).End(xlUp).Row + 1
lc = Cells(i, Columns.Count).End(xlToLeft).Column
Cells(i, 2).Resize(, lc).Copy 'Cells(lr, 1)
Cells(lr, 1).PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=True
Next i
Columns(1).Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlGuess, _
OrderCusto
|
6/5/2010 2:05:16 PM
|
0
|
"Don Guillett" <dguille...@gmail.com>
|
Re: Consolidating data
Sent OP this
Option Explicit
Sub SAS_MakeTable()
Dim lr As Long
Dim c As Range
Dim mm As Double
Dim mr As Long
Dim mc As Double
Application.ScreenUpdating = False
lr = Cells(Rows.Count, "b").End(xlUp).Row
Range("f3:r" & lr).ClearContents
Range("B2:B" & lr).AdvancedFilter Action:=xlFilterCopy, _
CopyToRange:=Range("F2"), Unique:=True
For Each c In Range("b4:b" & lr)
mm = Month(c.Offset(, 1))
mr = Columns(6).Find(What:=c, LookIn:=xlValues, LookAt:=xlWhole, _
SearchOrder:=xlByRows, SearchDirection:=xlNext).Row
'MsgBox mr
mc = Rows(2).Find(What:=mm, LookIn:=xlValues, Lo
|
6/5/2010 2:01:35 PM
|
0
|
"Don Guillett" <dguille...@gmail.com>
|
How many cells can a correlation function cover?
What is the Maximum number of cells that correlation function in Excel can
calculate?
|
6/5/2010 1:37:55 PM
|
0
|
=?Utf-8?B?Q29ycmVs?= <Cor...@discussions.microsoft.com>
|
Excel chart - great variation in values
I am trying to create a column or line chart where a value for 9 variables
are given for each month of the year. My problem is that the values are
mostly between 0 and 40. I have one value though that is 280 and this makes
the chart not really legible.
Is there any way to have the scale on the y-axis showing 5 as major unit up
until 50 and after that 50 or 100?
|
6/5/2010 10:58:02 AM
|
1
|
=?Utf-8?B?QW5u?= <...@discussions.microsoft.com>
|
Where is the number lock key on my HP Pavilion zv 6000???????????
See subject question........
|
6/5/2010 7:14:32 AM
|
2
|
=?Utf-8?B?ZGVhY29uZ2FyeQ==?= <deacong...@discussions.microsoft.com>
|
Copy parts of a number
If I have a cell with a digit 123,4567 - how can I copy the content of the
cell to another cell with only two digits after the comma. In other words - I
only want 123,45 to appear in the new cell.
Is there any way to use a "round off" functionality?
|
6/5/2010 7:14:26 AM
|
2
|
=?Utf-8?B?R2VuaUU=?= <Ge...@discussions.microsoft.com>
|
No formulas Work
For some reason none of hte formula in a spreadsheet are working. The
spreadsheet is on a netowrk and when others open it, the formulas work. When
I open the spreadsheet on a simple addition formula I get the #value
appearing in the cell. Is there a setting in excel that I need to change.
|
6/5/2010 4:04:36 AM
|
3
|
=?Utf-8?B?QkcgTWFyaw==?= <BGM...@discussions.microsoft.com>
|
Free Ebay consignment spreadsheet?
Does anyone have a free Ebay consignment tracking spreadsheet I could have?
|
6/5/2010 2:38:27 AM
|
1
|
=?Utf-8?B?U3RldmU=?= <St...@discussions.microsoft.com>
|
Multiple Conditions with Gradients
Hi, I'm having some trouble with conditional formatting. I'm hoping someone
will know, is it possible to have multiple conditions for the same set of
cells that use the gradient function? Basically, what I want to do is set up
a gradient for cells with values 10 to 30, a separate gradient for cells with
values 4 to 10, one for -4 to 4, one for -10 to -4, and one -30 to -10. I
don't want one continuous gradient, but 5 separate gradient with different
colors. This seems like it should be possible, but neither excel 2007 or
excel 2010 beta seem to be able to do it. It tries to m
|
6/5/2010 2:34:32 AM
|
0
|
=?Utf-8?B?S3VydA==?= <K...@discussions.microsoft.com>
|
How to determine the values?
Does anyone have any suggestions on how to determine the value?
For example,
Under following columns:
[A] [B] [C] [D]
1 174 198 222
7 180 204 228
9 182 206 230
A given number is 204 in cell E1, I would like to determine the value under
column A, which should return 7, because 204 is under the same row.
A given number is 174 in cell E1, I would like to determine the value under
column A, which should return 1, because 174 is under the same row.
Does anyone have any suggestions on how to do it in excel?
Thanks in advance for any suggestions
Eric
|
6/5/2010 2:01:27 AM
|
1
|
=?Utf-8?B?RXJpYw==?= <E...@discussions.microsoft.com>
|
Navigation buttons in Excel 2007
The navigation buttons in Excel 2007 do not seem to work the way they did in
Excel 2003. I have tried them on multiple computers. I know about
right-clicking to get a list of worksheets, but I want to left click on a
navigation button and have it move to the appropriate sheet (forward,
backward, first, last). Has this changed?
Thanks for your assistance.
--
I Teach
|
6/4/2010 11:46:51 PM
|
1
|
=?Utf-8?B?SSBUZWFjaA==?= <Ite...@discussions.microsoft.com>
|
Command Button - Shrinking Font
I have a new 200" landscape monitor that replaced my traditional 17". The
resolution automaticallyl resized on connection and looks fine.
However, when I click a command button, the font size shrinks. It stays at
that level until I click a different button and then return to the original
button, when it shrinks again. It will eventually become invisible to the
naked eye.
Internet research seems to indicate this is a bug. A standard Excel button
accessed from View>Toolbars>Forms (not a VBA command button accessed from
Control Toolbox) seems to maintain its font size, but I
|
6/4/2010 10:53:41 PM
|
2
|
=?Utf-8?B?b3BpZWFuZHk=?= <opiea...@discussions.microsoft.com>
|
Set row height, but allow wrap text
I want to set the row height of me spreadsheet to allow a little "buffer"
between rows. But I have a couple rows in which there is a greater amount of
data (text) than the column width allows. I want to allow that row to grow
and wrap the text. It seems like I have to do one or the other: (1) set the
row height, which then means the wrapped text doesn't fit in the height of
the row, or (2) do autofit and have the wrapped text look good, but not have
the "buffer" I want in the row spacing in general. How can I do this? I
looked for a way to set cell margins that would add the buf
|
6/4/2010 10:01:38 PM
|
0
|
=?Utf-8?B?S01N?= <...@discussions.microsoft.com>
|
formula question
Hello,
I am trying to write a formula that first looksup a number and then runs a
calculation from that number. Here is a look at what I have so far:
First Part:
=IF(ISNA(VLOOKUP($A5,'907100'!$G:$K,5,FALSE)),"",(VLOOKUP($A5,'907100'!$G:$K,5,FALSE)))
Second Part: IF(ISERROR(B5/T$2),"",(B5/T$2))
B5 is where I am writing the formula... I am not sure how to combine them
into one formula.
Thank you,
|
6/4/2010 9:46:14 PM
|
2
|
=?Utf-8?B?dG9t?= <...@discussions.microsoft.com>
|
Consolidating data
Hi,
I need to consolidate some lines of data in a 19K line spreadsheet and then
change its basic format.
I have 3 columns of data: ID# | date | volume
My problem is that while the data is mostly monthly, there are some months
with two entries and I need to consolidate them into a single monthly value.
I don't care which of the dates is used as long as the month and year are
correct. That's the 'consolidate' part.
Then I need to convert the 19,000 row spreadsheet to a big grid with the
meters listed in the left row and the month/year at the top of each column
with
|
6/4/2010 9:13:18 PM
|
1
|
=?Utf-8?B?QkRU?= <...@discussions.microsoft.com>
|
Printing in Color
Ever since my printer has been networked by the cells in my excel if filled
with color do not print in color. The print preview displays the various
colors but the print is black, grey and other shades of grey. However, if
there is a picture displayed on the sheet. The picture prints in all the
colors. Please help! this is frustrating!
|
6/4/2010 9:03:01 PM
|
0
|
=?Utf-8?B?RmlsbCBDb2xvdXIgZm9yIERpZmZlcmVudCBkYXRh?= <FillColourforDifferentd...@discussions.microso
|
Separate AM/PM from time.
In column B I have 1000 time entries with the following format. 9:30AM,
10:30PM. I would like to move the AM or Pm into a new column. I've tried
"fixed width", also tried changing the format to put a space between the time
and the AM/PM, but nothing has worked.
Any suggestions?
Don
|
6/4/2010 8:18:22 PM
|
2
|
=?Utf-8?B?Y3VhcnRldHRv?= <cuarte...@discussions.microsoft.com>
|
Move rows into columns
I have an Excel sheet that has 8000+ rows that include contact information.
I'd like to move them from all of those rows into 6 columns. Currently it
lookzs like:
name
title
company
address
city/state/zip
phone
....
....
....
And I'd like to create a formula to move it to 6 columns that look like this:
name title company address city/state/zip phone
I'm still an Excel novice but would appreciate any suggestions you might
have. Thanks!
|
6/4/2010 7:34:38 PM
|
3
|
=?Utf-8?B?VFI1Mw==?= <T...@discussions.microsoft.com>
|
Macro/VB coding question
I want a macro to work for a worksheet name which will always be the same
directory and file name but the data inside worksheet will periodically
change - increase in rows/decrease in rows. # of Columns/Column names will
not change. I'm trying to filter for a non-changing set of info, then delete
the results.
Here's what I get if I record my current run:
Workbooks.Open Filename:= _
"***Directory of location and file name here***"
Rows("1:1").Select
Selection.AutoFilter
ActiveSheet.Range("$A$1:$S$746").AutoFilter Field:=5,
Criteria1:=Array("10" _
|
6/4/2010 7:32:59 PM
|
3
|
=?Utf-8?B?bWVsRXhjZWwyMDA3?= <melExcel2...@discussions.microsoft.com>
|
Conditonal Format based on two different criteria
Hi all. In column A I have a list of a bunch of different test names. In
column D we have times associate with each test. I would like to make a
conditional format that will check column A for a specific test name and then
check to see if the time in column D meets a certain requirement. This is
what I have tried but can't seem to get it to work.
=AND($A$4="CBC",D$4$>.0416)
Anyone got any ideas?
|
6/4/2010 7:26:22 PM
|
1
|
=?Utf-8?B?Q2hhZF9PZ2xlc2JheQ==?= <Chad_Ogles...@discussions.microsoft.com>
|
Find Function
I would like to find the second occurence of a specific alphanumeric
character in a cell. For example, if cell A1 contains "BOBBY" what would be
the formula for finding the second occurence of the letter "B". Thank you
advance for your assistance. Greatly appreciated
|
6/4/2010 6:58:50 PM
|
5
|
=?Utf-8?B?U0pU?= <...@discussions.microsoft.com>
|
How do I look at two worksheets in one Excel workbook at same time
I know how to arrange windows to look at multiple workbooks. But I want to
have two worksheets displayed at the same time from the same workbook. Is
there a way to do that?
|
6/4/2010 6:48:03 PM
|
2
|
=?Utf-8?B?UGVvcmlhSmVhbg==?= <PeoriaJ...@discussions.microsoft.com>
|
Macro to affect all sheets
I want to select all sheets in a workbook, insert a column, and put a formula
in that column. It works fine when doing it manually, but if I try to have a
macro do this, it only affects one sheet. Is there any way to do this?
|
6/4/2010 6:33:09 PM
|
3
|
=?Utf-8?B?UkVNQg==?= <R...@discussions.microsoft.com>
|
Underline? Bottom border? or any suggestions?
Hello! We have a form that we use quite often and I am attempting to put it
on Excel so that someone can just tab through it and type in their responses.
This is a type of service report and there is a large section for the
technician to describe the work they performed on a specific day.
This section should allow the text that is typed in to be "underlined". Is
there a way to set this up so that the tech is able to type one complete
paragraph (instead of typing line by line), have the text print "underlined"
AND if the amount of text typed in does not fill the entire area
|
6/4/2010 6:16:31 PM
|
1
|
=?Utf-8?B?U2NobmFrYS1wYWth?= <Schnaka-p...@discussions.microsoft.com>
|
Text Parsing with uneven lengths
I have cells that contain data such as:
General Motors 22779
United States of America 1449
Carlsbad 712
Under 21 Children 12
I would like to parse the numbers at the end of each cell. Each number can
be different lengths and the text preceding the number can be different
lengths, too. Any ideas?
|
6/4/2010 6:16:30 PM
|
2
|
=?Utf-8?B?ZGtzMzQ1?= <dks...@discussions.microsoft.com>
|
permanent format pivot chart
How can I apply a format permanently in a Pivot Chart? For example, adding
values to my data graphs and not losing this format upon changing a field to
display more information.
|
6/4/2010 5:57:02 PM
|
0
|
=?Utf-8?B?YW16?= <...@discussions.microsoft.com>
|
excel 2007 saving issues
I have a file created in excel 2003 that has thousands of VLookup functions.
I recently installed excel 2007. When I open this file and try to save it,
it will take close to 20 minutes to save. Do you have any ideas on what is
slowing this down?
Thanks
|
6/4/2010 5:52:28 PM
|
0
|
=?Utf-8?B?Q1hI?= <...@discussions.microsoft.com>
|
Is there a way to insert a copied row into all aother tabbed table
I have a file with about 100 tabs along the bottom for other tables. I have
a row that I need to copy and insert into each one of those (at the top,
first row). I can copy and insert row into each tab individually but is
there a way to have this insert into all of them at once in the same place?
|
6/4/2010 5:23:30 PM
|
1
|
=?Utf-8?B?R3JlZw==?= <G...@discussions.microsoft.com>
|
Pivot Table
I have a pivot table based on an excel worksheet with five columns - Date,
Call From (Names), To, Time, and Type.
In the pivot table, i am using From for the rows. I also use From in the
values area as i want to count the number of times the data in From appears -
as there can be repeats. Next, I want to use Time as it relates to Call From.
Time ranges from 0 to > 0. I want to specifically count how many 0s and
greater than 0s. i thought i could filter for the data after adding the Time
field to the data area - it allows a filter but the results do not change.
I am using Ex
|
6/4/2010 4:47:07 PM
|
1
|
=?Utf-8?B?S1RS?= <...@discussions.microsoft.com>
|
nested formulas in excel using iserror and if
Please help!
I am trying to get the formula below to return a value to the cell ONLY if
the answer to ((c30-$30)/g$30) is greater or less than 20%.
I am using the below formula.
=IF(ISERROR((C30-$G30)/$G30),"-",IF(((C30-$G30)/$G30)>ABS(20),((C30-$G30)/$G30)," "))
Thanks
|
6/4/2010 4:34:47 PM
|
2
|
=?Utf-8?B?Vmlja2k=?= <Vi...@discussions.microsoft.com>
|
How to merge 2 + contiguous cells without lossing data?
I need to merge two or more contiguous cells without lossing the data.
Also I have cells that I copied & pasted into cells and I am unable to add
data to these cells.
|
6/4/2010 4:14:06 PM
|
2
|
=?Utf-8?B?UGF0dGk=?= <Pa...@discussions.microsoft.com>
|
Pull value from another sheet
I have multiple sheets in my workbook. On the first sheet, I am pulling data
from all the other sheets for a comparison. I need to pull in a commission
level for specific group numbers.
Here is what I need: Sheet 1 K3 is where my formula is. I need to match the
value from sheet 1 B3 to sheet 2 I4. Then, if they match, I want the value
from sheet 2 N4 to show up in sheet 1 K3. Another issue may be that on sheet
two there may be multiple group numbers that are the same, however all
commission levels for a group number are the same. So I guess I could go
average or median if tha
|
6/4/2010 4:11:33 PM
|
2
|
=?Utf-8?B?bGF1Z2hsaW5s?= <laughl...@discussions.microsoft.com>
|
Sorting a list of numbers
I have inherited an excel file with numbers across 100 columns and over 300
rows with several blank cells (likely 15%). I would like to format these
numbers across 10 columns and however many rows are necessary, but without
any blank cells, in ascending order down each column.
Can someone help me how to do this? Thank you.
|
6/4/2010 3:24:19 PM
|
3
|
=?Utf-8?B?QlJC?= <...@discussions.microsoft.com>
|
Sumproduct;3 criteria
Hello,
I need a formula that will sum the dollar value of a column if the entries
meet 3 seperate criteria.
The current formula I have (that returns a #NUM error) is:
=SUMPRODUCT(('May YTD Data'!$K:$K="New Customer"),('May YTD
Data'!$AB:$AB=B6),('May YTD Data'!$D:$D>4/30/2010),('May YTD
Data'!$D:$D<6/1/2010),'May YTD Data'!$Q:$Q)
Idea is to sum the sales volume (dollar amount) for "New Customer" per sales
reps (B6) for the month of May.
Thanks in advance for any advice you provide
|
6/4/2010 3:17:02 PM
|
5
|
=?Utf-8?B?R3JlZ0w=?= <Gr...@discussions.microsoft.com>
|