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 Reverse Sort Order Replies Views
Highest Values Comparison by Darren
I have a list of 20 names all with 24 separate attributes. Using the max() function, I can get the highest value for each attribute. With the highest...
April 15th, 2009 12:41 PM
by Mike H Go to last post
4 69
Excel virus? by NZuser
Hello, I work with a s/sheet that a few other users have access to, every now and then really old data seems to come back into the s/sheet - data that had...
April 15th, 2009 11:13 AM
by NZuser Go to last post
8 178
SUM depending on date by Espen Rostad[_2_]
Here's my problem...
April 15th, 2009 10:56 AM
by Espen Rostad[_2_] Go to last post
1 85
HOW TO I GET LOOKUP TO USE THE SAME RANGE EVERYTIME by Colm
I need to copy the fomula =if(e3="","",lookup(e3,er6:er26,es6:es26)) When I copy the lookup range changes. I tried using $ in front of er6, er26,es6,and es26....
April 15th, 2009 10:47 AM
by Jacob Skaria Go to last post
1 101
Count functions by Jalal
Hi, I would like to count the number of records which have a certain value in one column and a certain value in a different column. E.g. Each record in...
April 15th, 2009 08:51 AM
by Jalal Go to last post
4 120
Repeat Cell Based on the Value-Excel 2003 by Elaine
Hello, I want to repeat a formula based on the value in another cell. Example: Formula/Result located in Cell B8 Value 5 located in Cell A2 How do I repeat...
April 15th, 2009 08:41 AM
by Stefi Go to last post
3 112
External excel file for pulldown list source by Alan Lindner
How do you assign anohter Excel file as the source for the pulldown list?
April 15th, 2009 06:48 AM
by Sheeloo[_5_] Go to last post
2 223
Convert numbers to words by wins007
Can anyone help me with conversion of figures into words? Thks for your help
April 15th, 2009 06:11 AM
by Bernd P Go to last post
4 139
Symbols by Crissy
I am trying to put in a cell "30Û« ~35Û« " but when I do it switches the 35Û« to 53Û«. I have tried the cell format on "general" and "text" as well as the...
April 15th, 2009 05:13 AM
by Ron Rosenfeld Go to last post
8 162
Vlookup by Networking Issues Error 0X80070005
How do you use vlookup when you have several items you want to look up and return a total value. In this example I want to add all 3 items for a total of 15....
April 15th, 2009 05:06 AM
by Networking Issues Error 0X80070005 Go to last post
6 104
Check register running balance to another worksheet by Marysam67
I have a workbook with multiple check register worksheets and I want to recap the running balances on a separate worksheet. I want the recap sheet to...
April 15th, 2009 04:35 AM
by T. Valko Go to last post
1 94
Data Conversion - times, dates & rows by Sara
Hi there, I have a huge spreadsheet that is downloaded out of another program every week listing all staff and their rosters for the week. The dates and...
April 15th, 2009 03:44 AM
by joel Go to last post
5 107
percentage formula by David Wilson[_2_]
can someone give me a formula to dicount by percent. Example: A1 B1 C1 £50. -33% £33.50 ...
April 15th, 2009 03:38 AM
by T. Valko Go to last post
3 95
SUM, AVERAGE and PRINT with #N/A cells by PaulinaDi
Thanks Sheeloo and T. Valko but I still have questions about this issue. I'm just copying my new questions on this new post to make it easier or you may...
(Multi-page thread 1 2)
April 15th, 2009 03:20 AM
by T. Valko Go to last post
11 235
Difference between 2 dates&time(format 0000), and excludes weekend by YY san.[_2_]
Hi, Appreciate if anyone could help me on this. I have in ROW 435 Cell A= 11 Mar 2009 (format is date) Cell B = 1041 (formatted as special "0000". It is to be...
April 15th, 2009 02:40 AM
by YY san.[_2_] Go to last post
2 108
Screen Size by [email protected]
Is there a way of having the cells you want to see (Width) fit whatever screen it is connected to? ie: I have a spreadsheet which has many columns but I only...
April 15th, 2009 01:53 AM
by Dave Go to last post
2 106
how do I create a nonadjacent series for autofill to go by? by BoyGenius
My goal is to create formulas in each cell in series so I do not have to fill in each cells formula by hand. (would be very time consuming) The series of...
April 15th, 2009 12:35 AM
by Sheeloo[_5_] Go to last post
3 119
Sum cells that have both alpha and numbers by Bluthjen
I need to know how to add up the numbers in a cell that has both alpha and numbers. example english 36 PE 44 Math 16 History 65
April 15th, 2009 12:04 AM
by Gord Dibben Go to last post
3 126
Can't Prevent Recalculation by [email protected]
I have a workbook that has a number of tabs with literally thousands of formulas and calculations. All of the data is compiled in 7 tables corresponding to...
April 15th, 2009 12:04 AM
by Charles Williams Go to last post
4 119
IF Statement - compare to coloured cell by LinLin
Hi Everyone I'm not sure how to write an IF statement. If Cell A1 is shaded RED, I want cell B1 to to say OK If A1 is not red, then no message. The IF...
April 14th, 2009 11:43 PM
by LinLin Go to last post
7 113
Post New Thread


Display Options
Showing threads 12141 to 12160 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 02:27 PM.


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