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 4.68 seconds.
Search: Posts made by: Glenn[_6_]
Forum: Worksheet Functions May 28th, 2010, 09:45 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 2
Views: 445
Posted By Glenn[_6_]
Hold a cell range for an "average formula"

Wendy Akers wrote:
I add a column every week to my work sheet and want the formula to always
calculate the current 5 column range.



Add a column WHERE?

What "formula"?
Forum: Worksheet Functions May 28th, 2010, 08:17 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 2
Views: 471
Posted By Glenn[_6_]
Count using IF / AND

RERAA wrote:
If cell B3 is between a number range and another cell in same Row =(Z) count.
As cells are populated the count will increase. So the cell must be between
10 and 20 and the second...
Forum: Worksheet Functions May 28th, 2010, 05:15 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 4
Views: 304
Posted By Glenn[_6_]
Formula Help

Nikki wrote:
I would like to remove every character up to the "_" and retrieve the name to
the right. Can someone please help me with a formulat that would work for me.
00232902_Joe Smith

...
Forum: Worksheet Functions May 28th, 2010, 05:13 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 6
Views: 396
Posted By Glenn[_6_]
Format Date

Malcolm wrote:
Hi, all,
How do I format the date to show May, 2010? The closest I can get is May-10
from the drop down list.

Thanks,
Malcolm


Custom date format:
Forum: Worksheet Functions May 25th, 2010, 10:01 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 4
Views: 168
Posted By Glenn[_6_]
Hour function equivelent help

EAB1977 wrote:
If I want to find out how many minutes there are for times that I have
summed, I know I can use the hour function if the compiled time is
less than 24 hours. But, what if I want...
Forum: Worksheet Functions May 24th, 2010, 09:24 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 4
Views: 206
Posted By Glenn[_6_]
Excel 2003 Function Help

