A Microsoft Excel forum. ExcelBanter

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 » ExcelBanter forum » Excel Newsgroups
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Post New Thread
Threads in Forum : Excel Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Retrieve data based on 3 criteria by Pete[_7_]
In col A, starting at A3 have a list of customer names. The columns B1:E1 are labeled 1,2,3,4 respectively, indicating option numbers. In Columns B2:E2 is the...
March 21st 11 09:24 PM
by Pete[_7_] Go to last post
3 436
1 Attachment(s) Looking up cells with vb by gundesvan
Hi I have created a spreadsheet where I can type a lot of different amounts. So that I can easily get an overview of how the economy to a corporate...
March 21st 11 08:09 PM
by gundesvan Go to last post
1 1,694
get a cell reference as a result of an If Function by coolistic
Hello, This is more complicated than it sounds. I need to do an If function to get a cell reference as a result... Let me give you my situation.... I have...
1 307
path too long solution by dan gurt
http://LongPathTool.com Filename is too long? Computer Complaining Your Filename Is Too Long? The Long Path Tool Can Help While most people can go about...
March 20th 11 10:09 PM
by dan gurt Go to last post
0 265
Consolidate two Data Sets for Making a Report by Nano
Hey, I have two sets of data DataSet1: Materials sold per country along with other information like forcast and inventory. DataSet 2:
March 20th 11 03:07 PM
by Donald Guillett Go to last post
1 272
Binary operator >> (?) by Scossa
Hello, I' apologize for my bad english...... Everyone know logical operator "=", ">", "<", ">=", "<=", but i found that this operator ">>" in a function like...
(Multi-page thread 1 2)
March 19th 11 02:13 AM
by Ron Rosenfeld[_2_] Go to last post
13 422
Manipulating imported times by Xt
Hi folks. I have copied some athletic times from a website into Excel 2007. These times look like 03:56.8 on the website and in the body of the worksheet. I...
March 19th 11 12:25 AM
by Gord Dibben[_2_] Go to last post
3 241
Function problem with iPhone/Pad compatibilty by [email protected]
Hi I have a spreadsheet that I have tried transferring to iPhone/iPad, but it seems to have an incompatible function that the i-Series moan about. I want to...
1 350
Use 100 separator inspite of 1000 separator in excel by Montu
Suppose A1 number is 120000.00. Now I want to separate it by 1000 & 100, i.e. 1,20,000.00. If I format the cell - Number & click on 1000 separatetor. It show...
(Multi-page thread 1 2)
March 16th 11 08:45 PM
by joeu2004 Go to last post
10 4,065
Manipulating matrices of unknwon (a priori) size by Euh
Hello, In one of my worksheet, a user has to input columns of data. The categories (columns) are fixed, but the number of data (lines) may vary, I eventually...
March 16th 11 07:14 PM
by Pete[_7_] Go to last post
1 285
what is the excel formula for market volatility? by Dyn
anybody knows the formula??
March 16th 11 07:54 AM
by Jakes Norm Go to last post
8 2,559
Calculating Sortino Ration (Downside Deviation) by TimH
I am trying to write a formula to calculate the Sortino Ratio defined as (Expected (Observed) Return - Minimum Acceptable Return(MAR))/Downside Deviation. ...
March 15th 11 01:21 AM
by Moti wig Go to last post
7 8,323
Conditional formatting backwards compatibility question by Vladimir Shchelkunov
Hi All I'm having some issues with backwards compatibility of a file with conditional formatting built in 2007. I have a cell (M63) that has 2 conditions...
March 15th 11 01:20 AM
by Vladimir Shchelkunov Go to last post
0 398
Signature question by ElaineT
I am trying to set up a workbook with multiple tabs and two signature lines at the bottom. The idea is that my boss can read, sign and close my work as...
March 12th 11 08:15 AM
by martincrow Go to last post
1 1,557
using the 'Convert' function by M-A H
Wish to convert CBM to FT3 andy suggestions on what the formula should be..? TY
March 11th 11 01:29 PM
by Bijender Singh Go to last post
7 2,404
Path Too Long fixer by dan gurt
http://LongPathTool.com Don’t you just hate it when you get error messages that say “The path is too long” or “Error cannot delete file: cannot read from...
March 10th 11 10:37 PM
by dan gurt Go to last post
0 228
Path Too Long fix by dan gurt
http://LongPathTool.com Do you have error messages?, like : Path too long. Error cannot delete file: cannot read from source file or disk Cannot delete file:...
March 10th 11 04:13 AM
by dan gurt Go to last post
0 342
optimization by dschneiderch
I will try to explain clearly. I have a bi-linear curve and I would like to know where the breaking point is. Looking at a graph of the ordered data (highest...
1 257
Count by Skip[_2_]
I have about 500 sales entries. Using autosort, I pull out all Mondays (they are scattered though out the 500) I want then to count then number of Monday...
March 8th 11 05:29 PM
by David8 Go to last post
3 401
time window calculation by SteveR
Thanks Joe. I did know about making that substitution but must have messed it up due to being in a hurry. I just did it more carefully and all you formulas...
March 8th 11 04:53 AM
by SteveR Go to last post
0 281
Post New Thread

Display Options
Showing threads 2001 to 2020 of 88510
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 On
HTML code is Off
Forum Jump

All times are GMT +1. The time now is 12:37 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright ©2004-2017 ExcelBanter.
The comments are property of their posters.