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
how to replace #N/A with my Vlookup by [email protected]
Cant seem to work this out, can you please show me how to replace the #N/A with a blank if the value searched is not found =VLOOKUP(D2,Q2:W47,6, False) many...
February 15th 16 09:27 PM
by Claus Busch Go to last post
1 665
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 11:01 AM
by TheExpat Wanderer Go to last post
0 562
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 08:20 PM
by Brian Go to last post
8 794
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 591
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 641
Add Company Holidays to Formula Calculation by tb
I have created the following...
January 28th 16 07:45 PM
by tb Go to last post
0 637
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 598
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 05:07 PM
by Claus Busch Go to last post
1 781
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 10:35 AM
by Claus Busch Go to last post
5 711
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 2,788
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 613
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 611
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 655
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 963
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,855
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,315
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 1,876
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,086
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 877
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 705
Post New Thread


Display Options
Showing threads 101 to 120 of 88501
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:11 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.