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
retrieving deleted spreadsheet by sugamola
Somehow my expense spreadsheet was deleted.Is there anyway to retrieve it?
June 17th, 2009 11:40 PM
by Gord Dibben Go to last post
1 538
How to retrieve data from a table by GRK
I have built a Table (sheet 1) that includes 7 columns (A – G) and 11 rows with the first row being titles. The titles in order are # of Users; Code 1;...
June 17th, 2009 11:16 PM
by Bassman62 Go to last post
1 234
sizing in Drop Down lists by Banker
I have attached drop down lists to a cell on my worksheet. The items in the list are wider than the cell that it will be viewed in. I know I can format the...
June 17th, 2009 10:23 PM
by Banker Go to last post
6 269
Line of Characters by [email protected]
I have cell A1 with a number, let's say 21 I need to find a way to automatically show 21 C's or B's or any character in cell A2 If A1 changes to 24 then A2...
June 17th, 2009 10:20 PM
by [email protected] Go to last post
2 209
SUMPRODUCT Difficulty by Pam
Hi, After reading thru several posts and figuring out that I could not use COUNTIF on non-adjacent cells, I tried using SUMPRODUCT but am still having...
(Multi-page thread 1 2)
June 17th, 2009 10:13 PM
by Ken Wright Go to last post
11 419
unprotect sheet (icon is greyed out) by dj888de
I put a protection on the sheet so it is a read only, but I need to go back in and unprotect it to change some of the cells. The icon is greyed out so it...
June 17th, 2009 08:10 PM
by Gord Dibben Go to last post
1 223
Show prior year based on date in other cell by Munchkin
Is there any way to copy a full date (mm/dd/yyyy), past it into the cells below, but have the year change to the prior year in descending order? Specific...
June 17th, 2009 07:44 PM
by Teethless mama Go to last post
3 193
Conditional format refers to two cells by DOUG
How would I tell excel to format a cell based on values in the cell PLUS a date formula in anouther cell? For example, "if the date in cell P2 is greater...
June 17th, 2009 07:29 PM
by Luke M Go to last post
1 215
How can I set the scaling in my macro? by Gator
I am trying to edit my macro so that it selects fit to page 1x1. How can I move the selector button in my macro to this field? I have added the following...
June 17th, 2009 07:27 PM
by Per Jessen Go to last post
1 141
lookup number greater than by Ade Taiwo
I want to Look in a one-row or one-column range for a value and return a value from the same position in a second one-row or one-column range, but instead of...
June 17th, 2009 06:43 PM
by Luke M Go to last post
1 141
How do I use justify across more than 1 cell in Excel 2007 by Rick
In Excel 2003, you can use justify to make the text wrap at any point outside the host cell. Now in Excel 2007, it seems just to default into a word wrap...
June 17th, 2009 06:33 PM
by Rick Go to last post
0 137
If Statement for a date by jlo
In cell A6 a date is entered. In another cell is a total number of items. To get a total price for the items, I take Total Number of items and multiple by...
June 17th, 2009 06:02 PM
by jlo Go to last post
4 159
lookup number greater than by Ade Taiwo[_2_]
I want to Look in a one-row or one-column range for a value and return a value from the same position in a second one-row or one-column range, but instead of...
June 17th, 2009 05:52 PM
by Mike H Go to last post
3 167
Conditional Formatting Colour and Text Entries by BEEJAY
Please read the whole blurb. Maybe there is a better way!! Question 1: How to conditional format cells with Text drop-down list Question 2: How to insert...
June 17th, 2009 05:49 PM
by BEEJAY Go to last post
0 133
Excel Tables by dwolter
Is there a way to turn off table calculations once calculated (besides the tool - options-calculation - automatic except tables). Does hiding a sheet with...
June 17th, 2009 05:09 PM
by Gord Dibben Go to last post
2 151
How can I find data in one list and add it to another sheet? by soconfused
I currently have two workbooks in which I need to have data from one transfered to the other. One workbook contains many sheets and I need to look in 4...
June 17th, 2009 04:38 PM
by Gary''s Student Go to last post
3 147
Can Excel Rtrn a Value by Referencing Multiple Rows and Columns by Kim[_2_]
I have a reference table which contains multiple commission %'s in 21 columns labeled with 3 letter codes; with rows of commission sources in column A. Each...
June 17th, 2009 04:24 PM
by Kim Go to last post
2 172
changing multiple column references in a formula by JackRosieMaisie
A sheet contains a list of prices that change weekly - 30 products vertically each with a column for each weeks price. Each week a new column is added to...
June 17th, 2009 03:41 PM
by JackRosieMaisie Go to last post
5 169
If statement comparing times by GoBrowns!
Hi; I am trying to write a formula that will let me compare times and assign a shift value (1st or 2nd Shift) based on that..... and I can't get it to...
June 17th, 2009 02:33 PM
by Fred Smith[_4_] Go to last post
1 105
Splitting Data in Cell by [email protected]
I have a database that lists addresses in the following format: 111 Maple Dr. I want to split the street number from the Street name so that I can sort on...
June 17th, 2009 01:09 PM
by [email protected] Go to last post
5 172
Post New Thread


Display Options
Showing threads 10021 to 10040 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 03:16 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.