Opening file in Excel 2002
When I open a file, the "open file dailogue box" is always maximised and
there is no facility to minimize. This feature was available before & has
disappeared. How do I get it back.
Petros Tag: Lost Quattro Pro 10 tool bar Tag: 784265
COUNTIF Multiple conditions
I have a worksheet were I want to count the number of times a number larger
than 0 appears in the second column 'B', but only if the month is 'May' in
the first column 'A'. I seem to have problems using multiple COUNTIF
conditions, the solution is probably easy but its driving me mad!
A B
1 May 0
2 Feb 0
3 May 15
4 March 40
5 May 50 Tag: Lost Quattro Pro 10 tool bar Tag: 784264
Excel - Wrap Text
I have large text in a cell (1500 char) I have selected option of wrap text
still i can see the full text even with row height 179 and column width 87.
can some one tell me what should i do to see full text.
Thanks a lot to all supported me time to time!
Thanks again. Tag: Lost Quattro Pro 10 tool bar Tag: 784262
Reading fields from multiple new files
Hi
We create a number of new files from a template a day, and collect some data
from these new files for statistical purposes. What name / handle can I use
to have a
dynamic name for the workbook that is open in addistion to the stats workbook.
Heres what I got so far:
Sub openFile()
' OPEN FILE
openThisFile = Application.GetOpenFilename(FileFilter:="Excel Files (*.xls,
*xlsx), *.xls, *xlsx", Title:="Please select a file")
If openThisFile = False Then
' They pressed Cancel
MsgBox "Stopping because you did not select a file"
Exit Sub
Else
Workbooks.Open filename:=openThisFile
End If
' END OPEN FILE
Call selectNextRow
Call doRead
End Sub
**********
Sub selectNextRow()
'Activate the STATS sheet
Windows("Statistics.xls").Activate
Worksheets(4).Select
'Select the next available row
Application.ScreenUpdating = False
NextRow = Range("C65536").End(xlUp).Row + 1
Cells(NextRow, 1).Select
Application.ScreenUpdating = True
End Sub
************
Sub doRead()
ActiveCell.FormulaR1C1 = "='somethinghere'!R5C4"
Cells(Selection.Row, Columns.Count).End(xlToLeft).Offset(, 1).Select
End Sub
************
so i need a litlle something weher it says 'somethinghere' in doRead().
Can i get it from filename or openThisFile?
probably a newby question, but i am one so that's alright, right?
/marko Tag: Lost Quattro Pro 10 tool bar Tag: 784249
N/A Error
Hi All
Is it possible that when a Formula returns a N/A result, can I change this
to say "Incorrect" r something else of my choice.
cheers Tag: Lost Quattro Pro 10 tool bar Tag: 784245
Problem with multiple condition in SUMIF
Hi all,
I have read most of the notes and e-mail from the community section.
However, I still failed to get the answer I want, after trying various method.
Is there a way where I can attached my worksheet and show my problem to
anysone? Tag: Lost Quattro Pro 10 tool bar Tag: 784244
Formula for Weighted Average
Is there a general formula for Weighted average? I have a row of numerical
data, from 1 to 5. If it's 1, the weight is 0%, 2 - 25%, 3 - 50%, 4 - 75%, 5
- 100%. Is there a formula which I can do this?
Thanks Tag: Lost Quattro Pro 10 tool bar Tag: 784234
Hiding and Showing Sheets using Macro
Hi Does any have any ideas on how to create a macro for this or if this is
possible?
- I want to have 1 workbook with about 13 spreadsheets in it.
- When I open the workbook I only want to see "sheet 1" (with the other 12
spreadsheets hidden)
- On sheet 1 i want to have 3 buttons, 1. Commodities 2. Forex 3. Options
- When I click on the 'Commodities' button, I want spreadsheets 2,3,4 & 5 to
show/be unhidden
- I also want there to be a button on spreadsheet 2,3,4,&5 to say 'Back to
Spreadsheet 1' and when clicked will navigate back to spreadsheet 1 and
spreadsheets 2,3,4 & 5 hidden again (like when i first open the workbook)
- When i click on the 'Forex' button, I want spreadsheet 6,7,8 & 9 to be
shown/unhidden
- I also want there to be a button on spreadsheet 6,7,8 & 9 to say 'Back to
Spreadsheet 1' and when clicked will navigate back to spreadsheet 1 and
spreadsheets 6,7,8 & 9 hidden again (like when i first open the workbook)
- When i click on the 'Options' button, I want spreadsheet 10,11 & 12 to be
shown/unhidden
- I also want there to be a button on spreadsheet 10,11 & 12to say 'Back to
Spreadsheet 1' and when clicked will navigate back to spreadsheet 1 and
spreadsheets 10,11 & 12hidden again (like when i first open the workbook)
I'm not sure if what i want to do is even possible and would really
appreciate any help on how to do this or on a better way to do this.
Many thanks in advance! Tag: Lost Quattro Pro 10 tool bar Tag: 784233
True/False for finding text in cells
Is there a simple formula for checking if a cell contains a text string,
which returns a TRUE/FALSE? It is possible to combine "ISERROR" and "FIND",
but this becomes a pain when you have to do it all the time. Instead of
using the reverse logic of:
=if(iserror(find("text",A1))=FALSE,...
it would be so much easier to write:
=if(contains("text",A1),...
This is a very basic thing you can do with an autofilter, so it seems like
there would be a function that does this without returning error values. Any
suggestions? Thank you. Tag: Lost Quattro Pro 10 tool bar Tag: 784232
Using VBA to Create New Sheet That Consolidates Others
Hi, there:
Ron de Bruin's site provides the following wonderful code, which reads
through all of the sheets in a workbook and then creates a new sheet that
consolidates all of the rows on them into one new sheet (called "Summary," in
this case). I've left his explanatory comments in:
Sub BuildSummarySheet()
Dim sh As Worksheet
Dim DestSh As Worksheet
Dim Last As Long
Dim shLast As Long
Dim CopyRng As Range
Dim StartRow As Long
With Application
.ScreenUpdating = False
.EnableEvents = False
End With
'Delete the sheet "Summary" if it exist
Application.DisplayAlerts = False
On Error Resume Next
ActiveWorkbook.Worksheets("Summary").Delete
On Error GoTo 0
Application.DisplayAlerts = True
'Add a worksheet with the name "Summary"
Set DestSh = ActiveWorkbook.Worksheets.Add
DestSh.Name = "Summary"
'Fill in the start row
StartRow = 5
'loop through all worksheets and copy the data to the DestSh
For Each sh In ActiveWorkbook.Worksheets
'Loop through all worksheets exept the RDBMerge worksheet and the
'Information worksheet, you can ad more sheets to the array if you
want.
If IsError(Application.Match(sh.Name, _
Array(DestSh.Name, "LOOKUPS"), 0)) Then
'Find the last row with data on the DestSh and sh
Last = LastRow(DestSh)
shLast = LastRow(sh)
'If sh is not empty and if the last row >= StartRow copy the
CopyRng
If shLast > 0 And shLast >= StartRow Then
'Set the range that you want to copy
Set CopyRng = sh.Range(sh.Rows(StartRow), sh.Rows(shLast))
'Test if there enough rows in the DestSh to copy all the data
If Last + CopyRng.Rows.Count > DestSh.Rows.Count Then
MsgBox "There are not enough rows in the Summary Sheet
to continue."
GoTo ExitTheSub
End If
'This example copies values/formats, if you only want to
copy the
'values or want to copy everything look below example 1 on
this page
CopyRng.Copy
With DestSh.Cells(Last + 1, "A")
.PasteSpecial xlPasteValues
.PasteSpecial xlPasteFormats
Application.CutCopyMode = False
End With
End If
End If
Next
ExitTheSub:
Application.GoTo DestSh.Cells(1)
'AutoFit the column width in the DestSh sheet
DestSh.Columns.AutoFit
With Application
.ScreenUpdating = True
.EnableEvents = True
End With
End Sub
I'm not sure, however, how to include a head row on the newly-created
summary. Rows 1 through 4 of all of my subsidiary sheets are identical. How
can I tell the macro to copy and paste the heeads on the first iteration of
the loop, but not thereafter? The subsidiary sheets are not named the same
thing--and in fact, their names may change--but the column rows/heads will
always be the same.
Can anyone help? Thanks in advance! Tag: Lost Quattro Pro 10 tool bar Tag: 784225
Question to MailMerge expert
Hi,
I have been using MailMerge for some time, usually to get
1 Word page from each Excel record.
Sometimes I use Skip a record if... when I want to skip some
records.
Now I have a new task and problem.
Fields (columns) in an Excel sheet are grouped into 3 groups,
each connected with different subject. Each subject must be
merged into a separate Word page. However in some records
all data for a subject can be equal to zero, so from 1 Excel
record I can get 1 or 2 or 3 Word pages depending on the data.
So the question is: how to get 1 or 2 or 3 Word pages from
each Excel record using the MailMerge?
I still use the MS Office 97 but if necessary I can install w newer
version of the programs.
I would be very grateful if someone could help me.
Regards,
Zoska Tag: Lost Quattro Pro 10 tool bar Tag: 784216
Auto calculate end date
Good Day,
I have a column with start dates and I want to have the column beside it
display 5 years forward, e.g.: column A: 2008-05-11 , column B: 2013-05-11
How can I do this automatically?
Thanks!
Carol Tag: Lost Quattro Pro 10 tool bar Tag: 784202
issue....
hi guys , please i need your advice on this one :
i have the following given :
A B
1 max 10
2 ralph 20
3 max 30
4 max 40
5 ralph 50
i would like to have the related results of "max" and "ralph"...how can
this be achieved ??? index(...,small(...) ) maybe ??? HOW ???? Tag: Lost Quattro Pro 10 tool bar Tag: 784191
Date in formula
Hi All,
I need your help in showing me how to put a date in the formula, for
instance:
=If(A2<4/01/2008,"old","ok")
I know I can't just put a date there, I think there must be something at
each ends of the date.
Thanks. Tag: Lost Quattro Pro 10 tool bar Tag: 784168
How: automatically re-adjust number series
I have the following number series:
B1=1000
B2=1005
B3=1010
B4=1015
B5=1020
B6+1025
etc etc all in increments of 5. However, I have some completely random cells
in the same column that I must leave blank. Since I used the fill handle to
copy down the number series, how can I delete random cells and have the
number series readjusted automatically e.g as follows:
B1=1000
B2=blank
B3=1005
B4=1010
B5=blank
B6=1015
Greatly appreciate your help. Excel 2003. Tag: Lost Quattro Pro 10 tool bar Tag: 784164
Transpose column into rows for use as mailmerge data
I have data in the following format and would like to convert into an Excel
spreadsheet for use as mail merge database
Mr Chris Acton
ADH Services Ltd
Unit 5 The Oaks Down End
Crediton
Devon
EX17 1HN
Mr Peter Alexander
Mains Of Mause
Blairgowrie
Tayside
PH10 6TE
Mr James Anderson
Bowmer & Kirkland Ltd
High Edge Court Church Street
Belper
Derbyshire
DE56 2BW
If the addresses were only three lines then I could use the following
method. However some addresses have 5, 6 or 7 lines. Can anybody help get it
in the right format for a mailmerge?
In B1 enter this formula =INDEX($A:$A,(ROWS($1:1)-1)*3+COLUMNS($A:A))
Drag/copy across to D1.
Select B1:D1 and drag/copy down until zeros show up.
Select columns B:D and copy.
Edit>Paste Special(in place)>Values>OK>Esc
Delete Column A
--
Nash Tag: Lost Quattro Pro 10 tool bar Tag: 784161
A Pivot question
Hi,
I have a pivot with two recurring lines : Budget & Actual. They are 2 values
of the field. They are on top of eachother (as it's supposed to be).
I would like to add another row beneath them that shows the subtraction
between the two (doesn't matter which way).
How do I do that within the pivot table ?
Thanks,
Assaf Tag: Lost Quattro Pro 10 tool bar Tag: 784151
Why does this macro crash?
I have to deal with CSV files output by some commercial software which
is not properly written. It gives long lists in which some of the rows
have more columns than others. These lists can be thousands of lines
long, so I wrote this macro, which moves the offending rows back to
where they should be.
First, I manually open up enough columns so that the rows can be moved
to the left. Then I establish which is the rightmost column containing
data, and I go to Row 1 and run the macro.
It works fine, except that it crashes at row 65535, instead of simply
ending because it has dealt with every cell in the column. I have
highlighted where it crashes, and would appreciate anyone who knows why
this happens.
Sub Line_up_cols()
'
' Keyboard Shortcut: Ctrl+Shift+L
'
Dim myRange As Range
Dim Cell As Range
For Each Cell In ActiveSheet.Columns()
Selection.End(xlDown).Select
Selection.End(xlToLeft).Select
Set myRange = ActiveCell
Range(Selection, Selection.End(xlToRight)).Select
Selection.Cut
myRange.Offset(0, -1).Select <<<<---- Crashes here
ActiveSheet.Paste
ActiveCell.Offset(0, 1).Select
Selection.End(xlToRight).Select
ActiveCell.Offset(0, 1).Select
Next
End Sub Tag: Lost Quattro Pro 10 tool bar Tag: 784145
formula
Hi,
I would like to create some formulas that regonises a word in the first
column and then adds up the number across from it.
Thanks....
--
MickM Tag: Lost Quattro Pro 10 tool bar Tag: 784140
drop downs
Hi,
I would like to create a list of drop downs in the first column of an excel
spreadsheet. I would like input a list for the drop downs and also have the
icon for the drop down visible in each and every cell.
Thanks....
--
MickM Tag: Lost Quattro Pro 10 tool bar Tag: 784138
help..
i have the following given :
A B
1 asih 234
2 aa 334
3 bb 434
4 asih 534
5 cc 634
6 dd 734
7 asih 834
i managed to do the following :
{INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=C1,ROW($A$1:$A$7)),ROW(1:1)),2)}
and i dragged it to cell C3.
NOW.....
my purpose for this is to be able TO enter the word "asih" in C1 and C2 and
C3 in order to be able its coresponding data which are : 234 , 534 , 834
MY QUESTION NOW IS :
what should i do to insert the following formula : index(....),match(....) )
WITHIN THE PRECEDENT FORMULA:
{INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=C1,ROW($A$1:$A$7)),ROW(1:1)),2)}
AND THAT IN ORDER TO GET FOR EXAMPLE (734) IF I HAD TO TYPE (DD).????
THANKS FOR YOUR HELP Tag: Lost Quattro Pro 10 tool bar Tag: 784137
Merging Workbooks
Hi!..Does anyone have any ideas on how you would do the following?
I want to have 1 main work book (workbook 1) with only one sheet. On that
sheet I want to create 3 buttons. Button 1 creates a link/marco to open
another workbook (workbook 2) automatically when the button is clicked,
button 2 creates a link/marco to open workbook 3 automatically when button is
clicked and button 3 creates link/marco to open workbook 4 automatticall when
button is clicked
Is this even possible?
Many thanks for any help in advance! Tag: Lost Quattro Pro 10 tool bar Tag: 784134
assign values to specific cells in an excel sheet through text file
Hi list
I am very new to macros or any visual basic codes. Kindly guide me with
materials or ideas to assign values to specific cells in an excel sheet.
For example,
I wish to assign values 1,2,3,4.... into A1, B1, C1, D1...... in Sheet1
of C:\data.xls.
with thanks
pushparaj
--
s_pushparaj Tag: Lost Quattro Pro 10 tool bar Tag: 784133
Formula/Macro to place data on the next blank row
Hi everyone,
I'll be grateful if someone can help me set up a formula/macro through which
data can be placed on the next blank row. My intention is to create a
database of info and update the list sometime before I choose new dat (ie,
the existing quotation details can be saved in the database before the new
quotation is generated).
Thanks. Tag: Lost Quattro Pro 10 tool bar Tag: 784131
saving excel file
Hi,
I have some formulas and data which is shared for the users to get their
answers instantly. Is there any way not to allow users to save the excel
shared file if they make any changes. Is it possible if the users close the
file with some changes excel exit without prompting or saving??. i tried read
only, protect sheet etc. its of no use.
Thanks
Kevin Tag: Lost Quattro Pro 10 tool bar Tag: 784129
Pulling data by start/finish dates
I have a spreadsheet of work orders with start dates in column G and finish
dates in column H. I would like to be able to pull all records between
certain start and finish dates - this would change each month (ie all records
between April 1 (start) and April 30 (finish) and place on a blank sheet.
I want to be prompted to enter the dates. How would I do this? Tag: Lost Quattro Pro 10 tool bar Tag: 784124
Min Value
Here is an equation I'm using to calculate intersection sight
distance:
ISD = 1.47 (Vmajor) [T + (G - 3%)0.2 + (W/12)0.5]
Each variable will be a cell, for instance, G could be B12. When G
is less that 3%, I don't want it to do that part of the equation. The
actual value of G could be 2.57%, but when it is, I don't it to
"subtract 3%, then mult. by .2 In the EQUATION, i want that term,
(G - 3%)0.2, to be a minimum of zero. See, when G is less than 3%,
that whole term is negative, and i don't want that. Can anyone help
me think of a way to not do that part of the equation when G < 3%?
Is there some Excel function I'm not thinking of? I'm trying to avoid
tons of nested IF statements.
Much appreciated,
dk Tag: Lost Quattro Pro 10 tool bar Tag: 784119
Space in text
when I copy text from on sheet to anoth, the destination after the paste has
one space in front of the text. how do i remove the space from multiple cells
at the same time Tag: Lost Quattro Pro 10 tool bar Tag: 784102
is statement
want to do this in a formular but dont know how:
if the text in sheet 1 cell c2 = the text in sheet 2 column d, then return
text in sheet 2 column e associated with text in column d.
I've tried using vlookup, it works with some of the sheets but not all of
them. I have to continiously copy text between the two sheets for it to work.
Please help. Tag: Lost Quattro Pro 10 tool bar Tag: 784100
VLOOKUP Combining 2 Reports.
How would I combine these two reports together using 05?
Report 1 (Sales report)
Item # Description 1 Qty Sold Publisher
12 360 BLAZING ANGELS 1 UBISOFT
25 360 CIVIL WAR 1 ACTIVISION
43 360 ELDER SCROLLS IV 1 TAKE 2
71 360 GHOST RECON AW 2 1 UBISOFT
78 360 HARDWARE ARCADE 1 MICROSOFT
91 360 LIVE 1 MONTH CARD 1 MICROSOFT
94 360 LIVE 3 MONTH CARD 1 MICROSOFT
97 360 LIVE POINTS 1600 3 MICROSOFT
Report 2 (Qty On-hand)
Item # Description 1 On-Hand Publisher
12 360 BLAZING ANGELS 6 UBISOFT
25 360 CIVIL WAR 2 ACTIVISION
43 360 ELDER SCROLLS IV 4 TAKE 2
71 360 GHOST RECON AW 2 3 UBISOFT
I just need to add the on-hand qty from report 2 to report 1.
Report one only generates items that have sold which is normally several
hundred items. Report 2 will generate the entire inventory database which is
more than 10,000 items.
Do I have to use item # to use VLOOKUP? If Column A was a UPC # or
Description instead of item # how would I use VLOOKUP? Tag: Lost Quattro Pro 10 tool bar Tag: 784099
If statement in macro
Hi
I want the macro to type in column on "c" the status "On Time" or Delayed"
depending of the following criteria:
- if A= MTL and B = 2 then C= "on Time"
- if A<> ATLN OR VAN and B =1 then C ="on time"
- if A=ATLN ot VAN then C="out of ON PU"
- Else "Delayed"
A B c
MTL 2
ATLN 5
VAN 7
LOND 1
I wrote the below proceduce but there is an error. Could anyone help me to
write this procedure properly. Thanks in advance.
Sub Job()
Range ("C1).Select
ActiveCell.Value = "=if ActiveCell.Offset(0,-2)= "MONT" and
ActiveCell.Offset(0,-1)=2 then Active.Cell.Value="On Time"
Else
if ActiveCell.Offset(0,-2) <> "ATLN" or If ActiveCell.Offset(-2,0)<> "VAN"
and ActiveCell.Offset(0,-1)=1 then ActiveCell.Offset.Value="On Time"
Else
if ActiveCell.Offset(0,-2) = "ATLN" or If ActiveCell.Offset(0,-2)= "VAN" then
ActiveCell.Value="Out of ON PU"
Else
ActiveCell.Value="Delayed"
End if
End ()
Orquidez Tag: Lost Quattro Pro 10 tool bar Tag: 784098
How do I separate numbers?
I have a web query which gives me the result "385/1700" and all I want is the
first part "385" to allow me to do calculations with, but because it's a web
query, it wont let me just format it as a fraction and times it by 1700.. it
comes up with the #VALUE! error.
So I dont know what else to try,
Can anyone help?
Thanks,
Aden Tag: Lost Quattro Pro 10 tool bar Tag: 784096
is this filter possible?
I have a list of customers on sheet 1 cell A1. I need a filter that will
display specific cells for specific customers. For instance, when the list in
A1 reads ABC Lumber Co., I would like to see cells columns A through F lines
601 through 622 directly below the list cell. Is this possible?
--
bob Tag: Lost Quattro Pro 10 tool bar Tag: 784085
calculate moles in excel
HELP!
How in Excel do I work out how many moles are in 1kg of water. Desperately
need an answer for Monday morning.
:) Tag: Lost Quattro Pro 10 tool bar Tag: 784083
Disabling Automatic Date Thing
When i type '5-10' for example, and then press enter or leave that box, the
'5-10' i typed automatically changes to '05-Oct'. It's really irritating and
it happens with others, such as '10-15', basically anything that looks like a
date.
How do I turn this off? Tag: Lost Quattro Pro 10 tool bar Tag: 784079
Disabling Automatic Date Thing
When i type '5-10' for example, and then press enter or leave that box, the
'5-10' i typed automatically changes to '05-Oct'. It's really irritating and
it happens with others, such as '10-15', basically anything that looks like a
date.
How do I turn this off? Tag: Lost Quattro Pro 10 tool bar Tag: 784078
Row-Entire row changes color (and stays) selecting first entry
I have a sheet with 63 rows and 30 columns. I would like the row to
change color and stay as I slide across columns. Freeze panes works
almost but to change color would be better. Tag: Lost Quattro Pro 10 tool bar Tag: 784077
Numeric formatting
Hi,
I need to format numbers as 10E-3, 10E-5, or 10E-6. I need to maintain the
10E-x format. Not scientific or engineering notation. It's for recording Bit
Error Rate measurement results.
Any ideas?
Thank you for your help. Tag: Lost Quattro Pro 10 tool bar Tag: 784074
Excel "If" Function formula
Hi I need some help figuring out if it is possible to create a formula.
I'm trying to link information from different pages in a spreadsheet that
contain id's for people and prices they are paying for some items my church
is selling. We have a main worksheet that lists their names and the ids and
then we have another worksheet that lists all the items they can buy with
it's price.
Is it possible to create a formula in the name page that says "If you find
id #1 in column A, then sum the prices from column D". The ids will be spread
out throughout column A so we need a formula to locate each instance of the
id and then grab the price listed each time in column D and sum those prices
up.
Is this possible and if yes can someone tell me how to do it.
Thanks Tag: Lost Quattro Pro 10 tool bar Tag: 784068
Min Sumproduct formula returns a zero.
I have a spreadsheet. Which can be viewed on my public box link
http://www.box.net/shared/movk8u3cws
My headings are A3 Date, B3 Name, C3 Contribution E3 12/08/07
Date=A3 Name=B3 Contribution=C3 12/8/2007=E3 Andy=F3
12/8/2007 Andy 1
12/8/2007 Andy 40
12/8/2007 Andy 3
12/8/2007 Andy 4
Date=A11 Name=B11 Contribution=C11 12/8/2007=E11 Andy=F11
12/8/2007 Andy 1
12/8/2007 Andy 40
12/7/2007 Andy 3
12/8/2007 Andy 4
In E3, I entered 12/08/07 and in F3 I entered Andy. I want my formula in J11
which is =SUMPRODUCT(MIN((B6:B9=F5)*(C6:C9=G5)*(D6:D9))) to return the
minimum contribution that Andy made on 12/08/07. When I substitute Min for
Max, the formula works with no problems at all. As soon as I switch to Min
the formula returns a zero. It will work if all the dates and all the names
are the same. But as soon as the Date or Name changes I get a zero fpr the
Min formula. I even entered it as an array but it won't work. Tag: Lost Quattro Pro 10 tool bar Tag: 784062
vba programming in excel 2007
how i can use vba programming in excel 2007 to sort in column in
ascending order give me reply as a i am beginner. Tag: Lost Quattro Pro 10 tool bar Tag: 784058
Count after given condition is met
Hi all
would like your help for the following
Need to count which and how many numbers appear after a given number
ie
After After After After After After
1 2 3 4 5 6
1
2 1 1
3 1 1 1 1
4 1 2 3 1 1
5 2 1
6 1
this was obtained from data on column c, that is displayed as follows:
3
5
4
5
3
4
4
2
4
3
4
4
3
5
6
4
4
3
3
4
2
3
2
Tks in advance
Antonio Tag: Lost Quattro Pro 10 tool bar Tag: 784053
Excel - how to autofill thousands of cells quickly
I have a spreadsheet with 35000 rows. Is there an easy way to autofill a
formula for all of the rows instead of dragging down all 35000 rows? Tag: Lost Quattro Pro 10 tool bar Tag: 784040
Pivot Table % Calculation Issue
I am bringing in the data below from SQL Server. I cannot add a calculated
field because it is removed when it is refreshed.
The issue is with the SUM of the GP% ((GP $/Sales)*100). I manually added
another column to the right for only the ones that are wrong and what it
needs to be. Spent too many hours trying to resolve this one.
Data
Store Order No Description Sales GP $ GP% GP% Needs
to be
BR 00000231 SPRING RED 11.99 6.49 54.13
00000231 Total 11.99 6.49 54.13
00000232 SPRING RED 11.99 6.49 54.13
00000232 Total 11.99 6.49 54.13
00000233 BALL RACK 49.99 24.99 49.99
00000233 Total 49.99 24.99 49.99
00000234 BLUE PUP 39.99 19.49 48.74
00000234 Total 39.99 19.49 48.74
00000236 BLUE PUP 39.99 19.49 48.74
SPRING RED 11.99 6.49 54.13
SPRING YEL 11.99 6.49 54.13
00000236 Total 63.97 32.47 156.99 50.76
00000237 READ RACK 14.99 7.49 49.97
BLUE PUP 39.99 19.49 48.74
SPRING RED 11.99 6.49 54.13
00000237 Total 66.97 33.47 152.83 49.98
00000238 BALL RACK 49.99 24.99 49.99
00000238 Total 49.99 24.99 49.99
00000239 SPRING YEL 11.99 6.49 54.13
00000239 Total 11.99 6.49 54.13
BR Total 306.88 154.88 620.93 50.47
Grand Total 306.88 154.88 620.93 50.47
Any suggestions would be greatly appreciated.
Jeannette Tag: Lost Quattro Pro 10 tool bar Tag: 784035
comparing from two worksheets
Hi all, I am trying to compare from two worksheets. What I have is the
inventory that my headoffice is telling me I have and the other is the actual
inventory I have I want to compare the two by product number and discription
giving the head office total per item, my total per item and the difference
between the two. I have a general knowledge about this but I thinking its
over my head. Help required. Thanks Tag: Lost Quattro Pro 10 tool bar Tag: 784032
display specific next highest value from a column containing multi
Just cant seem to get it. I am working with data in F10:F100 that contains
numbers like (1,2,3,4) as well as lettered numbers like (C1,C2,C3,C4). I can
not come up with a formula that will index this column and return the next
highest C number. F9 needs to display the next highest C number. I can get
this to work with the standard numbers only (1,2,3,4). Any suggestions Tag: Lost Quattro Pro 10 tool bar Tag: 784030
I am using Quattro Pro 10, all the tool bars have disappeared and I can not
figure out how to get them back. Help! Reba
An Excel newsgroup is not the place to ask about Quattro Pro.
--
David Biddulph
"Reba" <Reba@discussions.microsoft.com> wrote in message
news:09394893-94DF-4286-91EB-7CC416337818@microsoft.com...
>I am using Quattro Pro 10, all the tool bars have disappeared and I can not
> figure out how to get them back. Help! Reba
Have you tried posting in one of the groups dedicated to corel.quattro
Pro ?
Pete
On May 12, 10:27=A0am, Reba <R...@discussions.microsoft.com> wrote:
> I am using Quattro Pro 10, all the tool bars have disappeared and I can no=
t
> figure out how to get them back. Help! =A0Reba