|
Daily Racing Form: Horse racing
10 aug 06 1459 hrs.
Greetings..
I am new to site..and to the use of Excel. I have recently started
putting information from the "Daily Racing Form" into an Excel
spreadsheet. I will use this data to work out simple and later complex
formulas for extracting desired data.
I have made cells long enough to hold each field, and there will be a
weekly entry. What I don't understand is how I will se...
|
3 |
11.08.2006 20:33:01 |
|
|
IF & Vlookup
Afternoon,
I know some one out there might be able to assist me with my dilemna.
In Sheet1 I have a list of 8 digts id numbers in column A and in sheet2
is where I am doing the lookup from.
The formula below is working great. I picked up from this website.
=IF(ISNA(VLOOKUP(A6,Schedule!$A$13:$E$1463,3,FALSE)),"Invalid
Number",VLOOKUP(A6,Schedule!$A$13:$E$1463,3,FALSE))
What I ne...
|
14 |
11.08.2006 16:54:02 |
|
|
How do I perfom a character count in a single cell in Excel?
I need to peform a character count for certain cells in Excel. I found a
formula for counting words within a cell but not the number of specific
characters. ...
|
2 |
11.08.2006 16:49:02 |
|
|
How do I make a soccer table that updates auto in Excel?
I recently got a chart off someone with the World Cup games & a table for
each group that updates automaticaly when I enter scores. Liked the idea to
create one for my favorite team. Tried to do one but no success. Can anyone
out there please guide me into making one, providing not too difficult? ...
|
1 |
11.08.2006 16:40:02 |
|
|
Minutes
Hi there,
I have a timesheet which works out working hours e.g. Time in 8:52 time out
12.00 the answer is 3.13 so I then manually calculate the minute bit 0.13*60
which equals 8 minutes. Is there any clever way to calculate this to show
hours and minutes?
TIA
--
Bobby...
|
6 |
11.08.2006 15:33:53 |
|
|
Multiple functions in a cell help
I am using Excel 2003 and having trouble figuring out the formulas. What I am
trying to do is add a total of 6 cells in a row. Each cell has a different
formula that comes up with a certain value once all cells are added together.
Example:
cell A= inserted value*10
cell B= inserted value*2
cell C= inserted value
...
|
6 |
11.08.2006 13:23:02 |
|
|
Problem Calculating Various Month Totals ??
hello,
I need a formula that will SUM values for particular Months within a
column (B4:B1000)...
I am trying to use a formula that will identify the first 3 letters of
the month and then add the currency (G4:G1000) for those months only..
every formula I am attempting to use is not working..:confused:
I used this to calculate the totals for February, but it fails:
=SUMIF(B4:B1000,"F...
|
4 |
11.08.2006 04:58:15 |
|
|
Event viewer(System)
Good day!
im using windows xp-sp2,when I try to save an shared excel(excel2000-sp3)
file on the network,i cannot click the standard button on the excel, the
file menu,etc.
i check the task manager all application are running.
then i check the event viewer, on system, i have this warning - "The
redirector failed to determine the connection type."
What does it mean?
...
|
1 |
11.08.2006 03:08:20 |
|
|
vlookup and max ?
I want to get the max # from a worksheet with multiple rows of my key value.
WM-DV028 Windows WDW 25 3/29/2006
WM-DV028 Windows WDW 25 3/30/2006
WM-DV028 Windows WDW 8 3/31/2006
WM-DV028 Windows WDW 3 4/3/2006
WM-DV028 Windows WDW 4 4/4/2006
WM-DV028 Windows WDW 7 4/5/2006
WM-DV028 Windows WDW 24 4/6/2006
WM-DV028 Windows WDW 32 4/7/2006
WM-DV028 Windows WDW 8 4/8/2006
th...
|
3 |
11.08.2006 02:54:01 |
|
|
Why can't I insert a row in my worksheet?
I am trying to insert a row of simple data into my worksheet. When I do, I
get the following message:
"This operation is not allowed. The operation is attempting to shift cells
in a list on your worksheet."
I don't understand this. I have created lists from the worksheet but don't
have any now. Why does it think I have a list on my worksheet? And, if I have
one, how do I remove it?
...
|
10 |
11.08.2006 02:32:53 |
|
|
Copy data in multiple worksheets
How do I put the total of a row(column) of numbers from one worksheet to
another worksheet?
Mahalo.
Karen...
|
3 |
10.08.2006 23:18:01 |
|
|
How do I create a spreadsheet?
I need create a simple spreadsheet. To show the total number of tasks that
was comlpeted that week. Can you help me?...
|
4 |
10.08.2006 22:13:00 |
|
|
spreadsheet
I'm making a spreadsheet and would like to keep the lines when I print it.
How do I do this. Thank you...
|
4 |
10.08.2006 21:45:13 |
|
|
Find first previous cell with data
Hi, I am not "fluent" in Excel, so please make any answers "dummy" level.
I have a running balance column that spans multiple pages and I am trying to
get the last balance from the previous page onto a cell in the following page.
Additionally, there are column headings at the beginning of each page and I
have all cells (except column heading cells) in this balance column
conditionally ...
|
4 |
10.08.2006 20:10:12 |
|
|
automatic comas for numbers greater than 999
I want exel to automaticly add comas for numbers greater than 999. How do I
accomplish this?...
|
2 |
10.08.2006 20:06:39 |
|
|
Problem with DSUM (Excel XP)
The formula causing me fits is "=DSUM(Grants,Grants!$E$10,C74:D75)*12"
(without the quotes); it's from a budget worksheet I'm adapting for our
org's use.
I keep getting a "#VALUE" error. When I simplify it down to retrieving a
single value from the worksheet, it does fine. But a DSUM causes the error
every time. I've used the forumla checker but it runs out to everything in
parenthe...
|
2 |
10.08.2006 17:40:15 |
|
|
How to rotate table clockwise
I have a table with field labels in column A (A2 to A16). I'd like to rotate
this table clockwise, i.e. have the field labels on the top of the table in
A2 through I2. I tried to build a PivotTable to no avail... Does not matter
what I click on or highlight in the original table - the whole table, the
column A or just the A2 cell. For some reason, only the text in the A2 or
the items in ...
|
4 |
10.08.2006 17:08:34 |
|
|
cell reference
I have a list of numbers in column A. I wish at the bottom to return the
maximum value in column A using =max(a1:a100) but i also want the cell
reference of this value. how can i do this.
thanks
...
|
3 |
10.08.2006 16:18:47 |
|
|
Data import issue from Access
Carriage return (Ctrl+Return) in access data in one cell is imported to "I"
into the place of carriage return. Some one have magic idea to import same as
excel?
Access source data
I hope this work
A) It should work this way
After import to Excel
I hope this work | A) It should work this way ...
|
1 |
10.08.2006 15:37:03 |
|
|
i need to make a tally
i have a table that has cells in colimns that display letters, for every 'k'
i need to add 1 to a total...
|
2 |
10.08.2006 13:31:03 |
|
|
Copy Paste Operations
Just look at all the copy paste operations available in excel by having
a look at this post
http://xlmaster.blogspot.com
...
|
1 |
10.08.2006 12:53:38 |
|
|
I Need Help! Asap.
I am trying to create a quote sheet.
I have located similar information however it doesn't make sense. I
tried to used nested IF statements but the limit of 7 doesn't work out
very well. Then I tried to explore Macros but I have no idea how those
work. So I really need some help.
Right now I have three things.
Amount of Users - Cost
Based on the amount of users, it produces a cost ass...
|
7 |
10.08.2006 12:22:01 |
|
|
New
Im just curious, Im somewhat new to Excel.
I am starting to do stock market trades.
For Tax purposes, I have to report my cost - and the Revenue gained so that
I can be taxed on only the profit. Not only that, I have to report if it is
long term or short term.
In order to help me calculate Cost, Is it not best to set up a FiFO system?
if that is the best way, then how do I impliment a ...
|
2 |
10.08.2006 12:16:02 |
|
|
Data>Validation>List - Unique Entries
Hello! Friends
I have a list of names containing duplicate names and empty cells.
Using Data > Validation > List
I want get a drop down list of unique entries having no empty cells.
How can do this??? Please help me......
|
3 |
10.08.2006 10:54:02 |
|
|
Most hours worked
Hi
I have a workbook containing colleagues' daily hours worked on separate
sheets. I have then created a worksheet totalling how many hours per
week each person has worked. How do I list the names in order of who
has worked the most hours? I have the names in a row and the hours in
the columns. I think I need some kind of auto sort that will display
the names.
thanks
Steve
--
spankydata
---...
|
4 |
10.08.2006 08:51:06 |