|
can i convert a worksheet with data into a calander
I have received a worksheet that has some data that i need to see in a form
of a calander can i convert it??...
|
1 |
25.09.2006 22:52:02 |
|
|
how do i set up a 'rolling shift pattern' worksheet?
Using Excel 2003, i want to be able to rotate a list, i.e - columns of
weeks/names/hours to be worked.
i want it to show, for example:-
week 36 and that corresponding name and hours to be worked.
then the following week it show week 37, name and hours, etc. at the top of
the page.
Can this be done automatically by excel or will i still have to keep doing
it manually?
...
|
1 |
25.09.2006 22:28:01 |
|
|
I need a specific formula in excel
Educational use:
Using excel to set pupil targets. Each target level is subdivided into three
sub levels.ie Level 3 a,b,c; Level 4 a,b,c etc. Is there an excel formula
that could automatically raise a level/sublevel by a margin of two, ie raise
a level 3b to a 4c etc?
Any help would be appreciated...
|
2 |
25.09.2006 22:08:21 |
|
|
formulas using if parameters
I need to change the color of the font in a cell that equals my true value
and my false value needs to stay the same. ie, if overbudget, i need the
cell color to be red, if at or underbudget, i need the cell color to stay
black. Is this at all possible?...
|
4 |
25.09.2006 21:58:17 |
|
|
copying date from one sheet to another work sheet
Hi,
I have Date column on sheet1 and i would like Date Columns to propagate
on other sheets
when i enter this formula on the sheet2
=A1
it displays 01/01/1900 if cell is empty on sheet1
If cell is empty i dont want to display that 01/01/1900 thing on the
other sheet
If sheet1 date column cell is empty and other sheet date column should
be empty no 01/01/1900 thingg.....
how...
|
14 |
25.09.2006 21:56:29 |
|
|
mutiply by either REG or OT hours, and SUM!
I am trying to figure out a way to quickly generate a gross payroll number
without the aid of a 'helper' row, which won't work this situation. I have
about 60 employees.
Sample:
NAME(A) PAY(B) REG(C) OT(D)
Joe Worker 8 40
Jane Workr 8
Big Slacker 7.5 15
MR No Life 10 80 12
Mr. No Life also gets overtime at 1.5x his normal rate. The correct sum for
this would be $1412.50.
...
|
7 |
25.09.2006 21:34:03 |
|
|
Last column entry lookup.
Trying to bring the last entry made in column F (from a checking balance
workbook) The formula works OK for the first sheet but doesn't work when I
copy it another sheet.
=LOOKUP(9.99999999999999E+307,F:F)
It will, however, return the value in cell F307.
What am I dong wrong??
Thnx
Bg
...
|
2 |
25.09.2006 21:25:38 |
|
|
How do I insert a drop down list button from an excel worksheet?
I an revising a schedulig form and need to create some drop down menus on one
spread sheet from data on another worksheet. How do I insert the drop down
button on the schedule from the list on the data sheet?
I created a list of time options and employee options and need to have them
on a pull down button on the schedule so that various times or employees can
be selected for the schedu...
|
3 |
25.09.2006 21:19:27 |
|
|
Pull last word from a text string in Excel
Is there a way to pull just the last word from a text string in Excel?
I have a sheet with a column of text descriptions that are various lengths
and the last words in each cell are various lengths. Basically I want
everything to the right of the last space.
Thanks!...
|
9 |
25.09.2006 21:13:13 |
|
|
Excel 2007 (Beta) Auto Filter
When I had Office 2007 (Beta) installed, I did not like the new auto
filtering options. I was used to being able to customize my filter with the
"contains", "begins with" etc. options. With the new version, these are not
available. One must check mark every instance of what you want to filter
without the use of "wild cards"....
|
2 |
25.09.2006 21:08:30 |
|
|
ADDING A PRINT CONTROL BUTTON
I have a work book that i enter everthing on the first sheet and it puts
information in the other sheets in the work book. how can i add a button to
the first sheet to make the other sheets print there are 7 sheets in total i
need for 6 to print when clicking on a button. Could some one tell me if
this is possible thanks...
|
2 |
25.09.2006 20:55:39 |
|
|
if function and ifblank() function
Hi List,
Here is what I am looking for:
Column A Column B Column C
Row 1 1000 Blank(hasF) 100%
Row 2 Blank(hasF) Blank(hasF) ---
Row 3 100 10 (100-10)/100%
if Column A has number, Column B is blank, Column C shows 100%; if both
blank shows '---'; if both have numbers, do the calculat...
|
4 |
25.09.2006 20:47:01 |
|
|
How to have information auto input if cell = yes
I need to be able to enter information on one sheet in a workbook and set a
condition (ex: data in column 3 = yes) to determine if the information in
that row should be automatically transfered to other worksheets.
...
|
1 |
25.09.2006 20:45:02 |
|
|
Formula not copying down
I am currently trying to copy a formula down for a total of 734 rows and
across several columns. For some strange reason it stops at 641 rows. Once
I drag the formula in, the cell is just blank. I have tried a new worksheet
and also tried retyping the formula. Nothing works.
I have used this formula before in a much larger worksheet with thousands of
rows. Does anyone have any clue...
|
7 |
25.09.2006 20:44:01 |
|
|
top ten customers by transaction count by product
I have a data dump. each row represents a single transation for a product by
a customer. There are 15 products represented in the data dump. So product 1
could have 100+ transactions/rows by customer A. And custmer A could have
bought all 15 products in multiple transactions.
I would like to be able to display the top ten customers for each of my
product groups. Does this make sense...
|
3 |
25.09.2006 20:31:02 |
|
|
Re: Need big help with look up....is this possible
Excelent,
Could you explain a little more on how to use this. Its a little over my
experience level, but I'd love to know how to do this. So far I have
created a new module and pasted you code. I then changed each Sheet1! to
Losses! (the name of the worksheet with the data). This is the only change
I made on your code. I get an error saying Compile Error: Expected: line
number or...
|
16 |
25.09.2006 20:08:39 |
|
|
ranking based on criteria
I am creating a spreadsheet that shows the results of a marching band
competition. The awards are given by class, 1st, 2nd and 3rd place. I will
have the following:
Name Class Score
School 1 A 99
School 2 A 98
School 3 AA 52
etc. If I knew that there would always be X schools in a class, the ranking
formula would be eas...
|
2 |
25.09.2006 20:03:01 |
|
|
Removing 1-2 caharacters
I have a lengthy licst of names I need to use for a mail merge. The first
names are seperated from the last, that's great. however, many of the first
names have a mibddle initial and some have a period following the initial. Is
there a way I can remove the last 2 characters of a string? I don't want the
initilals included in the merge.
Examples of the list:
Marvin P.
Mary R
etc.
Thank...
|
2 |
25.09.2006 20:03:01 |
|
|
calculate the sum of characters in a cell
calculate the sum of characters in a cell...
|
9 |
25.09.2006 19:51:02 |
|
|
How to calculate time after converting 12.22 to 12:22
First I'm trying to enter time (Hours.Minutes) like 12.22 or 123.54 instead
of 12:22 and 123:54 for fast entries because I have many of them. Add all of
them after.
I use the formula in cell A2: =INT(A1)/24+MOD(A1,1)/14.4 to convert in time
format([H]:mm
Everything is working well until I want to multiply the results by money.
Example: Data: 125.36 Results after converting: 125:36 If I...
|
2 |
25.09.2006 19:37:01 |
|
|
Concatenate & Date
I am trying to create a macro that saves a spreadsheet to a name based
on data in a few cells.
For example, if I have Date and ProjectName in two cells, I want the
macro to save the worksheet as DateProjectName.csv.
I tried to Concatenate these values into one cell. From there I was
goint to use the following the Save As that value using:
Public Sub SaveAsA1()
ThisFile = Range("A...
|
3 |
25.09.2006 19:26:02 |
|
|
Text Restrictions
Using Excel 2000 and without having to get into Macros, is there a way to set
a validation such that only an uppercase character can be enterted into the
cell? For example, the cell would allow an uppercase "X" but nothing else?
Thank you for all help / suggestions,
--
LPS...
|
4 |
25.09.2006 19:23:02 |
|
|
sumproduct with one variable criteria?
hi, i am interested doing something like this:
=SUMPRODUCT(--(B1:B12="criteria 1");--(M1:M12=B29);--(I1:I12))
where B29 represent a value that i introduce in cell b29
thanks in advance...
|
12 |
25.09.2006 18:49:22 |
|
|
Conditional Scenario of Text value
Hi
I was wondering if you could help me out in here. For example, I have this
scenario of a database of 5000 employees who do many business travels. Some
of these people have their tickets booked by Helpers and some do their own
bookings. Notes that some names on the database repeated on the list and
their Helpers could be different and some of them simply don’t have Helpers
do the b...
|
15 |
25.09.2006 18:29:01 |
|
|
Counting if between date range
I have a column of dates such as 8/5/06, I would like to create a formula
that counts the number of dates for a particular month. For example, if the
column reads as such:
9/13/06
8/28/06
9/20/06
9/20/06
8/20/06
9/22/06
9/22/06
I would like the formula to tell me that there are 2 for the month of
August. Then I could also set up another similar formular to tell me that
there ar...
|
8 |
25.09.2006 18:26:02 |