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.20 seconds.
Search: Posts made by: Bernard Liengme
Forum: Charts and Charting June 6th, 2010, 02:40 PM Posted to microsoft.public.excel.charting
Replies: 1
Views: 2,136
Posted By Bernard Liengme
How do I?

Can you give us a small example of the data and a bit more info?
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
REMINDER: These newsgroups are about to die. We...
Forum: Worksheet Functions June 4th, 2010, 02:40 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 6
Views: 363
Posted By Bernard Liengme
AMVERAGIF Condition

There is no need to use AND
This formula
=AVERAGEIFS(A2:A10,B2:B10,"=20",B2:B10,"=50")
will average the values in the A range when the corresponding B values lie
in the interval 20 to 50
best...
Forum: Worksheet Functions June 4th, 2010, 02:36 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 1
Views: 560
Posted By Bernard Liengme
MEDIANIF

There has never been a MEDIANIF
But this will fond the median of value 10 in the range
=MEDIAN(IF(A1:10010,A1:A100)
Note that it is an array formula and must be completed using...
Forum: Worksheet Functions June 4th, 2010, 02:30 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 3
Views: 329
Posted By Bernard Liengme
Average If

If you have Excel 2007+, then use non-array formula
=AVERAGEIF(A2:A10,"=75",B2:B10)
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
REMINDER: These newsgroups are...
Forum: General Discussion June 2nd, 2010, 10:52 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 380
Posted By Bernard Liengme
combing countblank with sumproduct?

Get me email address from my website & send me sample file
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
REMINDER: These newsgroups are about to die. We will all...
Forum: Worksheet Functions June 2nd, 2010, 08:06 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 3
Views: 342
Posted By Bernard Liengme
Timesheet in and out rounding

Experiment with this
=(ROUNDDOWN(C10*96,0)/96-C9+ROUNDUP(C8*96,0)/96-C7)*24
Not there is no need to use SUM when doing a simple arithmetic operation
best wishes

--
Bernard Liengme
Microsoft Excel...
Forum: Charts and Charting June 1st, 2010, 03:13 PM Posted to microsoft.public.excel.charting
Replies: 2
Views: 2,322
Posted By Bernard Liengme
Is it possible to use image files instead of points in a X-Y chart?

make a text box on the chart
insert the pictures of the products into the text box and add some text next
to each picture
delete the legend and let you textbox do its work
best wishes

--
Bernard...
Forum: New Users May 31st, 2010, 10:48 PM Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Replies: 20
Views: 4,232
Posted By Bernard Liengme
The last day

David,
Please reconsider. The Bridge works well and working directly in Answers in
not that much of a chore.
You will be sorely missed if you do not make the transition - I need someone
to trap my...
Forum: Worksheet Functions May 31st, 2010, 10:48 PM Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Replies: 20
Views: 671
Posted By Bernard Liengme
The last day

David,
Please reconsider. The Bridge works well and working directly in Answers in
not that much of a chore.
You will be sorely missed if you do not make the transition - I need someone
to trap my...
Forum: General Discussion May 31st, 2010, 10:48 PM Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Replies: 20
Views: 927
Posted By Bernard Liengme
The last day

David,
Please reconsider. The Bridge works well and working directly in Answers in
not that much of a chore.
You will be sorely missed if you do not make the transition - I need someone
to trap my...
Forum: Worksheet Functions May 31st, 2010, 02:15 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 4
Views: 434
Posted By Bernard Liengme
Count number of people

=ISTEXT(A1) returns TRUE if A1 has some text in it otherwise FALSE
=FIND("&",A1) returns a number representing the position of & in the A1
string if there is a & and an error value if...
Forum: Worksheet Functions May 31st, 2010, 02:06 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 3
Views: 445
Posted By Bernard Liengme
Remove non-space spaces?

I had tried that without success so went for the copy route
best wishes
Bernard

"Gord Dibben" gorddibbATshawDOTca wrote in message
...
Or simply...
Forum: Charts and Charting May 31st, 2010, 01:59 PM Posted to microsoft.public.excel.charting
Replies: 1
Views: 1,953
Posted By Bernard Liengme
In a Line-column graph on 2 axes, how do I stack the columns?

I know of no way that the data table can signal the chart engine what type
of chart is needed
The best way would be to make a stacked column chart; select on data sereies
on the cahrt and change it...
Forum: Worksheet Functions May 30th, 2010, 02:03 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 1
Views: 412
Posted By Bernard Liengme
copy and past cells found by SUMPRODUCT

Functions cannot do this. Why not use Data | Filter followed by copy &
paste?
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
REMINDER: These newsgroups are about...
Forum: Charts and Charting May 30th, 2010, 01:58 PM Posted to microsoft.public.excel.charting
Replies: 1
Views: 2,100
Posted By Bernard Liengme
Excel 2007: X-axis labeling

1) I am sure the x-axis is horizontal (runs left to right, not up and down).
To have it display fewer dates, right click the x-axis, open the the Format
Axis dialog and in the Axis Option set Major...
Forum: Worksheet Functions May 29th, 2010, 11:49 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 3
Views: 445
Posted By Bernard Liengme
Remove non-space spaces?

