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 do I sort IP addresses is ascending numerical order? by [email protected]
Amplifying Dana DeLouis' solution...The following method works great. You need 6 columns, but can sort on only one. Let's say A2 contains the IPv4 address in...
0 961
Odd results from SUMPRODUCT variance formula by JamesM1986
I'm trying to get descriptive statistics (mean, standard deviation, variance) from data of values between 1 and 7, which need to be weighted. I've used the...
April 6th 16 05:05 PM
by JamesM1986 Go to last post
0 819
Upload an image depending on the value of cells by luis vejarano
good days' group I would like to help me in this VBA script of Excel. I have this code is not mine, I found diving from the network, is free is not...
April 3rd 16 05:07 PM
by luis vejarano Go to last post
2 879
CONVERSION OF TEXT TO DATE by via135
How can I convert list of dates which are in text format in a mixed manner into date format "dd-mm-yyyy" example: Col A Col B 01.04.2013 ...
March 31st 16 12:21 AM
by wabbleknee Go to last post
3 962
excel 2003: how do I fix: "Style 'Comma' not found" by jrp9206
I cannot use any of the format functions in certain excel files that I get from other uses. How can I fix this?
4 3,373
alpha numeric data validation for excel by [email protected]
I want to use a non vb formula in data validation for an excel formula to make the user enter the first 2 characters of a field as UPPERCASE letters i.e....
(Multi-page thread 1 2 3)
March 17th 16 10:16 PM
by comin Go to last post
24 3,280
FINDING OUT SATURDAYS AND SUNDAYS by via135
How Can I create a rule in conditional formatting for highlighting all second saturdays in one clolur,fourth saturdays in another colour and all the sundays in...
March 13th 16 03:37 PM
by via135 Go to last post
4 756
IF statement to show Late Arrival by [email protected]
I have a spreadsheet where I am entering arrival times. I would like for the text to be RED and BOLD if the time is later than 8:00am. I started with...
February 29th 16 04:42 PM
by Claus Busch Go to last post
1 827
Sumprouct with Indext? by [email protected]
Help I have an issue that I ran into. COLUMNS and Rows below data set A(name) B(calls( Alex 10 Alex1 5 Robert 12
2 703
Need (Excel) formula to make Mark sheet with Automatic Grading by Need Formula for Mark Sheet
A B C D SL. # Subject Marks Grade 1 English 96 2 History 58 3 Math...
(Multi-page thread 1 2)
17 15,313
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 741
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 617
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 847
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 637
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 703
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 698
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 662
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 832
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 777
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,945
Post New Thread


Display Options
Showing threads 101 to 120 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 09:19 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.