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 Reverse Sort Order Last Post Replies Views
"Microsoft" Patch Virus Messages by Alan
Does anyone know if the flurry of these things appearing in the newsgroups recently is due to people maliciously sending them, or if the virus is sending...
September 25th, 2003 07:36 PM
by Harlan Grove Go to last post
5 429
Cell values not displaying by Alan
=INDEX('sheet1'!E2:E51,COUNTA('sheet1'!E2:E51)) i've got the above in a cell. which basically looks up the last number in the E Coloum on sheet1. However due...
January 20th, 2004 03:42 PM
by Frank Kabel Go to last post
1 361
Array Formula - Use of OFFSET function with array argument by Alan
Hi All, I am trying to use the OFFSET function with an array argument as follows: A1 = "Alan" A2 = "Bob" C1 = "Charles" C2 = "Doug"
February 11th, 2004 10:38 PM
by Alan Go to last post
2 490
Absolute cell references by Alan
This is a copy taken from Google Try the sub by Gord Dibben below (always try any macro on a back-up copy of your file first) Paste the sub - i.e. everything...
April 20th, 2004 03:50 PM
by Dave R. Go to last post
1 327
what is wrong with this function? by Alan
=IF(OR(D2=9128,D2=3133,D2=3135,D2=3128,D2=3129,D2=3134),"F","N") Regards, Alan "Ryan" wrote in...
April 23rd, 2004 06:53 AM
by Aladin Akyurek Go to last post
4 85
How can I keep "#N/A" values from appearing in VLOOKUP results? by Alan
(example formula) =IF(ISNA(VLOOKUP(D2,H3:I5,2,FALSE)),0,VLOOKUP(D2,H3:I5,2,FALSE)) or =IF(ISERROR(VLOOKUP(D2,H3:I5,2,FALSE)),0,VLOOKUP(D2,H3:I5,2,FALSE)) You...
May 2nd, 2004 01:11 AM
by Kem Go to last post
1 186
Strip Character from Right by Alan
Two possible ways, =LEFT(A1,LEN(A1)-1) =SUBSTITUTE(A1,")","") Regards, "WDP" wrote in...
April 30th, 2004 10:44 PM
by Debra Dalgleish Go to last post
1 176
Unique values from a column based on condition in another by Alan
Hi, I want to count the number of unique values in a column of data where the cell value in the column next to it has a certain value? i.e. Count Unique...
July 16th, 2004 01:24 PM
by emm8080 Go to last post
2 279
Can I SUM a column with two variable using SUMIF by Alan
I have used SUMIF for Adding a column with one variable (ie: "SUMIF($a$1:$a$20, B1, $z$1:$Z$20")). Now I need to Add a column with two variables (ie: if cell...
September 1st, 2004 04:12 PM
by Frank Kabel Go to last post
1 151
Result in different cell by Alan
Hi, I have the following formula in cell f2: =IF(A2"",B2-C2,"") i want the result of B2-C2 to be put into cell E2 whilst keeping the formula in F2.. How...
January 20th, 2004 01:53 PM
by Norman Harker Go to last post
1 98
Convert date field to text by Alan
I have a mass of data with dates, which I need to group by DAY. I have formatted the cell to custom "dddd" so that it shows the day, however when i pivot...
December 19th, 2003 04:45 PM
by Alan Go to last post
4 482
Virus S**t by Alan
Is there any way of preventing these 'Microsoft' and other virus loaded messages appearing here with such monotonous regularity? Its really getting on my...
September 28th, 2003 10:45 PM
by Alan Go to last post
5 114
Cut and paste subtotals by Alan
Hi - I receive spreadsheet reports weekly that have several thousand records. I subtotal these reports to derive subtotals for specific customers. I...
October 1st, 2003 09:44 AM
by Paul Go to last post
2 77
Pivot table formulas by Alan
Hello - I am using XL2002. I have a pivot table and I was to include a simple division formula. The table has a customer and sales info for 2001 and 2002. ...
October 7th, 2003 01:26 AM
by Alan Go to last post
5 275
Open workbook for multiple people by Alan
Hi again - I have a workbook and want to have multiple people work on it simultaneously. Now, it lets the 2nd person open it - read only. How can I make it...
October 28th, 2003 11:16 PM
by Harlan Grove Go to last post
1 418
NETWORKDAYS - Non Add-in Alternative - Cannot get it working by Alan
Hi All, I have a general aversion to using functions that rely upon add-ins (mainly due to the number of less experienced users who aren't even aware of...
October 29th, 2003 01:28 AM
by Harlan Grove Go to last post
1 546
Returing a value depending on hi-lo range by Alan
With the low values and scores arranged like this in E12:F15 and your value "52" in H14 0 D 25 C 50 B 75 A =VLOOKUP(H14,E12:F15,2)
November 6th, 2003 08:11 PM
by L. Howard Kittle Go to last post
1 184
Problem too large for solver by alan
Is there a limit on Solver? alternatively does anyone know any code that does something similar?
December 2nd, 2003 06:36 PM
by Chip Pearson Go to last post
2 486
removing attributes...MAD as HELL by Alan
I cna not for the life of me remove the "READ ONLY" attribute for a Excel worksheet. I had made the sheet and put important info on it and saved it to a CDRW...
December 6th, 2003 10:19 PM
by Gord Dibben Go to last post
3 168
Sumifs function by Alan
I've entered the formula, it appears correct, and the correct result is displayed in the function argument box, however only the formula displays in the...
July 13th, 2009 07:16 PM
by Luke M Go to last post
2 110
Post New Thread


Display Options
Showing threads 2021 to 2040 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 09:01 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.