In some empty cell type formula =char(160)
This is a non-breaking spaces - it will be invisible
Select and copy that character
Use this in the Find & Replace dialog
best wishes

--
Bernard...
Forum: General Discussion May 29th, 2010, 11:41 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 176
Posted By Bernard Liengme
Length & Distance formula

Suppose you data is in rows 10 to 100

We need a way of know the vehicle length
In H10 enter =(LEFT(C10,2)="24")+(LEFT(C10,2)="90")+(LEFT(C10,2)="91") and
copy down the column
The 40 footer will...
Forum: Worksheet Functions May 29th, 2010, 11:01 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 4
Views: 434
Posted By Bernard Liengme
Count number of people

=ISTEXT(A1)+ISNUMBER(FIND("&",A1))
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
REMINDER: These newsgroups are about to die. We will all meet again...
Forum: General Discussion May 29th, 2010, 10:57 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 380
Posted By Bernard Liengme
combing countblank with sumproduct?

SUMPRODUCT(--(ISTEXT(S3:S44)),--(E3:M44100),--(E3:M44=200))/SUMPRODUCT(--(istext(S3:S44)),--(E3:M44""))
best wishes
--
Bernard Liengme
Microsoft Excel...
Forum: General Discussion May 29th, 2010, 10:54 PM Posted to microsoft.public.excel.misc
Replies: 4
Views: 487
Posted By Bernard Liengme
my question did not post

Rene,
These newsgroups will die in a few days. We will all meet again at
http://social.answers.microsoft.com/Forums/en-US/category/officeexcel
best wishes
--
Bernard Liengme
Microsoft Excel...
Forum: New Users May 29th, 2010, 02:14 PM Posted to microsoft.public.excel.newusers
Replies: 1
Views: 406
Posted By Bernard Liengme
Data Analysis Toolpak for Student Treacher edition originaly insta

Office ball Excel Options Addins
Now locate "Manage AddIns" and select Toolpac
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
REMINDER: These newsgroups are...
Forum: Worksheet Functions May 16th, 2010, 12:54 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 1
Views: 127
Posted By Bernard Liengme
IN EXCEL

You have not given us much to work with.
Suppose A1:F1 holds these values
100 110 120 130 140 150
And H1 hold the number 120 - the number you want to find
The the formula =MATCH(H1,A1:F1,0) will...
Forum: Worksheet Functions May 15th, 2010, 07:47 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 3
Views: 132
Posted By Bernard Liengme
Search for cell value

I would not like to work with such a data set. I would split the double
entries into two cells using Data | Text to Column
best wishes
--
Bernard Liengme
Microsoft Excel...
Forum: Worksheet Functions May 15th, 2010, 02:05 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 2
Views: 142
Posted By Bernard Liengme
Excel Formula to colourfill cells when condition met

Select all the data - I will assume each row foes fro A to G and that the
data starts on row 1
In the conditional formatting dialog use this formula
=COUNTIF($A1$:G1,"*~*~*~")
The ~ are needed to...
Forum: Worksheet Functions May 15th, 2010, 01:50 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 3
Views: 132
Posted By Bernard Liengme
Search for cell value

I have interpreted this as follows;
You have data such as
Record # Proj # Billing # Review #
1 R1234JK-3 KIKII-87 KL12367
2 ...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 10:08 PM.


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