A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 25 of 100
Search took 1.39 seconds.
Search: Posts made by: [email protected]
Forum: Worksheet Functions May 28th, 2010, 08:51 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 2
Views: 486
Posted By [email protected]
Count using IF / AND

'IF' you gave a clearer explanation 'AND' gave some examples we may be able
to help you 'count'
"If cell B3 is between a number range" What is the number range?
"another cell in same Row =(Z) count"...
Forum: Worksheet Functions May 28th, 2010, 02:19 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 3
Views: 166
Posted By [email protected]
Calculate %

If 650MB is 45% of the file size then
650/45% =100% of the file size = 1444MB

"Amin" wrote:

sir thaks for the help however is not solve the problem. this strategy is
rather multiplying for me...
Forum: Worksheet Functions May 21st, 2010, 06:01 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 4
Views: 148
Posted By [email protected]
IF Function

Try:
=IF(W14=0,"",VLOOKUP($A14,$B$7:$J$10,5)*W14)

"casdaq" wrote:

I have this formula currently set up...

=VLOOKUP($A14,$B$7:$J$10,5)*W14

but I needit to not reflect the calculation if...
Forum: New Users May 21st, 2010, 05:54 PM Posted to microsoft.public.excel.newusers
Replies: 2
Views: 363
Posted By [email protected]
Formula returned in vlookup function

You've probably got a tick in the wrong place:
Try Office Button (top left hand corner)
Excel Options (bottom line)
Click on advanced
Scroll down to Display options for this worksheet
and untick...
Forum: Worksheet Functions May 18th, 2010, 01:40 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 3
Views: 113
Posted By [email protected]
PLEASE HELP

With the limited information in your question the following will give you a
solution:
Cell A1 is where you enter "a"
Cell A2 is the given value that you define
Cell A3 contains the formula...
Forum: General Discussion April 20th, 2010, 07:20 AM Posted to microsoft.public.excel.misc
Replies: 3
Views: 126
Posted By [email protected]
hiding zero for a sum

Another method is to untick the show 'zero in a cell' option.
Check out help in your version of Excel

"bb" wrote:

i'll try to explain best i can....
i have 3 colums, first and second are put in...
Forum: General Discussion April 20th, 2010, 07:13 AM Posted to microsoft.public.excel.misc
Replies: 3
Views: 281
Posted By [email protected]
Look up value range in column and then count

Using Excel 2007
Supposing your values are in column A rows 1 to 17 try this:
Four seperate...
Forum: General Discussion April 17th, 2010, 05:50 PM Posted to microsoft.public.excel.misc
Replies: 7
Views: 115
Posted By [email protected]
Hide Formula

A possible solution:
Set the cell up as Ms-Exl-Learner suggests lets say A1 then before
preotecting the sheet in say B1 enter the formula =A1. Make sure B1 has
protection removed. Format the font...
Forum: General Discussion April 17th, 2010, 01:04 AM Posted to microsoft.public.excel.misc
Replies: 4
Views: 148
Posted By [email protected]
Pulling Multiple Text Strings in a One Cell

Try:
=LEFT(A1,15)&"* *"&MID(A1,16,17)&"* *"&MID(A1,34,19)&"* *"&MID(A1,53,25)&"*
*"&MID(A1,85,18)&"* *"&RIGHT(A1,16)


"RebLan" wrote:

Okay....this is what i need help on. These multiple lines in...
Forum: Worksheet Functions April 17th, 2010, 12:00 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 22
Views: 563
Posted By [email protected]
Validation of UK VAT Number

Rob
I put the following together to achieve exactly what you are asking:
Cells A5 thro' to A11 - enter labels: 1st No., 2nd No., 3rd No. and so on to
7th No.
Cell A13 - enter label: Last 2 Nos.
Put...
Forum: New Users April 16th, 2010, 11:19 PM Posted to microsoft.public.excel.newusers
Replies: 1
Views: 292
Posted By [email protected]
Showing Only Actual Typing Area ?

You've posted this in the Excel forum try reposting in the Word Forum!!

"Bob" wrote:

Hello,

Using Word 2007 and Windows 7.

I want to always have my documents set up in the normal,...
Forum: General Discussion April 16th, 2010, 11:12 PM Posted to microsoft.public.excel.misc
Replies: 6
Views: 201
Posted By [email protected]
Fixed length string of text

Small modification:
=REPLACE(A1&B1&C1&D1,LEN(A1&B1&C1)+1,0,REPT(" ",59-LEN(A1&B1&C1&C1)))
Might give a slightly better look

"[email protected]" wrote:

