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
Extracting Data From The Right of a Cell by Brian Ashcraft
Hello All, Thanks in advance for you help!! I am trying to extract data from a single cell in Excel. Example Data: MX04-08-1-EA MX04-1000-100-EA
March 31st 11 12:38 AM
by Rick Rothstein Go to last post
1 317
Create a credit (negative) column in Excel? by AvonSue
I am creating a spreadsheet with debit and credit columns. How do I format the Credit column so all entries automatically post as a credit?
March 30th 11 08:30 PM
by Gord Dibben[_2_] Go to last post
6 2,736
Finding position of last period in filename by Jack Deuce
I have a large spreadsheet of filenames. I'm trying to break the names into Filename and File extension using LEFT and RIGHT functions. I'm having trouble...
March 29th 11 07:50 PM
by Ron Rosenfeld[_2_] Go to last post
6 422
Recursive Functions...maybe by busboy10
Hi All, I am trying to model user adoption based on a s-curve adoption rate for cities. So I have a simple s-function that shows town growth and I want to...
March 28th 11 09:46 PM
by busboy10 Go to last post
0 335
colour numbers by jkf[_3_]
hi all i have a sheet that consists of 7 coloums and unlimited rows, i need to colour a group of numbers so that when they appear they turn a certain...
March 25th 11 11:08 PM
by Daniel Miz Go to last post
2 352
very complex IF function if not an alternative function of crossselection by Daniel Miz
Hi all, Ok ahead of me is very complex scenario that I've been trying to solve for days now. Hopefully someone would be able to help me. So, this is the...
March 25th 11 11:03 PM
by Daniel Miz Go to last post
0 308
I have a column of numbers, some positive, some negative. by Skip[_2_]
I would like to count the number of entries that are >3 and are <=7. What function would I use? Thanks for any help.
March 23rd 11 06:53 PM
by Skip[_2_] Go to last post
3 397
Countif by Skip[_2_]
Can a formula be written using Countif to count a range of numbers? Like >=4 and <7, for example? Thanks for any help.
March 23rd 11 12:45 PM
by Skip[_2_] Go to last post
0 297
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 468
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,722
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 337
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 299
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 296
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 481
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 266
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 396
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,172
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 320
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,623
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,436
Post New Thread


Display Options
Showing threads 2001 to 2020 of 88516
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 06:27 PM.


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