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 » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Replies Reverse Sort Order Views
IF across multiple worksheets by xvfcc1
I have a workbook that contains 3 worksheets, one for each vendor site. I am trying to average delivery time (column R) across all 3 sites based on which...
(Multi-page thread 1 2)
December 20th, 2006 03:20 AM
by T. Valko Go to last post
11 143
Formula won't adjust after sorting data by mmcap
I use 2003 Excel. If I write a formula which works properly with the data sorted by column A and then sort by a different column it no longer works. There...
(Multi-page thread 1 2)
January 22nd, 2007 07:53 PM
by vezerid Go to last post
11 104
Spellcheck function in Protected Sheet by gwinder
I have created an employee review form that contains code which enables text wrap in merged cells. I have protected the sheet but this disables the...
(Multi-page thread 1 2)
January 28th, 2007 07:31 PM
by Gord Dibben Go to last post
11 150
Advanced cell function. is it possible by Tosco
Hi all, I`m having a problem on excel and I would like to know if it`s possible to be done without programming in VB: Let's say i have the following: A...
(Multi-page thread 1 2)
January 29th, 2007 02:19 PM
by Gustavo Go to last post
11 182
Last non blank cell in selected cells by Ron Weaver
Is it possible to specify a group of cells like A1,A5,A10,A15,A20, and have Excel find the last non blank cell in the group? These are numeric values that...
(Multi-page thread 1 2)
January 29th, 2007 04:29 AM
by Aladin Akyurek Go to last post
11 123
Assigning numerical value to text by Dave
This may be simple but I'm new...forgive me... I've created drop-down lists in a column with several variables all in text from a list. I am trying to make...
(Multi-page thread 1 2)
February 1st, 2007 03:21 AM
by Dave Go to last post
11 140
Excel 2002 VLOOKUP Weird by TRJ
The attached Excel 2002 workbook contains 2 sheets: (I'm new here and could not see how to attach the xls file. How do I attach or can I email to a...
(Multi-page thread 1 2)
February 7th, 2007 03:40 PM
by TJ Go to last post
11 155
i'm missing something by [email protected]
im trying to simplify my personal bookkeeping. i import my data from the bank as a .csv and want to transfer it to a second sheet without all the jibberish....
(Multi-page thread 1 2)
February 17th, 2007 07:23 AM
by T. Valko Go to last post
11 121
OR or ARRAY help by Bigfoot17
I am struggling! This statement will count the number of "W/M"s that are "XYZ": {=SUM(IF(($F$8:$F$57="W/M")*($D$8:$D$57="XYZ"),1,0))} But what I would really...
(Multi-page thread 1 2)
February 20th, 2007 12:37 AM
by Domenic Go to last post
11 126
Find Max Value in WorkSheet by Corey
I need to find the Max Value in a Worksheet, But the Value will always be in a "st 1234" format. That is: "st"+ Space then 4 digits. I want to find the MAX...
(Multi-page thread 1 2)
January 15th, 2007 12:00 AM
by Corey Go to last post
11 135
COUNT or COUNTIF using wildcard text? by WiFiMike2006
Hello, I am trying to create a formula that will count the number of cells with certain text (EP) in one range that also have an instance of certain wildcard...
(Multi-page thread 1 2)
January 13th, 2007 12:12 AM
by Roger Govier Go to last post
11 143
How do I paste multiple values into one cell? by RJUN
We need to paste comma delimited text which contains multiple values from one cell into another single cell on a separate page. When we cut and paste, the...
(Multi-page thread 1 2)
December 28th, 2006 06:32 PM
by ryguy7272 Go to last post
11 106
summing last values in column by gotta know
1. I would like to sum the last 25 days values in a column automatically once the data are input example: a. I want to add the sum of the last 25 values...
(Multi-page thread 1 2)
December 27th, 2006 02:51 PM
by RagDyeR Go to last post
11 145
How do I take out a dash in a number like 827-6541 in a XL list by Kelley
I have a "list of fax #s in xl that I am tyring to send as a broadcast fax. The service I have requires that the fax number be in a format with no characters...
(Multi-page thread 1 2)
December 26th, 2006 11:40 PM
by JR Hester Go to last post
11 130
VLookup problems... by Tossaire
have been using Vlookup to reference a 2nd sheet to verify cashed checks based on the check number on the first sheet. using =VLOOKUP(B59856,CLEAR,2,FALSE)...
(Multi-page thread 1 2)
December 28th, 2006 07:51 PM
by Tossaire Go to last post
11 119
Find One Of Several Values Within A Cell by Jim J.
Is there a method to perform the following function?: I) Using a list of values (In my case, these are text. For the discussion, let’s assume they are...
(Multi-page thread 1 2)
January 2nd, 2007 09:02 PM
by Harlan Grove Go to last post
11 103
Sumproduct help by Walter Mayes
Am converting my workbooks over from 2006 to 2007. Hope I can explain this clearly. Saved my 2006 workbook as 2007 so it should be a simple matter to...
(Multi-page thread 1 2)
December 31st, 2006 11:05 PM
by Roger Govier Go to last post
11 140
Advance to predetermined cell by Publius
In Excel 2002 I want to insert a command in certain (not all) cells that once data is entered therein and "enter" or a hot key is pressed advances the cell...
(Multi-page thread 1 2)
January 10th, 2007 06:07 AM
by Publius Go to last post
11 132
add up negative numbers by bill gras
Hi I have a column "G" with negative numbers, positive numbers and zero's. Column "H" is the column that adds up all the negative numbers from column "G" ....
(Multi-page thread 1 2)
January 12th, 2007 08:33 AM
by bill gras Go to last post
11 133
Need to find the higest alpahbetic name in a list of names by Carlo
Hi there, I have a list of names like Andrew, Zachary, Jeff etc and I need to find out which one is the highest alphabetically. The max function doesn't seem...
(Multi-page thread 1 2)
February 28th, 2007 12:28 AM
by Epinn Go to last post
11 129
Post New Thread


Display Options
Showing threads 2001 to 2020 of 87787
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


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


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