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
linking sheets to recognize words by drea3128
I am trying to link sheets where if I change a cell under a certain name on page 1 it will recognize the name on page 2 and change it in the correct cell, is...
September 22nd, 2008 04:45 PM
by Pete_UK Go to last post
1 140
Regional Language by [email protected]
Hi I can not write in my regional setting language in Visual Basic editor in Excel, although I have Office language support, any help? I am writing a module...
September 22nd, 2008 04:14 PM
by [email protected] Go to last post
0 127
Filter every 25th record by Tammy
Hi - does anyone know if there is a way to pull from a list of data in Excel 2007 every 25th record? In some cases it may every 10th record, or 50th...
September 22nd, 2008 03:48 PM
by David Biddulph Go to last post
3 107
function to add time totals over 24 hours by mikesteven
I have a total column that gives me the difference of start time to end time. It is formatted as 13:30 in excel. I need to now add all the totals. I used to...
September 22nd, 2008 03:38 PM
by Barnabas Go to last post
2 143
3 Flag Icon Set not computing correctly by Melody
In an assignment for college, we used the 3 flag icon set to conditionally format a column of revenues with $110,000 being the highest value. Any ideas why...
September 22nd, 2008 03:15 PM
by Melody Go to last post
2 132
Mark date that has passed by Michaela
Hi! I wonder if someone can help me finding the right function. I have a worksheet over dates. The left columns contains dates (my input) and the right...
September 22nd, 2008 02:31 PM
by Michaela Go to last post
5 174
Need a Function by akemeny
I currently have the following function calculating: =IF(OR(AA7="",AD7""),"",TODAY()-(AA7+65)) AA7 and AD7 are date columns. The column they calculate in...
September 22nd, 2008 01:59 PM
by Ashish Mathur[_2_] Go to last post
7 183
Advanced Conditional Formatting by [email protected]
To those who understand these things better than me... I have a column of data that contains information about visitors to my website. E.g. Column...
September 22nd, 2008 01:33 PM
by Mike H Go to last post
8 173
Manipulating Text to create HLOOKUP by CW
Hi, I get an HR report that lists in one column the dept # and in the next the employee name... so there are multiple rows with the same dept#. I want to...
September 22nd, 2008 01:23 PM
by Ashish Mathur[_2_] Go to last post
8 413
circular reference calculation error by Alexey[_3_]
Please help me to resolve circular reference calculation error A B C 1 vegetable 2 fruit ...
September 22nd, 2008 01:18 PM
by Fred Smith[_4_] Go to last post
2 177
Number in words. by RAHUL
When I enter the formula i.e. =Bahttext it comes in different language i.e. not come in English after changing the setting in control pannel. e.g. if amount...
September 22nd, 2008 01:04 PM
by Niek Otten Go to last post
1 124
Conditional Formatting by Eán[_2_]
Hi Help please I have entered the following formula into my conditional formatting boxes, formula is: C17,1 C17,2 C1=0,3 So that the cell would then be...
September 22nd, 2008 12:08 PM
by Ashish Mathur[_2_] Go to last post
2 121
Formula selecting first 1400 rows of column, need ALL of it. HELP by Jennifer C.
Formula selecting first 1400 rows of column, need ALL of it. HELP!! Okay when I evaluate a formula in an Excel file, I find this within the formula when I...
September 22nd, 2008 12:00 PM
by JP[_5_] Go to last post
9 187
can't get lookup to work when i need it to report from a cell ref by welshmatt
Hi I am trying to convert the following nested if statement to allow me to be able to choose from more than 8...
September 22nd, 2008 11:22 AM
by Dave Go to last post
6 176
Random Sample by Funkyfido
I have a list of data in excel. Is there anyway that excel can pick a randam sample of say 20 entries?
September 22nd, 2008 11:09 AM
by Mike H Go to last post
2 113
arranging sheets alphabatically by Thakur Praveen Kumar
I have opened 54 sheets in a worksheet. Please tell me how to arrange them alphabatically?
September 22nd, 2008 10:16 AM
by Bob Phillips[_2_] Go to last post
2 190
User Defined Functions by CH
I occasionally mke user-defined functions in VBA. I am trying to write a function using the LOG10() function and the FIXED() function and I get an error for...
September 22nd, 2008 10:16 AM
by James.Z Go to last post
4 115
advanced 'if' multiply by spezticle
variables: A = base pay rate B = overtime pay rate x1 = hours worked in pay period 1 x2 = hours worked in pay period 2 y = money earned z1 = hours week 1 ...
September 22nd, 2008 08:44 AM
by David Biddulph Go to last post
3 100
Count Duplicate Numbers by farid2001
Hello I would really appreciate some help here. I want to count duplicate numbers based on a time spam. I've already got the duplicate dialed number Count...
September 22nd, 2008 08:04 AM
by Stefi Go to last post
4 119
comparing 3 columns by Ukiuki
How do I compare 3 columns? Need to know the data in all 3 columns are the same.
September 22nd, 2008 08:01 AM
by Stefi Go to last post
6 196
Post New Thread


Display Options
Showing threads 20081 to 20100 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 09:46 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.