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
Button, now too thin, cannot select to delete by Steve
I inserted a button on my worksheet, but didn't select the format control/properties to not move or size it with the cells. Somehow it's become a very thin...
March 26th, 2010 05:47 PM
by John Go to last post
7 128
IF or VLOOKUP by Mark
Trying to look at value in one cell(column), then see if a value in another cell in the same row equals a specific value, then return True or False
March 26th, 2010 05:29 PM
by David Biddulph Go to last post
4 127
Ageing dates by Donna[_5_]
First let me say how much you all have helped me in my job to make our processes more efficient. You make me look like a star at work, but only Microsoft...
March 26th, 2010 05:28 PM
by David Biddulph Go to last post
4 108
IF with function as false return by Lyn Sweetapple
I am creating a to do list in Excel 2003. I have 3 columns, A "Finished" with x if complete; B "Due Date" with a date; C "Days to Go". I want the Days to Go...
March 26th, 2010 05:25 PM
by Eduardo Go to last post
4 111
Imposs? Speed up by LiAD
Hi, I posted this but I haven't had any answer. Does this mean that no-one understands or its impossible? Afternoon, Sorry i forgot to put in the formulas...
March 26th, 2010 05:21 PM
by T. Valko Go to last post
1 110
Unable to Unlock Workbook by Adrian
In my workbook it was password protected and able to be unlocked, now when trying to unprotect it the option to unprotect is grayed out 3 other clients are...
March 26th, 2010 05:16 PM
by Mike H Go to last post
1 101
List the last amount that is state by PSL
I have a worksheet where each month I add data and have rows Jan-Dec listed. I add data to the worksheet each month. I want a formula where it will look at...
March 26th, 2010 05:12 PM
by T. Valko Go to last post
2 124
Trying to match 1 value to multiple columns by sjoseph371
I have a spreadsheet with several different worksheets. On Worksheet 1, I have the following: (Col A) Structure Number, (Col B) Opening Height 1, (Col C)...
(Multi-page thread 1 2)
March 26th, 2010 04:54 PM
by Herbert Seidenberg Go to last post
10 180
How to carry Excel balance on 1 w/s to another? by SamZ
I am looking to carry a balance on one worksheet to the next. I know that the $ is used but cannot find the format.
March 26th, 2010 04:34 PM
by John Go to last post
1 89
Last cell with data in a range by iamjbunni
I enter weekly data into a spreadsheet with a summary page at the front. After every week, when new data is entered, I want the formula at the front to use...
March 26th, 2010 04:05 PM
by Ziggy Go to last post
7 144
March 26th, 2010 02:46 PM
by Padre310 Go to last post
0 94
Calculating percent of times a value is in a column and total # by clbritt76
Ok so I have a column with values in it. Say A4:A12, the values entered will always be 1, 2, 3, or 4. I need a formula that will calculate the % that say a...
March 26th, 2010 02:23 PM
by Mike H Go to last post
2 91
Calculating greatest number in a range by Laura[_9_]
This is a little tricky to explain, but hopefully will make sense. A series of data is produced that monitors concurrent users on a system. This is returned...
March 26th, 2010 12:37 PM
by Laura[_9_] Go to last post
2 88
Round by Vladek
I'm making price list. 150 articles and I want that every price have last number 9. Ex. 1651,00 = 1659,00 1255,00 = 1259,00 etc... Help!
March 26th, 2010 11:21 AM
by Vladek Go to last post
4 83
feet and inches to meters by scott
what formula will allow me to convert feet and inches to meters. current format of cell is 5’05.00” -- Thanks in advance
March 26th, 2010 08:04 AM
by David Biddulph Go to last post
4 176
can't use append xml results. Its always grayed out by dz
I want to append xml results to existing xml tags. The properties menu has an option for appending xml results but this is always grayed out. It tried...
March 26th, 2010 07:59 AM
by dz Go to last post
0 132
Updating Consecutive Cells in a Range by Stilltrader47
How can I update the next consecutive empty cell in a range each time a value is entered in the same cell? For eample, I enter bank account balances in cell...
March 26th, 2010 07:38 AM
by ozgrid.com Go to last post
1 97
Drag Mouse and Add-up by MojavMic
Hi there, I used to be able to drag the mouse over several cells and pick other cells as needed with & Click. The sum of all these cells would have shown...
March 26th, 2010 03:49 AM
by FSt1 Go to last post
1 103
Calculate the number of days to exclude Sunday & Holidays by LSG
I need to know what the third business day from a Manually entered date in Cell B37 to exclude Sundays and Holidays. So far I...
March 26th, 2010 03:14 AM
by T. Valko Go to last post
6 225
How can I use a pivot table as source for a second table? by Rene
In XL 2003 you could select another pivot table as source data for a second pivot table. How do you do this for XL 2007?
March 26th, 2010 03:08 AM
by Ashish Mathur[_2_] Go to last post
2 129
Post New Thread


Display Options
Showing threads 1781 to 1800 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 11:32 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.