|
I am an Idiot Woman
Not a nice thing to say to a coworker, but was he right.
I had a discussion with a male collegue about the difference between and
empty cell and a cell with a zero. He called me a young, inexperienced,
idiot woman because I insist his workbook is wrong since he did not account
for empty cells that are awaiting data.
He uses, for example, =C14+C15+C16+C17)/4 to calculate average value, and...
|
16 |
12/31/2008 10:01:01 PM |
|
|
add percent plus quantity
Hi,
Before I begin I must relay my sincere thanks to this site as it is very
helpful in situations where there are too few knowledgeable answers.
This time my problem to solve is as follows;
I have a cell (200 rows) with an amount, I have to add 20% plus I have to
add quantity. How do I write a formula for this.
Example:
column A row 1 "3" (for quantity)
column B row 1 "$25.00 ...
|
5 |
12/31/2008 9:39:01 PM |
|
|
Text in Excel
Is there ever a good reason for putting mostly all text into Excel rather
than a Word table? At my level of knowledge, I certainly can't imagine what
advantage there would be.
However, upon request, I recently placed over 20 pages into Excel, only one
column of which contained ID numbers while the other 7 columns contained
paragraphs of text, which was--for me, at least--a formatting n...
|
7 |
12/31/2008 7:47:01 PM |
|
|
percentage of success in item adjusted by date
I am trying to figure out how to track the overall percentage of times
something is done each day and have it automatically adjust each day with
date function throughout the year. For example, if i wanted to track the
percentage of days i worked out in the new year. In an excel sheet already
set up with dates for the entire year and a column for work out, how can i
see the percentage...
|
2 |
12/31/2008 7:21:01 PM |
|
|
Changing the format of data in a cell
I would like to compare a range of data on a row (C2,D2,E2,F2,AND G2). the
highest number in that range I would like to display that number in the
specific column on the row listed below This number must be highlighed with a
specif color and Bold. This result number would be display under the column
of which ever number is the highest. Example
ROW C2 D2 E2 ...
|
2 |
12/31/2008 6:59:01 PM |
|
|
How do I use conditional formatting to set text height and indent.
When creating spreadsheets in Excel, I always want a top, bottom, left &
right indent on each cell (say 2px). I also want each cell to auto-size to
fit the amount of text that it contains. I don't want to have to set these
parameters each time I create a document. Can I use conditional formatting to
create a "template" or "rule" for future use? Is there a more efficient way
to to this...
|
2 |
12/31/2008 4:03:40 PM |
|
|
percentage something is done based on date
I want to track the number of times I do something each day in excel and get
a running percentage of the success rate. Easy example would be tracking
what percentage of days I work out in the new year. I have the dates set up
for the year, and have columns for things I want to track success rate on,
but am lost after that.
Any help is greatly appreciated.
--
Nathan...
|
2 |
12/31/2008 3:31:07 PM |
|
|
Template for building personal dictionary of foreign words
I am looking for a template on which I could establish a personal dictionary
for the Slovak language. The Slovak language is very complicated. All words
have several grammatical forms. Many words have mulitiple uses. Best way to
decipher the differences is to have ready the definitions and to see the use
of the word in actual slovak sentences. So, a two field data base is grossly
ins...
|
4 |
12/31/2008 3:03:02 PM |
|
|
fetching certain fields from 1 worksheet to another(if criteira me
Hi guys this is the problem I'm having right now.
On sheet 1, I have the headings as follows:
student name NRIC number block number street name payment mode,
where student names are placed under column A, NRIC number under column B
and so on,
On sheet 2, I have the following headings:
account holder name A/C no. student name block number street name,
but this ...
|
4 |
12/31/2008 8:25:41 AM |
|
|
Seeing Text File Names when Saving Excel Files
I am new to Excel 2007.
I am saving a new Excel file and I want to give it a similar name to an
existing text file so that I know by the filename that the two files are
related to the same project.
However, when I "Save As" the Excel file in the selected directory, the only
other files I see in that directory are the other Excel files. I don't see
any of the other files that I know ...
|
4 |
12/31/2008 7:23:01 AM |
|
|
How to repair a currupted Excel file?
Hello Everyone...
I got a a document & excel file from my professor. It is corrupted in my
system. My other class fellows are working on it. My other excel files are
working. How can i repair the corruptd excel file?...
|
3 |
12/31/2008 12:05:04 AM |
|
|
E-mailing a worksheet from a workbook using Windows Mail
I just upgraded from Office 2000 to Office 2007 Home and Student. In my old
version I could e-mail a single work sheet out of a workbook with my windows
mail. Now after upgrading, when I go to mail a single worksheet, the whole
workbook is attached to an e-mail instead of a single work sheet. Could
anybody tell me what I am doing wrong?...
|
3 |
12/30/2008 11:00:05 PM |
|
|
Data entered in one record is shifting to others
I have a large spreadsheet that is attempting to track folk's location over
the next few months.
Columns A thru AE are data type entries....columns AF thru IU are date
ranges. I am tracking/have entered over 300 records/rows.
I have had some previous help on coding to shade the interior of the date
cells based on what text entry that I make in the cell. Unfortunately, I
didn't think...
|
2 |
12/30/2008 7:51:14 PM |
|
|
Adding over 30 worksheets in a workbook
Happy Holidays! How can I SUM the value of the same cell located in over 30
worksheets in the same workbook to get a grand total of all those values? I
currently get a message back stating my formula is too long. Appreciate the
help!
--
-E...
|
5 |
12/30/2008 6:11:07 PM |
|
|
how do i make one tab monitor another and update automatically ?
tracking inventory and need to have master inventory list delete entries as
it detects them introduced into "outgoing" tab...
|
2 |
12/30/2008 5:33:01 PM |
|
|
Viewing Text In A Cell
When viewing a spreadsheet and I click on a cell, all text in the cell shows
up in the box at the top of the screen but all of the text doesn't show up on
the screen if I am not in that particular cell? How can I make all text show
up in all cells?...
|
5 |
12/30/2008 4:32:03 PM |
|
|
Calculating the first day of the week
I take my medicine for diabetes three times a week, every other day,
MWF. Sometimes my blood is drawn on the first day, sometimes the
second day, and sometimes on the third day. I have a different
calculation for each of those days, because no matter how you cut it
on Monday I haven't taken medicine for two days, on Wednesday I just
took the medicine the day before, and on Friday, I've been...
|
6 |
12/30/2008 2:51:46 PM |
|
|
how to format cell to display S("6 digit number here)
Hi guys I need to know how I can format cell such that when I enter a 6 digit
number such as "035891", it will be displayed as "S(035891)" instead.
So basically I want the number I input to be displayed in brackets with a
uppercase "S" placed in front, outside the brackets.
Also, any zeros typed in, be it at the start or end, must be displayed.
Thank you guys for your help.
Regards...
|
4 |
12/30/2008 1:12:57 PM |
|
|
This supernatural phenomena is freaking me out
Posted about this a few times but with no explanations, so i can only put
this down to the supernatural
Everytime I try to print using Microsoft Office Document Image Writer (hence
post to ms office newsgroups) - It goes through the motions (save a printout
as a file)
but the file (a .tiff file) cannot be seen by Vista (as if it doesn't exist)
Yet! (and here is the part that freaks...
|
5 |
12/30/2008 11:41:32 AM |
|
|
Countif with 2 Conditions
I want to use Countif with 2 conditions. For example,
1. It searches for the Emp Name, I need - Emp Name column A
2. It checks whether the Emp is Absent / present - Emp Attendance column B
then counts the no. of appearances of this Emp name in Column A
The absentee can be manually deleted & then countif is to be applied but I
want a function to do this without deleting...
|
6 |
12/30/2008 7:35:01 AM |
|
|
Test
Test Post...
|
1 |
12/30/2008 6:18:00 AM |
|
|
Look Up Formula Help Needed
I Have a sheet with store and Region
Store coloum has unique value
and each store number will show in only one Reg (Reg1, Reg2, Reg3, Reg4 or
Reg5)
for eg. If Store 7010 will be under Reg3 - it wont appear in any other Reg.
I want to use a formula which willl show what stores comes in what Reg.
Store Reg1 Reg2 Reg3 Reg4
9562 5602 5640 6002 6357
8352 5603 5641 6003 6358
780...
|
4 |
12/30/2008 12:14:45 AM |
|
|
Sorting Blanks First
I have a alphanumeric list as -
FM2130
FM613
FM3126
FM10
FM76
FM4120
I need it in an order as -
FM10
FM76
FM613
FM2130
FM3126
FM4120
It gets sorted as -
FM2130
FM3126
FM4120
FM10
FM76
FM613
The problem is that blanks need to be in a sort sequence first not last. How
do I fix this for all sorts....
|
3 |
12/29/2008 9:54:05 PM |
|
|
Count occurrences of dates
Column A is a list of dates with the format 01/01/2000, 30/04/2001 etc.
How would I count the number of occurrences of dates in column A
for the month of say January 2000
How would I count the number of occurrences of dates for the year 2000
Great If you can help.
George Gee
...
|
10 |
12/29/2008 9:46:03 PM |
|
|
Print Area Help!
I have designed a document with 1200 lines that have been formatted. Some of
the users will have only 20 lines, but some will have 1000. I would like them
to be able to print only the pages that they have used, but I can only figure
out how to make it print all 1200 lines or only 1 page. Thanks!...
|
5 |
12/29/2008 9:30:01 PM |