Then you would use SUMPRODUCT. Look at these two links for help on counting and
summing, respectively, cells that match multiple criteria (in your case greater
than/or equal to one time -and- less...
Forum: Worksheet Functions May 24th, 2010, 08:13 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 2
Views: 137
Posted By Glenn[_6_]
Two Condition - search

linda wrote:
I am trying to pull value when two conditions are met.

want to count column "B" when it = "ETARC" and when column "J" is = "0" or a
negative number.

I have tried...
Forum: Worksheet Functions May 24th, 2010, 08:12 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 4
Views: 206
Posted By Glenn[_6_]
Excel 2003 Function Help

Ryan Hicks wrote:
I need help coming up will a function that will average a range in one column
based on if the hours match. Here is my set up.

-------A-------B
1.....09:21....12
...
Forum: Worksheet Functions May 24th, 2010, 05:54 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 2
Views: 144
Posted By Glenn[_6_]
if true, if not nested if funcion

Cali wrote:
Having some trouble figuring out a formula. Hope someone can help!
This is going to go into Cell B10.

If cell b7 is =equal or greater than the value in B12 only sum B6+B8+B9;
...
Forum: Worksheet Functions May 17th, 2010, 06:01 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 2
Views: 111
Posted By Glenn[_6_]
Convert a text in a date format

xBeckx wrote:
Hi
I have imported a file where there is a field that is suposed to contain a
date. It was transformed in text, like 22FEB2010. I need to treat this field
as date. How can i...
Forum: Worksheet Functions May 14th, 2010, 09:03 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 13
Views: 215
Posted By Glenn[_6_]
=MAX(SUBTOTAL(9,OFFSET(B1,ROW(1:21),,3)))

Martin Roland wrote:
=MAX(SUBTOTAL(9,OFFSET(B1,ROW(1:21),,3)))

I am trying to do this exact same formula, however, I need my array to calculate across columns instead of rows, I have...
Forum: Worksheet Functions May 14th, 2010, 07:21 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 9
Views: 205
Posted By Glenn[_6_]
Excel File Size

I don't know the reason why, but I have a workbook with 9 worksheets and three
separate PivotTables that is about 1.3mb when opened and saved in Excel 2003 and
drops to about 350k when opened and...
Forum: Worksheet Functions May 13th, 2010, 10:12 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 2
Views: 191
Posted By Glenn[_6_]
FORMULA'S

MATTQHL wrote:
WHEN DUPLICATING DATA USING =WORKSHEET1!A1, ON ANOTHER WORKSHEET WHY IS IT
THAT IT CAN ONLY DO NUMBERS NOT TEXT I'M SURE THERE'S A WAY CAN ANYONE HELP

THANKS IN ADVANCE


Are...
Forum: Worksheet Functions May 13th, 2010, 10:05 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 4
Views: 97
Posted By Glenn[_6_]
Sort data separated by commas

dab wrote:
Good day and thanks for reading.
I am working on a file where a cell contains data separated by a comma.
ex:
Col A Col B
Row 1 ...
Forum: Worksheet Functions May 13th, 2010, 05:46 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 3
Views: 91
Posted By Glenn[_6_]
convert matrices to table

Dave wrote:
Hi to everyone, is it possible to view a matrix in table mode?

I have a matrix like this
b c d e f ...
b 1 0 3 4 5
c 2 5 8 6 5
d 2 3 ...
Forum: Worksheet Functions May 13th, 2010, 03:11 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 7
Views: 142
Posted By Glenn[_6_]
Grouping and sorting details

Rich Stone wrote:
Hi Glenn,

Thank you very much for your help. This has worked well in providing the
information I required. It has also given me a nice introduction into using
pivot...
Forum: Worksheet Functions May 12th, 2010, 04:31 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 7
Views: 142
Posted By Glenn[_6_]
Grouping and sorting details

Rich Stone wrote:
Thanks for the link, but I'm still in the dark on how this will help me. As
you suggested, here's some more info...

The spreadsheet is basically a table with the headings...
Forum: Worksheet Functions May 12th, 2010, 04:12 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 5
Views: 93
Posted By Glenn[_6_]
IF formula help?

daisy wrote:
Hi, can anyone help me write an IF statement? I have a list of names in
Column A and want to check it against another list of names in Column D - if
the name matches one of the...
Forum: Worksheet Functions May 12th, 2010, 03:29 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 5
Views: 70
Posted By Glenn[_6_]
Formula Help

Danny Boy wrote:
VThis formuula below needs some help. We had it working, but want to add in
one piece. If "No Show to MOP" is added on Column T, we want Column U to also
say "$150.00 owed"....
Forum: Worksheet Functions May 12th, 2010, 02:55 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 7
Views: 142
Posted By Glenn[_6_]
Grouping and sorting details

Rich Stone wrote:
Thanks for your reply. Could you possibly explain how I would do this? I'm
afraid my excel skills don't stretch too far in this aspect and I've never
used pivot...
Forum: Worksheet Functions May 11th, 2010, 06:39 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 7
Views: 128
Posted By Glenn[_6_]
VLOOKUP use column name not number

kathy wrote:
Is there a way to use VLOOKUP to search for a column name and return the
value in that column, rather search for a column number.


Use INDEX/MATCH. Look...
Forum: Worksheet Functions May 10th, 2010, 04:02 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 6
Views: 101
Posted By Glenn[_6_]
Adding to a SUMPRODUCT formula

Mark D wrote:
Afternoon all

I have the below forumula

...
Forum: Worksheet Functions May 7th, 2010, 10:06 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 3
Views: 123
Posted By Glenn[_6_]
How do you add a number from a different worksheet into a formula.

David wrote: Nothing!


Write your question in the body, not the subject.



Look in the help file under "About cell and range references".
Forum: Worksheet Functions May 7th, 2010, 09:12 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 3
Views: 68
Posted By Glenn[_6_]
What type of "lookup"

Kat wrote:
"Glenn" wrote in message
...
Kat wrote:
I have a spreadsheet with 5 tabs. Each sheet in the tab has 4 columns (A,...
Forum: Worksheet Functions May 7th, 2010, 08:11 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 3
Views: 68
Posted By Glenn[_6_]
What type of "lookup"

Kat wrote:
I have a spreadsheet with 5 tabs. Each sheet in the tab has 4 columns (A, B,
C, D) Sheet 1, Sheet 2, Sheet 3, Sheet 4 and Sheet 5.

Each sheet pertains to different customers...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 09:45 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.