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
May 13th, 2009 02:33 PM
by Arsalan Go to last post
0 124
Can't get email addresses to be "hot" when using lookup by bsharp
I am using lookup to retrieve email addresses from another workbook. When I simply type in an email address manually, it becomes a "hot" link, where I just...
May 13th, 2009 02:30 PM
by Jacob Skaria Go to last post
3 125
unable to access the commands on the data tab. by tedblandy
I am unable to access any of the icons on the Data tab and the sort function on the Home tab.
May 13th, 2009 02:11 PM
by CLR Go to last post
1 116
auto filter by SPISO
Column A has dates 05/01/09 on down. Is there a way I can auto filter those rows that are between two days back through 6 days in the future? Let say today...
May 13th, 2009 01:57 PM
by SPISO Go to last post
2 234
CALCULATE PROFIT/LOSS by Tree
This is really a basic math question but I thought Excel was the Math Wizard (more so than me) and could help, but this has opened up a bit of can of worms...
May 13th, 2009 01:50 PM
by Tree Go to last post
6 122
Postcode Area extract first alpha letters by aquaxander
Hi, I have a list of postcodes and would like to have only the first letters, whether this is 2 or 1 letter. I have been able to extract the beginning of a...
May 13th, 2009 01:49 PM
by Jacob Skaria Go to last post
3 138
Function to return the last value in a contiguous set of data by Deb
I'm wondering if there's a way to have Excel look for a specific value in a column (e.g. lookup the word "Government" in column A) and then if it finds that...
May 13th, 2009 01:48 PM
by Deb Go to last post
3 140
Derive Average by ryguy7272
I have a year end number (Cell B5) and I can derive my Q4 number by summing Q1 + Q2 + Q3, and subtracting the result from Q4. How do I do this for an...
May 13th, 2009 01:37 PM
by ryguy7272 Go to last post
5 93
Pivot Tables (Sumif) by [email protected]
Although I have fought the urge, I have finally decided to venture into the unchartered territory of pivot tables. I have a large data set with a number of...
May 13th, 2009 11:23 AM
by [email protected] Go to last post
2 134
I want to count the total number of date by shital shah
Hi to all I want to count the total number of date Example:- 26/05/1973 then total of day ie 2+6 =8 than total of all ie 2+6+5+1+9+7+3=33 ie=6 how can I...
May 13th, 2009 10:43 AM
by shital shah Go to last post
0 100
COUNTIF Question by JCarlos
Hi, I searched for my question in these forums, but no one answered it throughly. I work for a high school and I have an excel file with grade data for each...
May 13th, 2009 07:30 AM
by T. Valko Go to last post
6 131
Two search arguments in array formula by Guntars
Hello, With help of this forum I created this array...
May 13th, 2009 06:25 AM
by T. Valko Go to last post
2 83
Moving formula results to blank line by Lversteeg
I was wondering if anyone could help me. I have on one sheet a product selector for my sales team. I have added a column where they can put an "x" into if...
May 13th, 2009 06:25 AM
by Lversteeg Go to last post
3 121
Check for error.type in same cell by art
Hello all: Is it possible to use the formula Error.type to check if the cell has a certain error? So, for example, in cell A1 I start with...
May 13th, 2009 06:14 AM
by T. Valko Go to last post
2 129
RANKINGS by Novice at the Computer
I have numbers in colums G, I and K that i want in a first place to 600 place. Ranking from high to low EG Colum G3 answer is 150 BUT Colum K 15 answer is...
May 13th, 2009 05:56 AM
by Jacob Skaria Go to last post
1 96
"copy" by hsfnwa
The basic theory is everytime when I change the datecell under current, it will automatic copy(link) to the next row instead override the same row Does anyone...
(Multi-page thread 1 2)
May 13th, 2009 05:42 AM
by JLatham Go to last post
10 148
IF statement with multiple values... by guy.pembroke
Hi, I would like to be able to search a group of cells for particular text, placing the true of false value in another cell, using this...
(Multi-page thread 1 2)
May 13th, 2009 03:42 AM
by Ashish Mathur[_2_] Go to last post
12 333
specific percentage formula by Etourneaul
I'm looking for a way to create a formula that shows that if any percentage over 10% shows up red. Any other results below 10% stay black. Currently i have...
May 13th, 2009 03:21 AM
by Etourneaul Go to last post
2 99
replaces formula to its value by InspectorJim
F2,F9,ENTER should replace a formula with its value. For some reason, the Excel I am using at work does not function when I do that. Formula remains as if I...
May 13th, 2009 02:41 AM
by Teethless mama Go to last post
1 102
I need help with a formula........please by Wallie
I have an excel worksheet with pricing........I need to formulate the pricing with an added 7% mark up. Help..........Thanks!
May 13th, 2009 01:13 AM
by pdberger Go to last post
1 105
Post New Thread


Display Options
Showing threads 11141 to 11160 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 12:57 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.