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
how do I achieve my xl spread sheet in Alphabetical order by Generous
how do I structure my spread sheet to decend Alphabetical.
May 4th, 2010 12:34 AM
by JLatham Go to last post
1 146
conditional format help by hj
column A is my finished date, column C is my serial #. If I enter the same serial # within 180 days of my finshed date what formula can I use to turn cell...
May 4th, 2010 12:31 AM
by JLatham Go to last post
3 170
Conditional Formatting - stuck on formula by Awrex
Hi - Thanks beforehand! I'm stuck on a formula for a condition and hoping someone can help. =AND($H23="stalled",$G23TODAY()) Is currently what I have and...
May 3rd, 2010 11:48 PM
by Fred Smith[_4_] Go to last post
3 147
Simple calculation where values change to letters? by Zuo
I have a simple formula (A1*B1*C1)/((A1*B1*C1)+(D1*E1*F1)+(G1*H1*I1)). However there are times when the values of D through F or the G through I denominators...
May 3rd, 2010 11:48 PM
by Zuo Go to last post
3 189
Find latest date from list and corresponding info by MCRH
Hi, I have a list like the below and am trying to: A) Find most recent date of each color group (ColC) B) Then, from that date, find corresponding number...
May 3rd, 2010 11:27 PM
by Teethless mama Go to last post
2 176
How can I reference a worksheet in a formula based on a cell value by JZinGA
Row 1 contains labels / headings: A B C Sheet 1 Sheet 2 Sheet 3, etc. In row 2, part of the formula will look to a...
May 3rd, 2010 10:57 PM
by David K.[_5_] Go to last post
1 202
Excel and consecutive number by Shadowkiller361
Is there a way to have excel locate a set number of consecutive non-zero numbers and give me an average of those numbers? trying to get around this problem: 5...
May 3rd, 2010 10:17 PM
by Shadowkiller361 Go to last post
2 137
IF function by winnie123
Hi there, I am trying to project FY sales based on open orders,shipped orders and forecast. I have pulled together the 3 lots of data and used SumProduct to...
May 3rd, 2010 09:34 PM
by winnie123 Go to last post
4 207
countif/sumproduct + month by MM
Hi all, Fourth try's a charm....I'm getting errors trying to post my question. Here it is... 1 workbook, 4 worksheets each named for a different...
May 3rd, 2010 09:16 PM
by Teethless mama Go to last post
1 178
counting occurences of month on a specific worksheet by MM
Hey all, Second time on here. You were all helpful the first time round. Here's the question: I have 5 worksheets in my workbook. Each worksheet...
May 3rd, 2010 09:06 PM
by Fred Smith[_4_] Go to last post
1 206
Proper Formula is stuck and does not work by Diggsy
Hello, I was wondering why my text formula of proper is not working. I have placed the formula =proper(f2) in column e2 All I get is the formula =proper(f2)...
May 3rd, 2010 09:03 PM
by Hemant J Go to last post
4 130
Lookup / Summary Table by Joe
I want Excel to lookup a value in a table and return each row it finds that value in. As an example: Lookup Value: Ford Lookup Table: A1: Ford B1: Focus
May 3rd, 2010 08:44 PM
by Joe Go to last post
0 142
how to change the pivot chart automaticaly as values in the worksheet change by Vinay Vasu
Hi, I would like to know how I can make the pivot chart change automaticaly as I change the values in the work sheet? I also would like to know how can i...
May 3rd, 2010 04:25 PM
by Vinay Vasu Go to last post
0 127
complex lookup by Doug
I have a lookup table that I need to reference. based on a 3 digit # such as "2.22", I need to be able to find the cross section on the lookup table. Based on...
May 3rd, 2010 02:47 PM
by Bernd P Go to last post
8 224
finding 10 smallest numbers from last 20 input by handicapper
I can find the smallest 10 numbers from a range of 20 cells by using "Small". But when the 21st. number is input I want to move the range down one to...
May 3rd, 2010 02:29 PM
by Bernd P Go to last post
8 230
code to copy range by smith82
Hi anyone, I’m having two sheets in my workbook where I have named them as “Receipt” & “Price Range”. I'm searching for a formula that would copy the...
May 2nd, 2010 02:27 PM
by Don Guillett[_2_] Go to last post
1 152
Using Fill command in Editing Group by Caz
Hi, I am trying to find more info on how to use the functions on the Fill Command in the Editing group especially regarding dates as I cannot seem to get...
May 1st, 2010 04:59 PM
by Gord Dibben Go to last post
2 190
Macro for Time Recording by karim
hi, I want to record current time into cell(A2) when cell (A1) does contain value with macro. I want to record it automaticaly without using any shortkey or...
May 1st, 2010 04:53 PM
by Gord Dibben Go to last post
2 128
Format Ratio Q by Seanie
How can I express below in a ratio format? It returns an invalid error. If I was to just do it without the text, I'd simply FORMAT, custom 0.0" :1", but it...
May 1st, 2010 04:17 PM
by Dana DeLouis[_3_] Go to last post
2 125
question related to merging multiple statements by Dharmesh[_2_]
DEAR MR. /MS. I HAVE TWO NUMBERS 4565845 and 1543295 AND A TEXT "ALSO WORKING ECM IN Q 201" I WANT TO MERGE THE RIGHT 4 DIGITS FROM BOTH THE NUMBERS WITH THE...
May 1st, 2010 03:10 PM
by Rick Rothstein[_2_] Go to last post
5 180
Post New Thread


Display Options
Showing threads 821 to 840 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 04:20 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.