Setting up questions & answers
Any pointers would be most appreciated. I'm wanting to create exams online
and have been told Excel will do this. For instance 20 questions with each
question having to choose the correct answer from a number of possible
answers. I want whoever to go through trhe 20 questions and only know how
many they got right by submitting at the end. They won't know which they
got right, only the number they got right. Any advice where to start with
Excel would be brilliant.
Best,
Paul B. Tag: convert PDF file to excel 2007 file Tag: 141946
Excel newbie needs help from math wiz (poker related)
I want to create a Excel workbook that will help in specific poker
situations.
Short version: I want to be able to calculate how often my opponent will
need to fold for an all-in raise to show a positive expectation.
Explanation:
In poker you can win a hand by having the best hand at the end OR getting
your opponent to fold.
A common situation comes up where you have a "drawing hand" and face a bet
by your opponent. In this situation you know you are currently behind in the
hand, but have a chance to win if you catch some of your "outs" (cards that
will give you the winning hand).
Example:
You have one of these drawing hands and it will become the winning hand
about 1/3 of the time if you stay in until the end.
There is $150 in the pot and your opponent bets another $100.
If you were to re-raise all in it would be for a total of $300 ($200 in
addition to his $100).
x% of the time my opponent will fold in this spot
I want to be able to solve for x (the amount my opponent will need to fold)
to show me the break even point of this re-raise.
When I re-raise all in he is only left with two options so we need to
account for both. He can call or he can fold:
100% of the time he folds I will win $250
2/3 of the time he calls I miss my draw and lose $300 (the amount I
re-raised all in with)
1/3 of the time I will hit my draw and win $450 ($150 in the original
pot+his $100 bet+his $200 call of my all in re-raise)
So, how can I create an excel workbook/calculation that will calculate the %
my opponent will need to fold for my all in re-raise to break even?
Thanks in advance for any help with this. Tag: convert PDF file to excel 2007 file Tag: 141945
HLOOKUP-ish?
I'm stumped. I know you can't do an HLOOKUP if you're not starting at
the top of the range. I have a worksheet (called "Data") that
contains 3500 rows of data. There are multiple "departments" within
this data. I want to be able to look up a specific "department" and
return the result in the row beneath it (on the worksheet "Results"),
even if the department isn't the first row. Here's an example:
From the "Data" worksheet:
1. 2008149Bob
2. 2008149Donna
3. 2008149Annalisa
4. 2008149Lindy
5. 2008153Total
6. 2008153Joe
7. 2008153Marty
8. 2008153Larry
9. 2008153Anne
10. 2008153Owen
11. 2008153William
12. 2008153Amy
13. 2008153Jim
14. 2008153Nina
15. 2008153Thad
16. 2008153Richard
17. 2008153Erica
On a different worksheet ("Results", I want to look up Department
153's Total (row 5) and return the results from the row beneath it (in
this case, "2008153Joe"). Because the departments aren't always in the
same range (sometimes Dept 153 will be in row 5, sometimes in row 116,
etc), I can't give the range a 'set' number.
Is this possible? Tag: convert PDF file to excel 2007 file Tag: 141934
Personal Macro Workbook Must Stay Open For Recording
I had the same problem. I solved the problem by opening Excel and save as a blank workbook to the following Directory:
C:\Program Files\Microsoft Office\OfficeXX\XLSTART
-where XX = Office version (probably 10,11, or 12)
Your directory might change if you did a custom install.
Name the file Personal.xls
Cheers Tag: convert PDF file to excel 2007 file Tag: 141929
Average of every 18th cell in a column
Hello!
My spreadsheet looks like this:
Column D
value1
value2
value3
...
Average1 of 1,2,3... (cell D25)
value4
value5
value6
...
Average2 of 4,5,6... (cell D43)...
Every 18th row, starting from D25 there is a "partial" average. Now, I
want to calculate the total average from them, but...
It is a template, so there actually is a value in cell D25 and D43
(25+18), but in the following cells, there only is the formula for
average calculation of future entries. In cells D61 and further, there
is an error message (dividing by 0).
What would be the formula to calculate an average from every 18th cell,
starting with D25, ending by, say, D2000, and considering only the cells
with an actual value?
Thanks in advance!
Peter Tag: convert PDF file to excel 2007 file Tag: 141928
Data Validation
I want to use data validation on a cell where the user MUST enter any
four digits, leading zeros are permitted.
Can someone explain how I do this? Tag: convert PDF file to excel 2007 file Tag: 141923
strip characters from a "number" like string
Hello
Could someone advise as to how to strip characters from a formula
resulting string which could look like the following? ( some of the
result would actually be numbers while others are number/character
combo's - see below for examples)
0002
0124
0125-A
1566A-A
Thank you for any assistance you can offer. ! Tag: convert PDF file to excel 2007 file Tag: 141920
Sum Unique Values in a Pivot Table
Hello
I have a spreadsheet with several records for each machine's name as
illustrated below:
Server Name / Database Instance Name / CPUs / Concurrent Access
______________________________________________________________
Larry / Larry1 / 8 / 5
Larry / Larry2 / 8 / 50
Larry / Larry3 / 8 / 10
Larry / Larry4 / 8 / 1
Amy / Amy1 / 2 / 10
Amy / Amy2 / 2 / 5
Amy / Amy3 / 2 / 35
Larry / Larry1 / 16 / 500
Derron / Derron / 6 / 25
I want to have pivot tables with "Server Name" in a ROW and two DATA fields:
- Data field 1 : a sum of the total "Concurrent Access" for all database
instances on the Server (i.e. 5+50+10= 65 for Larry)
- Data field 2 : a sum of "CPUs" per unique occurrences of Server Name (i.e.
8 for Larry and not 8+8+8)
Is there some way to do that in a pivot table?
Thanks Tag: convert PDF file to excel 2007 file Tag: 141914
Custom locking of columns and panes [Excel 2007]
Hello!
Is it possible to lock columns and panes so that they NEVER move?
Normally, locked panes remain visible when scrolling up and down, while
locked columns remain visible when scrolling right and left. I`d like to
have the first 8 columns and the first 5 panes visible simultaneously
even when I go to, say, cell VX12345.
And a second question:
Is it possible to lock a number of randomly selected columns? For
example the 1st, 5th and 8th column.
Greetings
Peter Tag: convert PDF file to excel 2007 file Tag: 141913
Formula Error - Assign number to unique values.
I have a list of codes in F$19:F$1500.
I was attempting to use the following code to assign a number to each
unique value in the list and repeat the previously assigned number if
it is duplicated.
This works for the first 15-20 numbers, but returns an error (#n/a)
afterwards as if the code stopped working.
I have tried EVERYTHING... Same result each time.
=IF(COUNTIF($F$18:F19,F19)>1,VLOOKUP(F19,F$18:G18,2,FALSE),MAX($G
$18:G18)+1)
Any clues? Tag: convert PDF file to excel 2007 file Tag: 141902
Filter on non-blanks in a range (multiple columns)
I have a spreadsheet that has offers on parts from multiple
clients. The spreadsheet is 12,000 lines long. I am looking to
select on a range (of offers) and the highest offer gets put into a
BEST OFFER column on the same row.
Example
Part Number BestOffer Offer#1 Offer#2 Offer#3 Offer#4 Offer#5
xxxxxx-001 $13.00 $1.00 $5.25 $10.00 $3.50 $13.00
xxxxxx-002 $5.00 $1.25 $3.00 $5.00 $4.75 $8.00
The spreadsheet (12,000 lines long) has to remain in the same,
original format as it came in BEFORE I received these offers.
What is the best bet to address this? Tag: convert PDF file to excel 2007 file Tag: 141900
Cannot include "[" or "]" in filename path???
When I try to save an Excel spreadsheet to My
Document/[Activities]/2008-05-05 I recieve an error that some characters are
not allowed. [ and ] are both valid characters for a file name.
What can I do to get Excel to accept these characters at the SaveAs dialog
box? Tag: convert PDF file to excel 2007 file Tag: 141897
Separate at first number
Have a string of codes similar to below.
Any way to separate (LEFT, or RIGHT) all text to the right of the
first number in the cell?
(Some codes have more/less characters before and after zero, so using
right or left by itself may not work.)
apples12havocx
cherries84toughx
plums45easyxx Tag: convert PDF file to excel 2007 file Tag: 141892
find duplicates and add some data
I've got two Excel sheets containing data about employees. Sheet A
is
a complete list, and Sheet B is a shorter list with only employees
who
are in a certain job category. I need to compare the two lists--both
have Employee ID numbers as part of the data set. Where Excel finds
a
matching ID #, I would like to append the job title that appears in
Sheet B into a blank column on Sheet A.
I'm thinking this could be done with some combo of an IF statement
and
VLOOKUP, but I haven't gotten any further than that. Any help would
be greatly appreciated! Tag: convert PDF file to excel 2007 file Tag: 141891
Not reading pasted values?
I have had this problem a few times before and I haven't been able to
find the answer...
I had a list of formulas and results in the column next to it (B).
I copied the values into another list (C) and now am referring another
set of formulas (d) to point at the pasted results. The new formula's
dont work (#N/A - error) unless I go down to each pasted value and
click in that cell and hit enter.
It's like saying that the cell values aren't real until I validate
them by hitting enter in those cells? Tag: convert PDF file to excel 2007 file Tag: 141888
Automatic, conditional chart creation from separate files [Excel
I have a number of separate files (Excel 2007). Each file contains
several sheets with test results of a few students. The students (the
same, all the time) are evaluated each month using the same test, and
each month a new sheet is created for each of them. For example:
Workbook 1: Worksheet A (John), Worksheet B (Jennifer), Worksheet C (Anna)
Workbook 2 (a month later): Worksheet A (Jennifer), Worksheet B (John),
Worksheet C (Anna)
I`d like to create a separate file with charts depicting the mean
results for each student. The chart would retrieve data automatically
from every file stored in a particular folder (including files to be
created later), but in the following way:
The chart for John:
Retrive data from every file in a given folder, from a given range, but
only if the worksheet contains "John" in L2.
In this case, Excel would create a separate file with three charts,
retrieving data from Workbook 1 AND 2, but from worksheet A OR B OR C.
Is that possible? Could anybody help with a VB Script or Macro? I don`t
think it`s possible without programming, which I can`t at all, is it?
Thanks in advance
Peter, Poland Tag: convert PDF file to excel 2007 file Tag: 141884
Lookup
Hello All,
I would like to use lookup function.
Usually the Vlookup would lookup the first instance the lookup value
comes across. eg data set.
Name Container Type
--------- -------------- ---------
John A 34
John B 45
John C 44
Peter A 67
Peter B 77
Now if I do a look up for John and Peter, the unique value would be
always 34 and 67
Now suppose I have another sheet where the type is requried as a
function then it would always use 34 and 67 for John and Peter.
How do I use a Vlookup with 2 conditions ie If Name is John and
Container is A then it would use 34, else it would us John and B .
Would appreciate any help.
thanks
SD Tag: convert PDF file to excel 2007 file Tag: 141882
Chart from separate workbooks
Hello!
I`m new to this group so greetings for everybody :).
My questions (MS Excel 2007):
There are 10 separate files, each containing a similar worksheet. There
is an eleventh, cumulative file, containing a chart from these ten files.
The number of files grows constantly. I would like the charts in the
cumulative file to change, based on the newly created files. How to do
this in a possibly automatic manner?
For example: 5 persons are evaluated each month with a 10-question test
and get a grade (from 1 to 5)for each question. In the cumulative file
there is a chart depicting the mean grade for each person and each
question, calculated from previous evaluation charts. I would like the
cumulative chart to change with the creation of each new evaluation
chart, which is placed in the same folder.
Thanks in advance
Peter Tag: convert PDF file to excel 2007 file Tag: 141880
Hot Shop Orient Watches Day Date - Orient Minimum Price
Hot Shop Orient Watches Day Date - Orient Minimum Price
Hot Watch Shop : http://www.hotwatchshop.com
Orient Watches : http://www.hotwatchshop.com/Orient-Watches.html
Orient Watches Day Date : http://www.hotwatchshop.com/Orient-Watches-Day-Date-Watch.html
Orient Watches Day Date All Products :
Orient Pepsi Automatic Dive Watch :
http://www.hotwatchshop.com/Orient-wristwatch-5695.html
Orient Cem60001b Automatic Day Date Mens Watch :
http://www.hotwatchshop.com/Orient-wristwatch-5696.html
Orient Cem60001w Automatic Day Date Mens Watch :
http://www.hotwatchshop.com/Orient-wristwatch-5697.html
Orient Cem60001h Automatic Day Date Mens Watch :
http://www.hotwatchshop.com/Orient-wristwatch-5698.html
Orient Cfnaa006b Automatic Day Date Mens Watch :
http://www.hotwatchshop.com/Orient-wristwatch-5699.html
Orient Cfpaa002b Automatic Day Date Mens Watch :
http://www.hotwatchshop.com/Orient-wristwatch-5700.html
The Same Orient Watches Series :
Orient Titanium Chronograph : http://www.hotwatchshop.com/Orient-Titanium-Chronograph-Watch.html
Orient Watches Chronograph : http://www.hotwatchshop.com/Orient-Watches-Chronograph-Watch.html
Orient Watches Day Date : http://www.hotwatchshop.com/Orient-Watches-Day-Date-Watch.html
Orient Watches Diver : http://www.hotwatchshop.com/Orient-Watches-Diver-Watch.html
Orient Watches M-Force : http://www.hotwatchshop.com/Orient-Watches-M-Force-Watch.html
Orient Watches Military : http://www.hotwatchshop.com/Orient-Watches-Military-Watch.html
Orient Watches Monthly Calender : http://www.hotwatchshop.com/Orient-Watches-Monthly-Calender-Watch.html
Orient Watches Multi Eye : http://www.hotwatchshop.com/Orient-Watches-Multi-Eye-Watch.html
Orient Watches Open Heart : http://www.hotwatchshop.com/Orient-Watches-Open-Heart-Watch.html
Orient Watches Power Reserve : http://www.hotwatchshop.com/Orient-Watches-Power-Reserve-Watch.html
Orient Watches Retro Future : http://www.hotwatchshop.com/Orient-Watches-Retro-Future-Watch.html
Orient Watches Skeleton : http://www.hotwatchshop.com/Orient-Watches-Skeleton-Watch.html
Orient Watches Sport Auto : http://www.hotwatchshop.com/Orient-Watches-Sport-Auto-Watch.html
Orient Watches Wide Calender : http://www.hotwatchshop.com/Orient-Watches-Wide-Calender-Watch.html
Orient Watches World Time : http://www.hotwatchshop.com/Orient-Watches-World-Time-Watch.html
Orient Women's Watches : http://www.hotwatchshop.com/Orient-Womens-Watches-Watch.html Tag: convert PDF file to excel 2007 file Tag: 141878
problems when saving as comma delimited text file
Using Excel 2007.
I'm having problems trying to save a worksheet as a text file, when the
worksheet contains text like : 329300041118 .
Steps to reproduce :
1) open excel (you should then be looking at an empty spreadsheet)
2) into cell 1A, paste the text : 329300041118 . The cell should display :
3.293E+11 .
3) Save As -> Other Formats -> CSV comma delimited
When you look at the CSV file in a text editor (e.g. notepad), it shows :
3.293E+11
What I want to see is : 329300041118
I realise I can "fix" this by using "Format Cells" to control the precision,
but is there some way of getting this to work without having to set this on
a spreadsheet by spreadsheet basis ?
i.e. Is there some way to get excel to export the straight text of the data,
without it trying to round what it interprets as numeric values at a global
excel level ?
TIA Tag: convert PDF file to excel 2007 file Tag: 141876
Hot Shop Patek Philippe Gondolo Watches - Patek Philippe Minimum
Hot Shop Patek Philippe Gondolo Watches - Patek Philippe Minimum Price
Hot Watch Shop : http://www.hotwatchshop.com
Patek Philippe Watches : http://www.hotwatchshop.com/Patek-Philippe-Watches.html
Patek Philippe Gondolo Watches : http://www.hotwatchshop.com/Patek-Philippe-Gondolo-Watches-Watch.html
Patek Philippe Gondolo Watches All Products :
Patek Philippe Gondolo 18kt White Gold Mens Watch 5109G :
http://www.hotwatchshop.com/Patek-Philippe-wristwatch-10301.html
Patek Philippe Gondolo 18kt Rose and White Gold Mens Watch 5099RG :
http://www.hotwatchshop.com/Patek-Philippe-wristwatch-10302.html
Patek Philippe Gondolo 18kt Yellow Gold Mens Watch 5109J :
http://www.hotwatchshop.com/Patek-Philippe-wristwatch-10303.html
Patek Philippe Gondolo 18kt Rose Gold Mens Watch 5111R :
http://www.hotwatchshop.com/Patek-Philippe-wristwatch-10304.html
Patek Philippe Gondolo Platinum and 18kt Rose Gold Mens Watch 5111PR :
http://www.hotwatchshop.com/Patek-Philippe-wristwatch-10305.html
Patek Gondolo Gemma White Gold Ladies Watch 4991G :
http://www.hotwatchshop.com/Patek-Philippe-wristwatch-10306.html
Patek Gondolo Gemma White Gold Ladies Watch 4981G :
http://www.hotwatchshop.com/Patek-Philippe-wristwatch-10307.html
Patek Gondolo Gemma Rose Gold Ladies Watch 4991R :
http://www.hotwatchshop.com/Patek-Philippe-wristwatch-10308.html
Patek Philippe Gondolo 18kt White Gold Mens Watch 5489G :
http://www.hotwatchshop.com/Patek-Philippe-wristwatch-10403.html
Patek Philippe Gondolo 18kt Rose Gold Mens Watch 5489R :
http://www.hotwatchshop.com/Patek-Philippe-wristwatch-10404.html
Patek Philippe Gondolo 18kt Yellow Gold Mens Watch 5010J :
http://www.hotwatchshop.com/Patek-Philippe-wristwatch-10405.html
Patek Philippe Gondolo 18kt White Gold Black Mens Watch 5010G :
http://www.hotwatchshop.com/Patek-Philippe-wristwatch-10406.html
Patek Philippe Gondolo 18kt White Gold Diamond Mens Watch 5025G :
http://www.hotwatchshop.com/Patek-Philippe-wristwatch-10407.html
Patek Philippe Gondolo 18kt White Gold Mens Watch 5111G :
http://www.hotwatchshop.com/Patek-Philippe-wristwatch-10408.html
Patek Philippe Gondolo 18kt White Gold Diamond Blue Mens Watch 5112G :
http://www.hotwatchshop.com/Patek-Philippe-wristwatch-10409.html
Patek Philippe Gondolo Platinum Mens Watch 5109P :
http://www.hotwatchshop.com/Patek-Philippe-wristwatch-10410.html
Patek Philippe Gondolo 18kt Yellow Gold Mens Watch 5111J :
http://www.hotwatchshop.com/Patek-Philippe-wristwatch-10411.html
Patek Philippe Gondolo Serata 18kt White Gold Diamond Blue Ladies
Watch 4972G :
http://www.hotwatchshop.com/Patek-Philippe-wristwatch-10412.html
Patek Philippe Gondolo 18kt White Gold Pearl Bracelet Diamond Ladies
Watch 4868G-1G :
http://www.hotwatchshop.com/Patek-Philippe-wristwatch-10413.html
Patek Philippe Gondolo 18kt White Gold 3-Strap Diamond Ladies Watch
4869G-1G :
http://www.hotwatchshop.com/Patek-Philippe-wristwatch-10414.html
Patek Philppe Gondolo 18kt Rose Gold Vanilla Strap Diamond Ladies
Watch 4868R :
http://www.hotwatchshop.com/Patek-Philippe-wristwatch-10415.html
Patek Philippe Gondolo Gemma 18kt White Gold Diamond Rose Ladies Watch
4992G :
http://www.hotwatchshop.com/Patek-Philippe-wristwatch-10416.html
Patek Philppe Gondolo 18kt White Gold Taupe Strap Diamond Ladies Watch
4868G :
http://www.hotwatchshop.com/Patek-Philippe-wristwatch-10417.html
Patek Philippe Gondolo 18kt Rose Gold Pearl Bracelet Diamond Ladies
Watch 4868G-1R :
http://www.hotwatchshop.com/Patek-Philippe-wristwatch-10418.html
Patek Philippe Gondolo Serata 18kt White Gold Diamond Ladies Watch
4973G :
http://www.hotwatchshop.com/Patek-Philippe-wristwatch-10419.html
Patek Philippe Gondolo 18kt Rose Gold Mens Watch 5109R :
http://www.hotwatchshop.com/Patek-Philippe-wristwatch-10420.html
Patek Gondolo Gemma Rose Gold Ladies Watch 4981R :
http://www.hotwatchshop.com/Patek-Philippe-wristwatch-10421.html
Patek Complicated Gondolo Calendario Yellow Gold Men's Watch 5135J :
http://www.hotwatchshop.com/Patek-Philippe-wristwatch-10422.html
The Same Patek Philippe Watches Series :
Patek Philippe Twenty~4 Watches : http://www.hotwatchshop.com/Patek-Philippe-Twenty4-Watches-Watch.html
Patek Philippe Grand Complications Watches :
http://www.hotwatchshop.com/Patek-Philippe-Grand-Complications-Watches-Watch.html
Patek Philippe World Time Watches :
http://www.hotwatchshop.com/Patek-Philippe-World-Time-Watches-Watch.html
Patek Philippe Complicated Timepieces Watches :
http://www.hotwatchshop.com/Patek-Philippe-Complicated-Timepieces-Watches-Watch.html
Patek Philippe Aquanaut Watches : http://www.hotwatchshop.com/Patek-Philippe-Aquanaut-Watches-Watch.html
Patek Philippe Calatrava Watches : http://www.hotwatchshop.com/Patek-Philippe-Calatrava-Watches-Watch.html
Patek Philippe Gondolo Watches : http://www.hotwatchshop.com/Patek-Philippe-Gondolo-Watches-Watch.html
Patek Philippe Golden Ellipse Watches :
http://www.hotwatchshop.com/Patek-Philippe-Golden-Ellipse-Watches-Watch.html Tag: convert PDF file to excel 2007 file Tag: 141873
Opening Excel causes 70 worksheets to open
When I click on the icon Excel opens and then begins to open 70 worksheets.
After 70 worksheets are open it stops. It seems to be normal after that
except for the 70 open worksheets. Help? Tag: convert PDF file to excel 2007 file Tag: 141866
Bizarre Excel 2007 behavior solved
I have a spreadsheet created in Excel 2003 that has two columns with
conditional formatting such that if the entry is zero no data appears in
those columns. There is no conditional formatting in any other columns of
this spreadsheet that has many embedded formulae.
When that spreadsheet is opened in Excel 2007, whether or not it is
converted to the 2007 file structure or used in compatibility mode as a 2003
format spreadsheet, Excel 2007 does not let me see data being entered into
any cell as I type. I can see the key strokes appearing in the formula bar
but the cursor remains in the cell. If the data entered is one where
auto-complete applies then part of the cell turns black.
This spreadsheet behaves this way in Excel 2007 run under XP or Vista and
regardless of whether the cell has any or no embedded formulae.
The only way to correct this is to turn off conditional formatting for the
entire sheet, even though only two columns have any conditional formatting
in the entire spreadsheet. I can then reapply the conditional formatting to
those two columns and everything seems to work as it should. This holds true
whether I maintain the spreadsheet in 2003 format or convert to 2007 file
format.
It took me more time than it was worth to figure that out with no help from
Microsoft.
I want to congratulate the geniuses who designed the Ribbon of Abomination
for gifting me this additional annoyance in Excel 2007.
I would also like to note that on every computer I have used, ranging from
single to Quad core machines, Excel 2007 opens and performs disk access
operations notably slower than Excel 2003 in both XP and Vista, the latter
imposing time by your wristwatch performance penalties of its own. I presume
the geniuses who programmed Vista gifted Office 2007 with the fruits of
their misbegotten labors.
If Microsoft cannot deliver performance or usability what advantage is there
to using local Excel over using web based applications? With the Ribbon of
Abomination Microsoft has destroyed familiarity with the product as reason
for users to keep using Excel.
I cannot be alone in looking at other options. Tag: convert PDF file to excel 2007 file Tag: 141861
question and answerwith Excel
Any pointers would be most appreciated. I'm wanting to create exams online
and have been told Excel will do this. For instance 20 questions with each
question having to choose the correct answer from a number of possible
answers. I want whoever to go through trhe 20 questions and only know how
many they got right by submitting at the end. They won't know which they
got right, only the number they got right. Any advice where to start with
Excel would be brilliant.
Best,
Paul B. Tag: convert PDF file to excel 2007 file Tag: 141857
Wrap Text and Blank Lines
I have a VBA script in Excel that fills data from one spreadsheet to
another. In the output file some of the cells are having the
formatting .WrapText = True. Now I have the strange situation that
some cells display half a line or an entire line of white spaces at
the end, even though in the text no blank or special characters are
present.
I'd like to get rid of the white space or at least understand why this
is happening. I have looked at the size of the cells, the number of
characters but I have not yet found the trigger for the phenomenon.
I have been searching quite some time now and everybody seems to have
the same issue. Unfortunately I have not yet found the solution.
That's why I ask again.
Any ideas are welcome
mat Tag: convert PDF file to excel 2007 file Tag: 141848
Change Uppercase to Lowercase
I have a spread sheet created with Excel 2007. One colum has first and last
names in all caps. How can I convert the first letter for each name to be
caps and the rest of the letters to be lowercase? I want to do the whole
colum at once.
Thanks
--
----------------------------------------------------
This mailbox protected from unsolicited email by Spam Alarm
from Dignity Software http://www.dignitysoftware.com Tag: convert PDF file to excel 2007 file Tag: 141844
Excel 2007 - file double clicked in Win Explorer opens Application, but not workbook
I have had Excel 2007 for a little over a year. A few weeks ago, I noticed
that when I double-clicked on an Excel spreadsheet from within Windows
Explorer, Excel opened but the workbook did not. Neither did the "Book1"
workbook. It looked just as Excel would look if you opened it and then
exited the workbook, leaving the application open.
If Excel is opened in this manner and then I double-click a second time on
the workbook, then it opens.
I do not think that this is related to SP1, but SP1 was automatically
installed on 4/11/08. I cannot recall if this problem cropped up before
that date, but I think that it did and it does seem unlikely that a service
pack update would cause such an obvious error.
Does anybody have any ideas as to what could cause such a problem?
Thanks in advance.
Alan Tag: convert PDF file to excel 2007 file Tag: 141840
import stock prices
I keep trying to import an individual stock price to a single cell but the
Data/Import External Data/New Web Query system seems to only allow me to
only import a whole table which of course changes my whole spread sheet.
Any suggestions on how to just import only the current stock price to a
single cell?
Ron Patterson Tag: convert PDF file to excel 2007 file Tag: 141829
Capturing data
I am working on a registration form for a meeting. I currently have a sheet
set up as a registration form with cells for various fees to be paid by the
registrant. My current plan is to use a seperate sheet for each registrant
(approx 100 - 150) all within the same workbook.
The question is: What would be the best way to summarize the various
amounts paid and the numbers of people registered for each event all onto
one sheet? I looked at using a Pivot Table, but apparently my data on the
registration form is not arranged correctly. I have been looking at using a
summary sheet within the same workbook, but have not been able to come up
with a formula that will add up the numbers from all of the sheets.
Thanks for any help.
Charlie Tag: convert PDF file to excel 2007 file Tag: 141825
Problem with conversions
There are problems with Exel 2007 converting to 2003 where worksheet
are missing, math is done wrong, numbers magically appear in formulas
and other numbers seem to change in the conversion. From what I
understand, this may be restricted to educatioinal versions given to
schools. From some of the other blogs, I gather that 2007 is becoming
a bit of a pain. There should be a fix for this from the big and
mighty Microsoft. Apparently, a lot of students and faculty are fuming! Tag: convert PDF file to excel 2007 file Tag: 141821
copy images with worksheet
i am trying to copy some data from an excel sheet to an image
program. my excel sheet consists of data and seperate images. when i
copy and paste only some of the images are copied. What setting do i
need to change to copy all images with the cell contents. Tag: convert PDF file to excel 2007 file Tag: 141819
Help with RATE function
My task is to deteremine an equivalent loan interest rate to a lease payment.
ie: Lease payment term is 60 months, payment is $135.35, funded amount is $5,000
I've been trying to use the RATE function, but need some help entering the data
properly. Every manner I've tried results in a NUM error.
=RATE(60,(133.35),5000) is my last feeble attempt
(I am referrencing cells, I just enered the numbers for clarity.
I tried the payment as a negative after reading another post.
I left out the $ formatting sign, just in case.
What am I missing? Tag: convert PDF file to excel 2007 file Tag: 141818
OT : Access query
Which would be the best newsgroup to ask in?
I tried microsoft.public.access, but that groups looks completely dead.
--
Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me) Tag: convert PDF file to excel 2007 file Tag: 141813
Pivot table question: Sorting the subgroup in a pivot table (when
Hello:
I have created a pivot table which has a one subgroup in the second
column from the left. It uses the Top 10 option, so there are 10
subgroups
So my data looks something like this:
Group 1 50
Subgroup 1a 10
Subgroup 1b 40
Eight more subgroups
Group 2 30
Subgroup 2a 20
Subgroup 2b 10
Eight more subgroups
What I would like to do is sort by THe totals for Group 1, but then
also sort by the subgroups, based on the values for each subgroup
(similar to the "Sort by, then by.." option in a normal table).
So, the top 10 Groups will show up at the top, and then the subgroups
will also be sorted descending.
Does anyone know how I can accomplish this?
Thanks for any suggestions Tag: convert PDF file to excel 2007 file Tag: 141808
Worksheet missing?
I have Excel 2007 and my wife has Excel 2003. I regularly get Excel files
mailed to me from work that have two Worksheets of two pages each for a
total of four pages. When I open these files on my wife's machine I can see
both Worksheets and all 4 pages. When I open it with mine (2007) I can only
see one Worksheet and 2 pages. Half the document is missing.
Any clues?
Thanks,
Tom Tag: convert PDF file to excel 2007 file Tag: 141801
If(cell) "contains" certain words...
Certainly there is a simple way to find out if a cell that has text in
it contains a certain word. For example, cell A1 is populated with
the words "Houston, TX, USA." In Cell A2 I want a function that can
look into A1 to see if the word "Houston" is contained in there. If
it is, I would have the function return a value or some other
"text."
If only there were a symbol for "contains" if would be a breeze.
=If(A1[symbol]"Houston",1,0). Who has the answer to this? Tag: convert PDF file to excel 2007 file Tag: 141798
Excel 97 and 2007 on same computer
How can I *re-set* Windows XP SP2 to open all of my Excel files
(.xls.xlt.csv) in Excel 97 when double-clicking?
I also have Office 2007 installed inorder to sample the program, but not to
use as my primary office application at this time.
Thanks.
-Dennis
--
Dennis Kessler
http://www.denniskessler.com/acupuncture Tag: convert PDF file to excel 2007 file Tag: 141797
Add-ins in Foreign language
We are running Office 2007 with several Language Packs installed on the
systems. The problem I'm having is in Excel when I go to select an Add-In.
Even though I have all my settings set to English in the Language Options,
the add-ins are all in Foreign Languages. To make it even more confusing is
when I log off and back on the Language the plug-ins are in change.
Instead of Analysis ToolPak I'll see "Herramientas para analisis" or it will
be in russian. While I can click on the link because I can figure out what
that specific add-in is, the problem because the fact that while the rest of
Excel is in English, all the functions for the Analysis ToolPak are in the
foreign Language. So I can't interprete what function is what, or what the
error messages say.
Any Ideas on how to correct this, as it is a concern for us trying to use
the langauge packs and the Add-Ins.
Thank you in advanced. Tag: convert PDF file to excel 2007 file Tag: 141790
Extract data from list -exluding blank cells
Tried the C.Pearson site.... Couldn't get that formula to work.
=IF(ROW()-ROW(NoBlanksRange)+1>ROWS(BlanksRange)-
COUNTBLANK(BlanksRange),"",INDIRECT(ADDRESS(SMALL(
(IF(BlanksRange<>"",ROW(BlanksRange),ROW()+ROWS(BlanksRange))),
ROW()-ROW(NoBlanksRange)+1),COLUMN(BlanksRange),4)))
Need to sort order of results from another formula into a list without
blank cells.
List #1 List #2
cherries cherries
plums plums
apples apples
oranges
oranges grapes
grapes lemons
lemons Tag: convert PDF file to excel 2007 file Tag: 141784
Free! Learn MS Excel - Video: How to Plot a Chart with Microsoft
The following is a video that demonstrate to you:
How to plot a chart with Microsoft Excel.
http://raymondlamsk.blogspot.com/2008/05/free-learn-microsoft-excel-how-to-plot.html
I hope it helps you in one way or another. Tag: convert PDF file to excel 2007 file Tag: 141781
Adding Data into Table
Hi all,
I have tables of calling rates. I have 5 tables as follows:
_tblAccount - It's an account type such as pre paid or post paid
_tblEmployees
_tblProvider - list of all the providers. I have 7 so far.
_tblProviderRates - I have different rates from 7 different providers.
_tblReport - This is a detail table. I am importing EmployeeID,
ProviderID, ReportDate, CountryCode, and CallingSec in this table.
I want to include rates in this detail table from tblProviderRates.
For example, I have customers who have used 3 different providers with
3 different rates. I want to show them in my tblReport table.
Now, they supposed to match with calling codes as for example again;
provider A rates for CountryCode 1 is 0.009 and provider B rates for
CountryCode 1 is 0.010. I want to see these rates in my tblReport.
Once I have this I can do some artihmetic.
Thanks. Tag: convert PDF file to excel 2007 file Tag: 141768
controlling active cell
I have a spreadsheet with 4 columns. I am scanning some bar codes
into the 2nd and the 3rd column. I want to the active cell to change
to the 3rd cell after I scan the bar code for the second column. This
is obviously easy to do. But I want it go to the 2nd column of the
next line after I scan the bar code for the 3rd column. Is there any
way to do this?
Step 1
Description Tag # Serial # Pallet
x
Step 2
Description Tag # Serial # Pallet
x x
Step 3
Description Tag # Serial # Pallet
x x
Description Tag # Serial # Pallet
x Tag: convert PDF file to excel 2007 file Tag: 141767
SP1
I'm currently downloading SP1 for the Microsoft Office Suite 2007.
Does anyone know if this addresses the issues of Excel
2007--slowness--hangups, etc. Tag: convert PDF file to excel 2007 file Tag: 141764
Export to comma-delimited format doesn't seem to work
I apologize for the elementary question. I have an Excel spreadsheet which
is simply a list of email addresses. I want to export them to a format
allowing me to paste them into the "To" field of an email. (In case you're
concerned, this is not unsolicited bulk commercial email). I've been able to
export them to a .csv format, but it doesn't seem to have the commas, which
confuses me and my email software.
Any help will be much appreciated.
--
Patty Ayers | www.WebDevBiz.com
Free Articles on the Business of Web Development
Web Design Contract, Estimate Request Form, Estimate Worksheet
-- Tag: convert PDF file to excel 2007 file Tag: 141763
Numbering Unique Values in a list....
I have a list of names. Is there any way to count the unique names in
a corresponding row, and if a name repeats, list the same number it
had before?
Names #
Larry 1
Larry 1
Larry 1
Jim 2
Jim 2
Jane 3
Jane 3
Larry 1
Larry 1
Jane 3 Tag: convert PDF file to excel 2007 file Tag: 141762
Sum based on like items in two list
In one column, I have who(name).
The next, item sold.
The last I have the sales amount.
a) What formula can i use to extract items that are unique to Name +
Items sold and break them out in a column?
b) How can I sum totals for the extracted criteria?
a. a. b
Name Item Sold Sales Amount <break> Name Total
Items Sold Sales Amount
Larry Juice Cups $5
Larry Juice Cups $10
Larry Juice Cups $5
Larry Pickles $5
Amy Pickles $5
Amy Pickles $5
Amy Juice Cups $5
Amy Juice Cups $5
Larry Pickels $5
Derron Juice Cups $20
Derron Juice Cups $5
Derron Juice Cups $5
Derron Juice Cups $5
Derron Juice Cups $5
Thanx Tag: convert PDF file to excel 2007 file Tag: 141760
Converting hours into numbers
How to convert hours using 00:00 format into standalone numbers, for
example 08:30 = 8.5h so I could sum these numbers at the bottom to
learn how many hours are in total.. Please help Tag: convert PDF file to excel 2007 file Tag: 141755
Anyone know how to convert a PDF file to an Excel 2007 file? Need help.
Thanks