# Posts by imported_Anonymous

• ## Code doesn&#039;t work in Excel &#039;97 [SOLVED]

Thanks Guys

I rerecorded my steps and the are npw working.

Ta:bouncy:

• ## Access Form Command Button

In Access how can I attach the keystrokes Ctrl-' ,used to copy information
from a previous record, to a Command Button on the form.
Just wondering...

greid

• ## calculation for bytes per second

I have columns with start time and stop time and duration(hh:mm:ss). I have a column with number of bytes. I need to create a column of BPS (bytes per second). What is formula? Thanks for your help.

• ## Cashflow

May have the wrong end of the stick on this, but what the following formula, in yellow on the attached spreadsheet?

=SUM(\$C\$8:C8)*\$A\$16

[email protected]

• ## Excel time and date formula

Can anyone tell me how calculate date and time..for example how many hours is from:

1/2/03 11.45 am to 1/4/03 2.30 pm

I cannot seem to be able to come up with a workable formula.

Thanks
Anne

• ## excel formula

I would like to know how to write a formula that will pick the greatest value from 5 other cells

• ## CountIF + Expressions

One more thing and then I'll take a refresher course.... How can I make Excel count the cells as described in the original post AND only count them if another cell has a value.. So... COUNT J1:J80 WHERE J1:J80=Today()-7 AND F1:F80=Pending

so only count the cells that are within the last seven days and Pending.

• ## CountIF + Expressions

Thank You, that worked vunderfully....

• ## CountIF + Expressions

I am trying to count the number of cells with a date within the last 7 days. CountIF supposedly supports expressions, but I cannot get it to recognize the following:
COUNTIF(J1:J80,"&gt;(Today()-7)")

The function will will work if I enter the date I want to see if the field is greater than =COUNTIF(J14:J31,"&gt;01/01/2003"), but I want the date to change for the current day...

I've got a solution that works, but it involves setting a cell to Today()-7 and then entering: =COUNTIF('1.4A'!J2:J31,A9) + COUNTIF('1.4A'!J14:J31,A10) + COUNTIF('1.4A'!J14:J31,A11) + COUNTIF('1.4A'!J14:J31,A12) + COUNTIF('1.4A'!J14:J31,A13) + COUNTIF('1.4A'!J14:J31,A14+'1.4A'!G58) + COUNTIF('1.4A'!J14:J31,A15) + COUNTIF('1.4A'!J14:J31,A16)

but I don't like this impletmentation....

• ## COUNTIF function using commas

In my coursework I need to use the COUNTIF function. I have two worksheets; one is on the results of a sportsday; the others is a medals sheet. The problem is as follows:
I use this formula:
=COUNTIF('INPUT SCREEN'!C6,'INPUT SCREEN'!C13,'INPUT SCREEN'!C20,'INPUT SCREEN'!C27...and so on...till...'INPUT SCREEN'!C125,"1")
The INPUT SCREEN is the name of the results worksheet, and the "1" is comes up in the ranking
bar and means 1st place and therefore gold medal. I put in the commas, so that EXCEL only counts the "1"s in the ranking bars, and not also in the point bars.
Th problem that came up, was that EXCEL always marked the third "object" in the formula, in this case, C20 telling me that something was not right with the formula.
Is there any way to solve this problem; or even another option in counting only the "1"s in the rank bars
:question:

• ## URGENT: Search field in Excel XP

OK, I'll try and give you a better insight as to what I'm trying to achieve

There's a file we have which has a person's name, employee number and their rate of pay, etc

They want to be able to search by number, which will then display the appropriate, corrosponding xls file with the person's details on ...

• ## URGENT: Search field in Excel XP

That's cool yeah ...

Is there any way in which when the result is returned, it loads up another file though (a specific template for each person, holding pay/rate info)?

• ## URGENT: Search field in Excel XP

I've got the numbers in one collumn - Name in collumn A and the numbers, along side in collumn B, going through to 70+

My boss wants to be able to put the number [i.e. 6271] in a search field, and then it will display the relevant form for that person, in another sheet?!

I have no idea where to start ... :no:

• ## URGENT: Search field in Excel XP

Is is possible to search a worksheet by a "unique identifying" number, which will then show the results [a new file, i.e. "Sheet2"] as another, seperate page?

Hope this makes sense as I need to create something which will do this ASAP.

Cheers.

Thank you really really much

Also thanks for the quick reply

Appreciate it

It works great

I have a cell with text, and it's hyperlinked

I want the cell next to it (A2) to show the url

If I use "=A1" it only shows the text, not the url. And if I use =Hyperlink:A1 or something similar it has the text and the link, but i ONLY want the link

Is there a command like "=A1("url")" or something like that to show the url of the text in that cell?

can someone please reply asap and email me the little piece of code at [email protected]

• ## Help creating complex invoice with menus options and quantit

Are you offering a % discount according to quabtity purchased e.g &gt;10 less 10% or a variety of different prices.
If you post an example of your pricing I will have a look at it. I have several different invoice esamples which I should be able to adapt.

• ## convert html to csv

I have dynamic data displayed within a table in an asp page, and was wondering how to create a link for the data that is displayed in the table to be downloaded into an excel spreadsheet. I am sure this is possible but cannot seem to find how to do it.

• ## Countif

I need to countif, e.g.

Column A Column B
01 .5
01 .7
01 1
02 .3
02 2

I need the result as follows:

If Column = 01 then count how many cells in Column B is less than 1