CountIF
Mon, 15 Mar 2010 13:34:32 -0700
I have a column of names that i need to count; however, I only want to count the total number of different names that appear. In other words, if james appears 5 times in my column, i only want him to count once. How would i set up the countif statement?
Submitted via EggHeadCafe - Software Developer Portal of C ...
|
monthly to full years
Mon, 15 Mar 2010 09:12:40 -0700 (PDT)
I have a monthly cash flow schedule that spans 4 calendar years. Each
month has date representing the month (e.g. mar-2010). I need to
distinguish between months that for which the whole calendar year
appears on the schedule and those that are partial calender years.
Any ideas how to do this? ...
|
how to do "Round half to even"
Mon, 15 Mar 2010 01:45:17 -0700 (PDT)
Hi,
As in title, how can I perform "Round half to even" ? So for example
22.5 is rounden to 22 but 23.5 is rounded to 24?
thanks ...
|
Sorting in Excel
Mon, 15 Mar 2010 00:30:01 -0700
Hi.
I have in sheet1 in Excel 5 columns with data. The A column has names, the
B age, the C skills, the D salary and the E a code number (as text).
Every few days I add some new names at the end of A column (also the other
data in B,C,D,E) and sometimes I delete a few names.
I would like to find a formula t ...
|
Dialogue box too wide
Sun, 14 Mar 2010 21:45:40 -0700 (PDT)
I use the macro below to open a dialogue box for this instruction.
"The file will be saved with the new data
Click OK to continue. To stop, click CANCEL".
But the box is too wide. Can someone provide me a macro to correct
this.
Thank you.
Regards,
Salza
--------------------------------------------- ...
|
Unexpected bar diagram behaviour
Sun, 14 Mar 2010 19:39:23 +0000
Hi
I have a very simple question. I wanna have a diagram with the following
table
Apple 30 40 50
Pears 200 300 400
Bananas 10 20 30
The weird thing, when I try to draw a bar diagram the order of the bars
change. So Excel draws me first the Bananas, the the pears and finally
the apple bar.. ...
|
Find a number then offset
Sun, 14 Mar 2010 07:24:21 -0700 (PDT)
In cell Z34, how do I find a number from 1 to 12 (say 9 which could
be anywhere in column B5:B30) then OFFSET from that to find the result
to put in Z34?
e.g."=FIND(9) in B5:B30 then OFFSET(9,20,2)"
Thanks,
Barney
...
|
|
|
Camera Tool in Excel 2007 - not updating
Sun, 14 Mar 2010 00:34:49 -0800 (PST)
Hi,
I use the Camera Tool as a dashboard to see what is changing in other
sheets in a workbook. It works well in my machine (updates in other
sheet are visible).. But does not work in another machine? Is there
any other setting in Excel Options that determines the update
behavior.
Thanks in advance for the ...
|
Countif more than one criteria
Sat, 13 Mar 2010 11:12:01 -0800
I want to count the Database that I have like this:
A B
1 Date Team
2 1/1/2010 1
3 8/1/2010 2
4 9/1/2010 1
5 14/1/2010 1
6 18/1/2010 1
7 2/2/2010 2
8 22/1/2010 2
9 8/2/2010 2
10 ...
|
Format changing unexpectedly
Sat, 13 Mar 2010 09:23:01 -0800
I have some spreadsheets that are protected and I don't have the password to
unprotect. The spreadsheets are all in 2007 and I'm using WinXp.
The problem that I have encountered is that number formats periodically
change from number (0 decimals) to a date format. The numbers are unusable
by parts of the pro ...
|