MWysack
You have a considerable problem here to give...
Forum: General Discussion April 16th, 2010, 10:51 PM Posted to microsoft.public.excel.misc
Replies: 6
Views: 201
Posted By [email protected]
Fixed length string of text

MWysack
You have a considerable problem here to give a visual look to the line as
you show it. Consider the width of the letters 'm' & 'i' so a name with a
double 'm' will visually appear wider...
Forum: Worksheet Functions April 16th, 2010, 08:51 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 4
Views: 137
Posted By [email protected]
Add text automatically by recognized value

Forgot to add drag down forula to the bottom of your list

"[email protected]" wrote:

Peter
VLOOKUP is a possible solution:
Set up a looup table somewhere on your worksheet: say S1 to S5, enter the
...
Forum: General Discussion April 16th, 2010, 08:18 PM Posted to microsoft.public.excel.misc
Replies: 1
Views: 145
Posted By [email protected]
calculations help

Norm
I sure you know exactly what you mean but I'm not sure anybody else will!
"I want to calculate column C ,D, F ,G"! OK, but you'll need to tell us how
you arrived at 2 and 0 in column C and how...
Forum: New Users April 10th, 2010, 11:41 AM Posted to microsoft.public.excel.newusers
Replies: 3
Views: 392
Posted By [email protected]
deleted text character returning numbers when deleted.

ozgrid, I think you may have missed the "(" from the question.
I believe that there may be custom formatting applied to the cell.
Try changing the format to number with the number of decimal places...
Forum: Worksheet Functions March 26th, 2010, 07:49 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 14
Views: 179
Posted By [email protected]
Date Function

I'll try again:
Luke,
Very axceptable unless there are other numbers in the sentence e.g.
Product no. 1 dropped off on 11/01/2009 by Michelle Smith

"Luke M" wrote:

...
Forum: Worksheet Functions March 26th, 2010, 07:45 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 14
Views: 179
Posted By [email protected]
Date Function

Luke,
Very exceptable unless there are no other numbers in the sentence e.g.
Product no. 1 dropped off on 11/01/2009 by Michelle Smith


"Luke M" wrote:

=DATEVALUE(MID(A2,FIND("/",A2)-2,10))

...
Forum: Worksheet Functions March 26th, 2010, 07:31 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 14
Views: 179
Posted By [email protected]
Date Function

Brilliant Biff

"T. Valko" wrote:

Try this...

=LOOKUP(1E100,--MID(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&"0123456789")),ROW(INDIRECT("1:"&LEN(A2)))))

Format as Date
Forum: Worksheet Functions March 26th, 2010, 07:27 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 14
Views: 179
Posted By [email protected]
Date Function

Here's some possible leads:
http://office.microsoft.com/en-us/excel/HA011549011033.aspx
http://www.meadinkent.co.uk/xlextracttext.htm

"Jen_T" wrote:

If a cell has text and numeric (date) is there...
Forum: General Discussion March 26th, 2010, 06:46 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 119
Posted By [email protected]
How can my formula handle inserted rows?

Possible solution:
=IF(COUNTBLANK(A$1:INDEX(B:B,ROW()-1))=1,"There are empty cells within the
specified range","All cells within specified range are populated")

"Houston" wrote:

I am using...
Forum: General Discussion March 26th, 2010, 06:16 PM Posted to microsoft.public.excel.misc
Replies: 5
Views: 110
Posted By [email protected]
numbering items in a cell

One method:
In A1 enter a 1
In A2 enter: =IF(OR(B20,B2""),A1+1,"") and copy down (you could then hide
column A)
In C2 enter: =A2&" "&B2 and copy down
Now in column B (starting in B2) enter your...
Forum: General Discussion March 26th, 2010, 05:45 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 140
Posted By [email protected]
Printing is different from different computers

Just a couple of ideas:
1. Are you using the same make & model of printer? Sometimes using different
printers will result in a different print out.
2. Have you set up the 'print area & size' then...
Forum: Setting up and Configuration March 12th, 2010, 05:43 PM Posted to microsoft.public.excel.setup
Replies: 2
Views: 454
Posted By [email protected]
change excel sheet defaults

Try this:
Click on The Office Button (the big round circle next to the Home tab on the
ribbon).
Click on the 'Excel Options' button (along the bottom).
Click on 'Formulas' in the left hand...
Forum: New Users March 12th, 2010, 02:04 PM Posted to microsoft.public.excel.newusers
Replies: 3
Views: 214
Posted By [email protected]
How do I set the print range on a form. Regards

Enter this into Excel help:
Define or clear a print area on a worksheet
This should give you a solution

"Dave K" wrote:

I've created a Timesheet on a form in Excel, but when I print, it only...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 01:31 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.