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
Change order of string by GavinS
In A1 I have the string DOE, JOHN PETER MR (SEE SMITH) What I would like to do is compose a formula that can reorder this string to read MR JOHN PETER DOE...
December 19th 15 07:32 PM
by Claus Busch Go to last post
6 1,026
Want to Improve Formula by tb
I managed to create the following...
December 16th 15 09:14 PM
by tb Go to last post
0 1,109
30 4,703
Calculating a running Average between dates by San[_4_]
Hi, I have a table consisting two columns - Date (dd/mm/yyyy) & Fuel Price...
December 10th 15 08:35 AM
by San[_4_] Go to last post
2 1,514
Validation list source is a list of comma separated values in asingle cell by [email protected]
Is there a way of making the validation list reference a single cell but in that cell is the list of acceptable values which are comma separated. I think this...
December 8th 15 08:33 PM
by GS[_6_] Go to last post
8 1,282
permanent conversion of 1904 date format to 1900 date format by Jos
I have an old spreadsheet in Windows that has the 1904 date format as basis. All my other spreadsheets are in the 1900 date format. Are there any utilities...
November 26th 15 02:48 PM
by Agostino Banchi Go to last post
4 2,886
Obtain the value in a cell offset form the first cell of a named range by [email protected]
I am trying to figure out a formula which obtains the value of a cell which is offset from the first cell of a named range. I have tried something like this...
7 1,232
Excel to oracle copy paste by [email protected]
i have excel file with 1000 lines with 4 fields like - 1 Amount 2 Tax code 3 cost center 4 discription right now am copy and paste it manually in oracle AP...
0 1,048
formatting numbers as 1st 2nd by Bob Arnett
Is there any way to display numbers in the mode of: 1st 2nd 3rd 4th etc. ?
(Multi-page thread 1 2)
13 1,908
Multiplying a Number Found in an Alphanumeric String by Randomerz
I am working on a project that someone none-too-bright started. The cell that I need to update looks like this: Monkeys $233 Dogs $159 Yes, these four line...
November 15th 15 04:13 PM
by Claus Busch Go to last post
9 1,727
1 Attachment(s) stock sheet by montypython
Hi Guys I have attached a template which can be changed I need to make boms or have scenario where if I enter 10 bent spikes for powder coating, it minuses...
November 11th 15 08:24 PM
by GS[_6_] Go to last post
1 1,104
Number values by CP514
Hello experts, i have a huge database of entries from a survey generated from google forms into excel. long story short i have various pivot tables and...
November 11th 15 07:53 PM
by CP514 Go to last post
3 982
FREQUENCY FORMULA by rhhince[_2_]
I have this formula in Excel 2003. =MAX(FREQUENCY(IF(AM$67:AM$2001=AN4,ROW(AM$67:AM$2001)),IF(AM$67:AM$2001<>AN4,ROW(AM$67:AM$2001)))) I am trying to calculate...
November 8th 15 09:01 AM
by abmmusic4 Go to last post
3 1,002
1 Attachment(s) Need Help With dates and linking it by Jaddo92
Dear Team, i have an excel sheet as per the attachment below what am trying to do i need to find a way on the right there's Days Left and before i have 2...
November 7th 15 12:59 PM
by Jaddo92 Go to last post
0 913
Static date not working using VBA by Joe Clarke
I am trying to insert a static date into column P (from p7 down) if the adjacent column is populated. I need it to remain blank otherwise and the O column is a...
November 6th 15 01:26 PM
by Claus Busch Go to last post
1 934
Help With Extracting Text String by tb
I am using Excel 2013 (32-bit) on a Windows 7 PC. I am trying to extract part of a string for each part number in my file. I would like to extract the string...
November 3rd 15 11:29 PM
by tb Go to last post
2 840
Conditional Formatting not working right by Christopher Jack
Hello, I have a time tracker with calculated times, then based on input of actual times the color of the time is suppose to go red if greater then the...
October 24th 15 07:03 PM
by Christopher Jack Go to last post
1 1,141
formula to switch last/first name around? by Stilla
Is there a formula I can copy into say, cell B1, that will change a name in cell A1 from "Brown, John" to John Brown? Thanks to all you excel wizards out...
October 21st 15 06:07 AM
by Claus Busch Go to last post
8 4,169
How to save random numbers? by Rangemaster
Hi folks, Hopefully someone can help me with this question - it bothers me for hours now and I can't find the answer anywhere on the WWW. I'm making an excel...
7 1,800
Converting google flights results to Excel by [email protected]
Hi, I am not sure if this is the right group to ask this question but: I want to be able to copy google flights result to excel such that price, destination,...
0 1,088
Post New Thread

Display Options
Showing threads 141 to 160 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 10:02 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.