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
Pivot table - Data Extract by TheExpat Wanderer
please help me, I cant attach files to clarify the issue is there a way to list pivot table data to a normal sheet rows and columns this is my daily work...
February 15th 16 10:01 AM
by TheExpat Wanderer Go to last post
0 679
Margins and cell widths by Brian
I would be grateful for any advice on how to set margins and cell widths in Excel so that when the document is printed the printed document reflects,...
February 8th 16 07:20 PM
by Brian Go to last post
8 911
Combinations by [email protected]
On Saturday, January 18, 2003 at 7:38:57 PM UTC+5:30, João Veríssimo wrote: > Hi! > > I am trying to think how VBA/Excel could list all possible combinations...
0 697
Can't insert a new worksheet by [email protected]
On Thursday, September 11, 2014 at 7:34:29 AM UTC-7, wrote: > Go to Review tab and select "Protect Workbook: In there you will see the...
0 768
Add Company Holidays to Formula Calculation by tb
I have created the following...
January 28th 16 06:45 PM
by tb Go to last post
0 759
Annual leave - list days off by [email protected]
Help! (please) I've looked at using INDEX & MATCH etc for these but can't quite get what I want. I have a list of staff's leave each month, set out as below....
4 717
How do I "not" enter slashes for dates and add "x" number of days to date entered? by yeto
I am trying to "not" have to enter slashes when entering a date and I want to add "x" number of days to date entered? I am using formulas from the following...
January 19th 16 04:07 PM
by Claus Busch Go to last post
1 896
If a cell contains a text (unspicified text) then return thespecified text by [email protected]
Please help me the following: A1= ABSDH (for ex.) B1= STANDARD C1= (if......) formula If I have a specified text in A1 for example (absgdjj) then return back...
January 19th 16 09:35 AM
by Claus Busch Go to last post
5 866
Custom Number by jal111
I'm a surveyor and I always use a number format 0+00.00 for Stationing. Everytime I need to use that format, I always have to create it. It will be nice if...
(Multi-page thread 1 2)
18 3,149
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 760
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 07:48 PM
by Claus Busch Go to last post
1 747
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 06:43 PM
by Brian Go to last post
5 815
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 09:51 AM
by Claus Busch Go to last post
2 1,165
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 03:10 PM
by GS[_6_] Go to last post
8 2,142
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 06:50 AM
by linojohnson Go to last post
7 3,631
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,169
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 07:24 AM
by Vicky Jorwal Go to last post
1 1,302
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 1,070
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 08:17 PM
by Claus Busch Go to last post
5 880
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 01:18 PM
by Vuko Strugar Go to last post
3 977
Post New Thread


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