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 : New Users Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
What funtion to use? by fetzer[_2_]
Not sure what function to use; vlookup, ISNA, MAtch, etc.. One of my spreadsheets (sheet 2) has 36 different tables (not a pivot table) of 4 columns each...
November 3rd, 2009 03:55 PM
by JLatham Go to last post
2 156
Jump to a different cell depending on list selection by Karen Sigel
In Excel 2003, I have a dropdown list (created using Data/Validation and referring to cells in the same worksheet). Depending on the selection that's made...
November 3rd, 2009 03:32 PM
by JLatham Go to last post
3 184
Need multiple blanks between words by skaizun
I have two words, say, "ALPHA BETA", that are in a merged column(s) and are text fields and are oriented downward, such that they read as follows: A L P H A B
November 3rd, 2009 11:08 AM
by Ron Rosenfeld Go to last post
1 142
Filter in between dates by Linda RQ
Hi Everyone, Using Excel 2003. I have a list of patients who were on a particular therapy and in a certain unit. Many where on the therapy in other units...
November 3rd, 2009 02:14 AM
by Linda RQ Go to last post
6 142
Links between files by Gene L.[_2_]
I have an Excel 2007 workbook that displays the message "This file contains links that cannot be updated". This workbook has never been a problem in the past...
November 2nd, 2009 03:04 PM
by Eduardo Go to last post
1 125
division formula by Rohit
when i try to divide 100 by 0, its gives me error message #DIV/0!. This i undersatnd is immpossible. But can i setup a formula if any number being divided by...
November 2nd, 2009 09:44 AM
by FloMM2 Go to last post
2 155
How do i get information from one cell apear on another page by amccord
I am using Excel 2007. I just need to have information (which is a number) from C3 apear on a different page on C4. Thank you
November 1st, 2009 09:01 PM
by JLatham Go to last post
1 111
Is there a good how to book that I can buy for excel 2007? by Karen
I am taking a finance course that requires me to have more than a very general knowledge of excel. I am wanting to know if there is a good beginners book...
November 1st, 2009 02:59 PM
by Dave Peterson Go to last post
2 163
A UDF for Counting Coloured Cells that are conditionally formatted by NeilG
Hi All, I have been doing some extensive research and testing to determine whether there is any way that a UDF can be created that will return the count for...
November 1st, 2009 01:45 AM
by David McRitchie Go to last post
5 309
1 Tab per work day in a month by BetaDocuments
Hi, I have reports that I do at work, I need one spreadsheet per month with one work day, or 5 tabs per week. Is there any non macro way to have this being...
October 31st, 2009 11:11 PM
by Don Guillett Go to last post
7 189
Formating a single column of info into 3 columns by Mike Clarke
I need to take a single column of names in excel and have the first line go to column B, the second line to column C the third line to Column D and than start...
October 31st, 2009 08:18 PM
by Gord Dibben Go to last post
1 123
default values in a cell by KRK
Hello, can you help me please Cell B1 contains a complex mathematical formula which requires (in several places) a number from cell A1. Cell A1 can contain...
October 31st, 2009 06:28 PM
by Gary''s Student Go to last post
1 137
help with a formula please by KRK
Hello, I have a long list of numbers (over 600) in a single column, say they are in A1..A600 (they are daily meter readings) . In column B I want to...
October 31st, 2009 01:03 PM
by KRK Go to last post
3 112
How to retrieve tabs by Jorge Cervantes
Hi, I am using Excel 07 (with WinXP Pro). In an excel file (xlsx), there are many tabs. Right now, I do not see any tabs at all. Please advise me how to view...
October 30th, 2009 07:18 PM
by Bernard Liengme[_2_] Go to last post
1 130
Create flashing cells in Excel 2002 by Mei_Mienzi
I've a spreadsheet containing numerous mathematical formulas. I would like to be able to make cells containing a formula flash when the results fall below a...
October 30th, 2009 05:49 AM
by L. Howard Kittle Go to last post
1 210
Duplicate entries by wally
I have been using Conditional Formatting to indicate duplicate entries in a column. This highlights entries seen 2 or more times. This is working well,...
October 30th, 2009 05:47 AM
by T. Valko Go to last post
5 172
How do I shrink an xlsx file after cutting a big data worksheet? by smoore716
I deleted an Excel 2007 worksheet that contained lots of data (approx. 40% of initial spreadsheet size). It resaved to the disk at its previous disk size. ...
October 29th, 2009 11:11 PM
by Gord Dibben Go to last post
2 150
incorporate the remove #DIV/0! code into another formula to get bl by Morgan
hi there, i have this formula below, and i somehow want to incorporate this =IFERROR(B1/C1,"") into it with the purpose of having the cell display nothing...
October 29th, 2009 05:48 AM
by T. Valko Go to last post
5 150
Can a table be linked by Linda
It's been requested that a table in one worksheet be linked to the same table in another worksheet. Can Excel update ALL information changed in the first...
October 29th, 2009 12:36 AM
by JLatham Go to last post
3 200
left vlookup with max by Morgan
hi there, i have two columns of data, for example Column P has a description and Column R has the value, is it possible to find the max value in Col R and...
October 28th, 2009 11:04 PM
by Morgan Go to last post
2 157
Post New Thread


Display Options
Showing threads 861 to 880 of 13737
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:17 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.