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
Extract number value from a String. 4'6'' to 4.5 by [email protected]
Hello I wanted to know if I could extract the number values from a Strins. For Eg:- 4'6'' must be taken as 4.5 10'11'' must be taken as...
2 690
oFFSET by [email protected]
Help, I have a huge spreadsheet exported from a different source into excel. Column B Example: Col B Col J 57 (60C) 5 61 (60C) 3 62 (60C) 2 63...
January 13th 16 08:48 PM
by Claus Busch Go to last post
1 675
Books by Brian
Many, many years ago I use to earn my daily bread by writing code for Dos using Microsoft Masm. In due course I transferred to C (but not C++) and then to...
January 13th 16 07:43 PM
by Brian Go to last post
5 739
Conditional Formatting with VLookup and Offset functions by Phrank
Hi. I'm working with Excel 2010. I have two sheets. I have a value in column D on Sheet1. I need to look up that value in Sheet2, column A. If that value...
January 10th 16 10:51 AM
by Claus Busch Go to last post
2 1,076
Concatenate Strings And Values To Create Formula by tb
I am using Excel 2013. Cell AL7 has the value 7 in it. I have created the following formula in P7: =concatenate("=","A",AL7) The hope was that this would...
January 6th 16 04:10 PM
by GS[_6_] Go to last post
8 1,998
How do i increase the height of the worksheet tab in Excel? by DailyExcelUser
I really would like to increase the height of the worksheet tab at the bottom of the screen. I have so many tabs and hate scrolling. Would rather have the...
January 5th 16 07:50 AM
by linojohnson Go to last post
7 3,480
How do I copy formulas from one wkb to another w/out linkng them? by tomcat
How do I copy a formula from one workbook to another so that the pasted formula does NOT have a link back to the copied workbook...... ...
(Multi-page thread 1 2)
10 2,019
Round dollars by SpikerzZ
Hi, I want to know if there is a way to round a price to either $99.99 or $49.99? For example, I want a computer price that is $1,069.82 to round down to...
January 2nd 16 08:24 AM
by Vicky Jorwal Go to last post
1 1,194
Total Number of shifts calculation by Smirre
Hi, Can someone please help me with a formula to convert following Total hours worked into total nimbers of shifts @ 8 hours eg. 133:42:40 = 16.7...
4 978
Help With Sorting by tb
I am using Excel 2013 for Windows. I am trying to sort some bin location in a specific way and don't know how to do it. We have a three-tiered vertical rack...
December 31st 15 09:17 PM
by Claus Busch Go to last post
5 792
Formula for Win/Lose Streak by [email protected]
The row itself: http://i.imgur.com/5VbTDqs.png I'm trying to have a formula that will figure out which was my longest win and lose streak (where any value...
December 21st 15 02:18 PM
by Vuko Strugar Go to last post
3 901
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 08:32 PM
by Claus Busch Go to last post
6 941
Want to Improve Formula by tb
I managed to create the following...
December 16th 15 10:14 PM
by tb Go to last post
0 987
30 4,240
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 09:35 AM
by San[_4_] Go to last post
2 1,388
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 09:33 PM
by GS[_6_] Go to last post
8 1,169
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 03:48 PM
by Agostino Banchi Go to last post
4 2,791
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,111
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 945
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,736
Post New Thread

Display Options
Showing threads 121 to 140 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:33 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.