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
Parsing Question by carl
Is there a formula or a macro that can take this string - 311308 And parse out the data that is contained in the brackets ? For example: 311308 BCE N
April 6th 11 07:26 PM
by carl Go to last post
7 307
Growth Rate for number series by learner
Jan 2125 Feb 2055.63 Mar 2303.889 Apr 2624.77 May 1978.356 Jun 2084.52 I want to calculate the growth rate percent for the above data. The data are not...
April 6th 11 06:11 PM
by joeu2004 Go to last post
2 457
IF this value IS NOT in this range THEN by Iyanna
I have three columns: Column A has a list of account numbers. Column B has a dollar amount. In column F, I have a list of accounts that I want to exclude. In...
April 6th 11 07:55 AM
by owewly Go to last post
6 9,513
Try this array formula** by Jerry van Kalleveen
Another thing. What if the unique values to be counted are not in one column? What if, as in my case, that would be range A12:B40 instead of A12:A40 ? Could...
April 2nd 11 11:25 PM
by Jerry van Kalleveen Go to last post
0 305
Big Bertha Thing letter by Tony Lance
Big Bertha Thing letter Cosmic Ray Series Possible Real World System Constructs http://www.bigberthathing.com/letter.html 4K Web Page Astrophysics net ring...
April 1st 11 04:54 PM
by Tony Lance Go to last post
0 335
Calculating number of workdays between 2 dates by Gibbyky2
here goes i use excel 2007 and can calculate number of days between 2 dates using networkdays function. but my colleagues use older versions of excel and...
(Multi-page thread 1 2)
April 1st 11 12:31 PM
by Tariq[_2_] Go to last post
15 1,710
Problem with Formula by Steve M[_5_]
I canot figure out why this won't work--the first fornula does not work, but the second one does--I included both so that you could see what I have...
March 31st 11 05:26 PM
by joeu2004 Go to last post
1 291
Copy all text in a string prior to the last period... by Andrew Bell
Hello, I am trying to gather all text before the last period in strings of text, for example I want to take everything before the file extension below, and...
March 31st 11 07:19 AM
by Rick Rothstein Go to last post
2 419
SHOW AUDIT ARROWS by ZOEY GREENE
how can I show viewers the audit trail arrows in a saved filed? say, when I email an excel file, I want the recipients see the audit trail arrows when they...
March 31st 11 01:33 AM
by gahrahm lee Go to last post
1 688
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 359
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,817
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 486
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 375
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 10:08 PM
by Daniel Miz Go to last post
2 391
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 10:03 PM
by Daniel Miz Go to last post
0 361
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 05:53 PM
by Skip[_2_] Go to last post
3 440
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 11:45 AM
by Skip[_2_] Go to last post
0 344
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 08:24 PM
by Pete[_7_] Go to last post
3 520
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 07:09 PM
by gundesvan Go to last post
1 1,761
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 398
Post New Thread


Display Options
Showing threads 2001 to 2020 of 88523
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 02:09 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.