|
complicated validation and pivot
I need a complicated validation for some user entry.
I have the following setup:
I) list that shows a style number, a size code, and 12 columns, with a "G"
or no value in each.
II) a list of the size codes, with 12 columns, each of which has a size in
them. So for one size code, the values could be [blank, 2, 4, 6, blank x 8
columns], and for the next size code, the values could be ...
|
1 |
23.09.2006 10:08:01 |
|
|
Convert digital #'s to spelled out words
Is there a way to turn you numbers into spelled out words?
Example
24 = twenty-four...
|
6 |
23.09.2006 09:23:01 |
|
|
Help with lookup
Full Handicap Playing Handicap
4.3 4
4.4 4
4.5 5
4.6 5
Lookup will return 4 if i am looking for 4.4, and 5 if i look for 4.6. But
for some reason on all the #.5 will always return with the wrong result. For
eg 4.5 will return 4 not 5.
Any ideas
...
|
11 |
23.09.2006 07:19:01 |
|
|
Drop down box
If I choose a word/command/field from the drop down box,
how can I format the next cell over recognize this selection
and display a number?
Basically I created a drop down box, Van, Bus, etc...
When I choose Van, I would like the next cell over
to recognize this selection and show $80.
Many thanks and appreciate the help!
Rob...
|
6 |
23.09.2006 06:00:01 |
|
|
Conditional date array formula
This is the formula:
=IF(ISERROR(INDEX(Log!$A$1:$A$2000,SMALL(IF((Log!$B$1:$B$2000>=$Q$1)*(Log!$B$1:$B$2000<=$Q$2),ROW(Log!B$1:B$2000)),ROWS($1:2)))),"
",INDEX(Log!$A$1:$A$2000,SMALL(IF((Log!$B$1:$B$2000>=$Q$1)*(Log!$B$1:$B$2000<=$Q$2),ROW(Log!B$1:B$2000)),ROWS($1:1))))
Log contains the raw data
Q1 = date of beginning of month
Q2 = date of end of month
This formula enters in...
|
2 |
23.09.2006 05:42:30 |
|
|
Attaching PDF files
I have successfully written some vba code to email a schedule to my
coworkers from excel via outlook. The vba code works well but now some
of them would like a PDF version. I use "cutePDF" free and I also have
FlashPaper 2 installed. Is there a way to access these via VBA to
produce a pdf of a single sheet and attach it to the email? If not is
there another way to automate the process of both...
|
1 |
23.09.2006 03:29:00 |
|
|
COUNTIF Formula in Multiple worksheets.
I need to use the COUNTIF formula to count items in 52 different worksheets.
I know that this formula will not work in counting multiple worksheets.
Anyone know of a quick workaround?
I dont want to get stuck typing 52 different SUM formulas.
Thanks,
Brent...
|
14 |
23.09.2006 02:33:03 |
|
|
I made drawings in excel, I don't see them but they print fine.
When I open the spreadsheet the numbers and letter appear but the shapes
around them do not appear. If I click on them I can get them to show up, but
I have to click on each picture. When it prints all the pictures show up
fine. Can you help me?...
|
2 |
23.09.2006 02:30:04 |
|
|
How do I combine 2 woksheets into 1?
I'm trying to combine 1 worksheet sorted 2 different ways then combine them
into 1 for printing....
|
1 |
23.09.2006 02:15:01 |
|
|
Automatically Filling In Corresponding Data from Another Worksheet
Here's my situation:
I have a list of employees on on one worksheet. In the cells next to
each employee name are their hourly pay rate, their department, and
their various overtime thresholds (the elapsed hour they go in to
overtime varies by employee).
On a second worksheet, I've created a drop-down list for the employee
names. I want their pay rate to follow the name, and appear in t...
|
3 |
23.09.2006 00:52:28 |
|
|
Excel Permissions
I want to set permissions for an excel file. According to excel "help", I
just go to "file" and then "permissions"; there is no "permissions" under the
file menu. I have excel 2003 - how can I find permissions?
James A...
|
2 |
23.09.2006 00:49:10 |
|
|
In Excel, use a different row for headings (not row 1)
Hi! I'm trying to do a mail merge from an Excel sheet. Unfortunately, it was
set up with some other information in the first few rows. Can I mark a
different row as the header row for my data? They are in row 5....
|
2 |
23.09.2006 00:14:01 |
|
|
how can I edit/change the font color in an excel formula?
when I highlight to change the formula pops up but I can not chose a
different color. How can I do this?...
|
2 |
23.09.2006 00:08:31 |
|
|
Data Validation
How can I implement a multi-column list for data validation in a worksheet,
i.e., not in user form?
I have a worksheet that user needs to pick a vendor from a valid list. I
want to show both the vendor number and name on the list, but, I prefer not
to use user form to accomplish this.
In addition, the validation list does not seem to be as user-friendly as it
is in Access, which wil...
|
4 |
22.09.2006 23:53:01 |
|
|
comments
I am now using 2003. When I add comments to a cell the date of the comment
does not show. I know the name comes from the options table but how do I
get the date of the comment to be entered auto. and any changes or additions
to the comment also with user name who changed it.
Louise...
|
1 |
22.09.2006 23:52:01 |
|
|
repeating data in other sheets
I am trying to create a workbook that will take input from certain
cells and populate that data in a particular cell on sheets 2 and 3.
This will be to save people from retyping informaiton and provide me
the important information I need.
So I want to have a workbook with multiple worksheets for different
data to be entered but when the person puts in their name, department,
and phone it...
|
5 |
22.09.2006 23:48:51 |
|
|
Macro to be used in any cell
How do I make a macro available in any cell of a worksheet.
I created it in a cell, but I want to be able to use it in any cell. Thanks.
Range("L1058").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
"..\..\..\Customer Filing\"
Range("L1058").Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
Range("C1").Select
Applicatio...
|
2 |
22.09.2006 23:16:09 |
|
|
WEIRD QUESTION
I have to calc every mth for the State of calif the following. you know how
govn offices are?????
if the amount is 56,995.87 I have to calc the following
5+6+9+9+5+8+7 = 49 + 7 =63
h=the $56K number varies every time it is calc. I have been using
spreadsheets since lotus 1A but I am at a loss on how to do this. Is anyone
up for this?
Don't you just love government office...
|
5 |
22.09.2006 23:07:01 |
|
|
Calendar function
Dear Excel(lent) users !
Can somebody tell me how to insert a calendar in Excel ? And how can I add
information behind certain dates?
Is it also possible to transform it to html?
Thanks for your help !
...
|
7 |
22.09.2006 22:52:02 |
|
|
pivot table formatting
I'm using Excel 2003. I have selected "preserve formatting" and deselected
"auto format", then I change the column widths by dragging or by using the
format pull-down (doesn't matter which), save the file and refresh the pivot,
but everything goes back to whatever they were before I fixed them.
If creating a macro is really the only solution (since the above is what I
found in this for...
|
1 |
22.09.2006 22:26:01 |
|
|
random number generator
I've been using the RNG and it works great... however, we need to take it one
step further. I've looked all thru previous posts, but can't figure this out.
I've got 10,000 names, addresses, etc all in a spreadsheet. I need to
randomly select 100 and put those names, adresses, etc into another tab.
As was mentioned in another post, I could simply sort the data by my 'rng'
column, but...
|
3 |
22.09.2006 22:12:11 |
|
|
Links Don't follow with copy
Hi,
I have a group of worksheets that have cells linked among them. In the
past
when I would copy this group of sheets to a different directory all of
the
links would update to reflect their new location. Example: A link that
was
=C:\data\sample'!$B$10 would change to
=C:\backup\data\'sampl'!$B$10.
Now when I copy the group of sheets to the
backup folder the links don't reflect ...
|
2 |
22.09.2006 21:37:02 |
|
|
IF "A" is TRUE and "B" is TRUE?
I want to write an IF statement that looks at values in 2 cells. Basically
if D2=0 and D3="", then Enter "GOOD", "NO")
I can't figure out how to get the IF statement to look at values in both
cells.
Thanks....
|
3 |
22.09.2006 21:17:01 |
|
|
simultaneous subtotals
I have a list of course rosters. I want to view subtotals of the following
information for each course section:
Total number of students
Gender percentages
Ethnicity percentages
Is there a way to subtotal the data so that it shows me all three things in
fields after each course section? (like what it does when you do a simple
subtotal)...
|
2 |
22.09.2006 21:11:01 |
|
|
how do i align numbers
why i can align text and i cant alkign numbers even if i format numbers as
text? can anyone help?...
|
4 |
22.09.2006 21:07:02 |