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
Dynamic List of names? by RJJ
I have a calendar on a sheet. Under each date of the month, there are various names that are updated and changed frequently (vacation schedule). The names...
May 6th, 2009 08:54 PM
by RJJ Go to last post
2 71
Cell Protection by pen
I need to protect only certain cells in a spreadsheet (mainly those that contain a formula) so that no one can accidentally delete them. However, I need all...
May 6th, 2009 08:48 PM
by Gord Dibben Go to last post
2 73
PDF macro button by Neall
I would like to generate a pdf with my final tally sheet, can someone give me some insight as to what to do, I am using a free PDF creator. Thanks in...
May 6th, 2009 08:47 PM
by Gord Dibben Go to last post
1 91
Hide Blank Rows by TamIam
I don't know how to use macros, (I'm assuming I would need one), but does anyone know of one I could copy/paste into my spreadsheet that will hide blank rows...
May 6th, 2009 08:42 PM
by Gord Dibben Go to last post
3 83
sort and blank cells problem by Mrs T.[_2_]
Hi, sorry - I have another problem! In my assessment sheet the data looks like this... F G H I J ...
May 6th, 2009 08:27 PM
by Mrs T.[_2_] Go to last post
4 124
Splitting data from cells into multiple lines by Igneshwara reddy[_2_]
Hi, I have the data in cells as A1 cell: 123 456 789 A2 cell: abc def
May 6th, 2009 08:15 PM
by Gord Dibben Go to last post
6 108
How do I link 2 spreadsheets to insert amounts on a defined date? by c vandewege
I have a spreadsheet which shows a dollar amount paid out everyday for a two week period for multiple people. I have a different spreadsheet which shows...
May 6th, 2009 08:12 PM
by c vandewege Go to last post
0 91
unions, intersections or array constants by Loadmaster
I am trying to make a conditional formatting formula in cell A3 that goes something like this =$AK$2=JAN, MAR, MAY, JUL, SEP, NOV to format Blue and...
(Multi-page thread 1 2 3)
May 6th, 2009 08:11 PM
by Harlan Grove[_2_] Go to last post
23 226
auto/coditional format by willemeulen[_3_]
I have the following sheet: Column A = value inserted by user Column B = value inserted by user Column C uses index function using column A + B to return a...
May 6th, 2009 07:56 PM
by Tom Hutchins Go to last post
1 79
Hiding sum formula answers in select cells by pen
In Excel 2003 I have a simple sum formula that is copied down the column. When I type in a value, it displays the answer all the way down the column. Is...
May 6th, 2009 07:21 PM
by pen Go to last post
5 69
Subtotals in Excel 2007 by Nicole
Hi, I have inserted a cell below a list to count the sum and below that I have used a formula to get me the subtotal. When I use the filter it shows me the...
May 6th, 2009 07:11 PM
by Nicole Go to last post
0 69
Excel - Check Box Functions by Mags
Is it possible to add a function to a check box so that when it's checked, the words in an associated cell will automatically strike through?
May 6th, 2009 07:03 PM
by Harald Staff[_2_] Go to last post
2 93
how to count charactors in a cell by sherehind
I am in need to figure out the number of charactors in a given cell. Any help would be much appreciated. thanks Excel user
May 6th, 2009 06:42 PM
by T. Valko Go to last post
1 73
in range? by Bruce Bowler
(I hope the following is clear, but it's probably not) Is it possible to construct a formula (I know I could do it in a macro, but for various reasons,...
May 6th, 2009 06:28 PM
by Bruce Bowler Go to last post
4 72
convert seconds to hours and days by Ranjith Kurian[_2_]
in a cell i have 180000 seconds, i would like to convert this to days:HRS:Minutes format
May 6th, 2009 06:21 PM
by Pete_UK Go to last post
3 87
IF Statement by Sondra
I need to create an IF Statement that covers all the following: If State=ID or OR field should say "NO CHARGE" If State=NV multiple field A3 * 6% If State=CA...
May 6th, 2009 05:33 PM
by Jacob Skaria Go to last post
1 84
In Excel 07, how do I merge two sprdshts with a common column? by aleve21
I have two spreadsheets that I need to merge together. They don't share 100% common data, but they have one column of data in common. Anyone know how I can...
May 6th, 2009 05:32 PM
by Dennis Tucker Go to last post
1 77
Solution for if x = 1 and Y =2 goto C3 by Neall
Good day, I am hoping someone can help me with this formula I have a result sheet and on the result sheet I have a section that shows the part number (c33)...
May 6th, 2009 05:28 PM
by Neall Go to last post
2 84
Converting Minutes and Seconds ([mm]:ss) to Decimal by ChasSquirrel
I work on the phone and get paid per minute. I keep track of my calls in a spreadsheet. I have the cell format set to :ss so it still shows minutes even...
May 6th, 2009 04:53 PM
by T. Valko Go to last post
6 99
How do I set a maximum value (e.g. cap at 200) by LeeLobb
I have a formula set to multiply a rate by a quantity, I then need to cap the total at 200 example: 42 people x 86 minutes x $0.05 = $180.60 but I need the...
May 6th, 2009 04:39 PM
by PJFry Go to last post
6 80
Post New Thread


Display Options
Showing threads 11361 to 11380 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:39 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.