|
modified COUNTIF
Generally COUNTIF would ignore the case of the text, but I would like
to count the text on a case sensitive base. Suppose in Cell A1 contains
"jack", and in Column B contains "Jack", "JACK", "jACK" and "jack", I
want to know what formula could count the number of "jack" in Column B?
Thanks.
Jack
...
|
4 |
28.08.2006 13:27:34 |
|
|
How I write following macro?
Hi.
I must prepare macro: that is steps
open file (xml)
finding in this file strings, that is defined in macro
For found strings copy falue, that is in xml structure (beetwen > <
for exammple: >100<)
paste number in right cell (in to excel file)
Open window: save as...
thx
Tom
...
|
1 |
28.08.2006 13:27:06 |
|
|
Referencing a table with blank rows without creating extra rows ?
Hi,
here is something that should be much simpler to accomplish but somehow
is very difficult to figure out.
Basically, for simplicity's sake, let's say I have a simple spreadsheet
shown in TABLE 1 below which has Mon-Fri in one column and dollar of
sales in the second column. But the catch is that each row is
separated by two blank rows. So say I would like to reference these
cells belo...
|
5 |
28.08.2006 13:03:19 |
|
|
pls.
i have in excel 5Rows & 5 Column
i 5th column if i type like ok / any thing, change the Red colour to
whole row, if nothing means it will be plain
how to use this in Conditional formating option / any
pls. give me example for that
thank you
...
|
2 |
28.08.2006 11:48:51 |
|
|
strange one
when ever i copy certain information inta a cell the cell formats to some
arabic language. the data i copy in is A4-1500.
when i copy in A4-500 or A4-1000 it works fine only this specific number.
also it doesnt mater how the cell is format before copying it always over
rides and if i format after it turns from arabic to a string of numbers not
to the A4-1500 i copied in
help please...
|
9 |
28.08.2006 11:16:05 |
|
|
How to format date as ddd, mmm, (date)
I would like Sunday, October 01, 2006
to show up as Sun Oct 1st
Thanks for your help!
....Lisa...Excel 2003
...
|
7 |
28.08.2006 10:53:04 |
|
|
Printing Excel sheet
I cannot print any borders on my sheets. I used to be able to. I
checked old sheets that printed OK before and cannot print now. What
has happened? Running Mac OS X 2.3. Do not know the version of Excel as
I am not at that machine now. By borders I mean all underlines in a
report. The rest of the report is fine.
...
|
2 |
28.08.2006 02:57:20 |
|
|
Making a primitive Excel application
Hello,
I'm trying to make a primitive Excel application. It is almost done but
i need some help.
This application would be in my shoe store. At the end of each day one
sheet(or maybe two, or three) should be E-mailed to me at home and I
would put it in my excel app. Now my question is this: can this process
be automated. This is what I would like to do: make a button in that
Excel app and...
|
2 |
28.08.2006 02:35:11 |
|
|
FS FORUM Thread
I'm not sure if you follow the FSForum section in the FlightAdventures
Forumns. There's a question for you there: "Extra 300L vs F1 Rocket
(question for Patti}"....
|
2 |
28.08.2006 02:20:19 |
|
|
frozen cursor
Something just happened to XL causing the cursor to freeze and pressing the
up and down arrows just moves the worksheet and teh cursor has to be moved
by mouse click. Can anyone tell me how to unfreeze the cursor.
Thx
Robin
...
|
2 |
28.08.2006 00:27:25 |
|
|
How to Highlight Formula Cells
Would some kind soul please tell me how to make spreadsheets highlight cells
which contain formulas (to ensure I am very careful when making changes)?
(Excel 2003).
...
|
10 |
27.08.2006 22:46:01 |
|
|
sumproduct - don't understand #VALUE result
Hi all--
I'm using this formula:
=SUMPRODUCT(--(Date>=B1),--(Date<E1),--(Category=A5),--(Out))
where Date, Category and Out are named ranges containing date values,
category names and dollar values respectively. So essentially, I'm adding
up all the "Out" values that fall within a certain date range and are equal
to a certain category.
If I set the ranges to be only the fi...
|
5 |
27.08.2006 22:10:50 |
|
|
Difference between results of array formula and non-array, with IF(ISNUMBER)
I have the following array formula:
={(AVERAGE(ABS(IF(ISNUMBER(T119:T124),T119:T124))))}
and the following non-array formula:
=(AVERAGE(ABS(IF(ISNUMBER(T119:T124),T119:T124))))
In the cells T119:T124 are the following:
-1,-1,-1,blank,blank,blank
The result of the array formula is 0.5.
The result of the non-array formula is 1.0
I believe 1 is the correct result. The array formula appears...
|
4 |
27.08.2006 21:22:33 |
|
|
Popup box for data entry...
This request will probably betray the fact that I'm relatively new to
Excel...
I need a button on a page (I can do that) that pops up a box that asks
for a value. After you enter the value in the box, it puts it in a cell
on that page...
Can anyone help with this???
Thanks!
Taylor...
|
4 |
27.08.2006 21:15:14 |
|
|
Creating a dynamic URL based on other cells values
Hi all.
I would like to create a clickable link in Excel. I want this link to
include the values in other cells as parameters. So, for example:
Cell A1: 123
Cell A2: abc
Cell B2: ="http://server.com/page?a1="&A1&"&a2="&A2
So, this clearly would display: "http://server.com/page?a1=123&a2=abc"
but the link is not clickable. I'm looking for an easy way to make the
data in this doc...
|
4 |
27.08.2006 19:21:01 |
|
|
<= is tis less than or equal to?
I am trying to raise a now due alarm in a cell when the content of an
adjacent cell exceeds the limit. At this time the accoint is now due. My
formula is:
=IF(BB4<=$BC$3, "","Now Due")
If not due not returnign comment.
Iurgently seem your assistance. Many thanks
--
Kaylean...
|
3 |
27.08.2006 12:47:00 |
|
|
Strange one
Greetings
This is wierd. I am using the FREQUENCY function and find that depending on
how I setup the bins it gives me different results.If I setup a bin with %
from 5 to 100 I get one result. If I setup a bin by adding 5% to each row I
get a different result. I have expanded the numbers out in each row and they
have the same value to 30 decimal places, so I'm confused as to why the
r...
|
11 |
27.08.2006 10:26:30 |
|
|
Adding random cells togethr
I want to be able to add
y2,aa2,ac2,ae2,ag2,a12,ak2,am2,ao2,aq2,as2,au2,av2,ax2,az2 together and
return the result in bb2
I am using =sum(y2,aa2,ac2,ae2,ag2,a12,ak2,am2,ao2,aq2,as2,au2,av2,ax2,az2)
however I only see the actual formula returned in the cell not the result. I
have been able to do this in the past. Can anyone help with this problem?
--
Kaylean...
|
5 |
27.08.2006 08:55:08 |
|
|
Hidden rows reappearing
I have sheet the uses about 10 columns and 20 rows. For convenience and
appearance, I hid all the unused cols and rows. I often insert new rows
and delete old rows... (it's a checkbook register type spreadsheet).
When I delete a row, one of the hidden rows at the bottom reappears...
and it's not row 21 but rather something in the 2000s or 3000s. Why
does this happen and is it preventa...
|
2 |
27.08.2006 05:47:21 |
|
|
Help! ISO formula for inconsistent monthly dates
What a goofy subject, I know. For my monthly budget, I want to output the
date in every column, two weeks apart. These represent paydays. However,
paydays are on the 15th and the last weekday of every month.
(For example: 8/31, 9/15, 9/29, 10/15, 10/31...)
Obviously, these dates won't all be 14 days apart. Is there any way to tell
Excel to output the date in the above manner?
...
|
12 |
27.08.2006 02:32:39 |
|
|
How to Create a Discount Calculator based on volume
I am trying to create a cost calculator form, which will automatically
calculate the discounted monthly price for a service based on the
number of units. I want to have a single cell which will calculate the
discount rate based on the number of units.
The discounts are:
if units =<50 price = 10
if units =>51 and <101 price = 9.75
if units =>101 and <201 price = 8.75...
|
3 |
27.08.2006 02:26:43 |
|
|
Invoice Number
I created my own invoice using a worksheet since I could not get the invoice
template to do as I wanted. Can someone please tell me how to assign a
changing invoice number cell? Can I make it start with whatever number I
want or must it start with 1?
Thank you in advance, this group has been extremely helpfull.
Gary
...
|
3 |
27.08.2006 02:15:59 |
|
|
lookup in worksheet_change event
Hi All
Worksheet1 contains below columns ( price list )
Company season price
Worksheet 2 contains sales
Company season amount price cost
Company and season are picked from another list.
What I want is ( if possible ) when I put amount price is picked from
sheet1 and multiply with amount for cost.
I know this too much but how can I put such formulas in
worksheet_cha...
|
2 |
27.08.2006 01:36:52 |
|
|
inverting data
Please help, I'm stuck! I conducted a survey where respondants each gave
answers to 30 questions using a Likert scale i.e. they answered either
1,2,3,4 or 5 to each question. The data is in the following form:
Question #
q1 q2 q3 q4 q5
1 2 4 2 1 2
2 4 1 2 1 4
3 4 4 2 1 4
4 2 3 2 2 5
5 2 3 4 5 3
My problem is that half of the questions were asked in a negative direction
to avo...
|
3 |
26.08.2006 16:51:36 |
|
|
Let Excel choose next following document number
I want to make a document which has the following purpose: claiming the
next number of a purchase order, quotation or another document.
>From a lookup table and a combo box/drop down the person chooses wether
its a PO or Q.
Then in the neighboring cell appears the next number of that document.
So, numbers already claimed before cannot be choosed.
How to perform that? (But, with the po...
|
1 |
26.08.2006 14:01:01 |