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 calculate variance between numbers? by copitta
I have two columns of scores. I need to calculate the variance (difference) across the two columns, with the result in column three. Seems simple but I...
5 2,318
data arrangement by Nitya Satheesh
Hi ! I have a 2 worksheets with data, worksheet 1 col A Col b colC point location value 1 3 a 1 4 a 2 5 ...
May 19th 16 08:36 AM
by Nitya Satheesh Go to last post
4 1,371
Displaying all combinations of a range of numbers by Mally
How do I display all the combinations of a group of numbers Example Cell A1='3' Cells B1='1', B2=3, B3=9, B4=20, B5=25 This will display all the...
May 10th 16 07:54 AM
by mpokos Go to last post
5 2,460
SUMIFS linked to other workbook, returns #VALUE! by GijsKijlstra
Besides 2016 data in my 2016 workbook, I have there 2015 data for comparison purposes, with SUMIFS formulas linked to my 2015 workbook. The 2016 workbook...
May 9th 16 03:42 AM
by GijsKijlstra Go to last post
2 1,379
Min function pull down formula by L. Howard
With columns A & B, in column C a formula to pull down that will return an "m" for the minimum value of the A column "groups". So for the three 123's the min...
May 5th 16 05:58 PM
by L. Howard Go to last post
4 1,344
time decision for open file in Excel by [email protected]
20 hours before current time is today,open file A 20 hours before current time is yesterday open file B. How can I use IF THEN function in EXCEL macro
3 2,161
Can't insert a new worksheet by [email protected]
On Sunday, August 1, 2010 at 2:19:26 AM UTC+5:30, Jack Deuce wrote: > I have 4 spreadsheets, one for each school, each containing 100+ > worksheets with the...
0 1,172
Convert minutes into hours and minutes by southtxxbox
I use a spreadsheet that totals minutes in different cells. I need those totals added then converted into hours and minutes, NOT into days and hours and...
(Multi-page thread 1 2)
10 2,993
data analysis by Nitya Satheesh
Hi ! My data looks like this col1 col2 1/1/2014 species 1 2/1/2014 species 1 2/1/2014 species 2 3/1/2014 species 2 4/1/2014 ...
(Multi-page thread 1 2)
April 27th 16 06:37 AM
by Nitya Satheesh Go to last post
12 1,753
Date function expanded by ahmed[_4_]
Hi, I have a worksheet for students fees collections. A1: Student Number B1: Student Name C1: Fees (amount) collected D1: Fees for which month? (number 1604...
April 23rd 16 09:35 AM
by ahmed[_4_] Go to last post
5 1,073
Date Functions by ahmed[_4_]
Hi, I need unique number to identify each month in the calendar system. The formula...
April 22nd 16 01:34 AM
by ahmed[_4_] Go to last post
4 900
Can't insert a new worksheet by [email protected]
Thank you from me too. I just went through exactly the same issue and this thread got me through it:)
0 907
Productivity Log by drew
Ok, I have a difficult scenario. I have all of these folks entering all the work they have done throughout the week into a log. I then take their weekly...
April 15th 16 08:54 PM
by ANoline Go to last post
3 2,361
Productivity Statistics by ANoline
I am using the following formula to calculate a statistic for employee...
April 15th 16 08:41 PM
by ANoline Go to last post
0 1,061
Excel file too big even when I delete all cells by [email protected]
My file size is 700 KB for a spreadsheet with little text and few formulas with links but no macros. I deleted the cells to the right and bottom of the cells...
(Multi-page thread 1 2)
11 5,073
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 1,159
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 998
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 1,020
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 1,111
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,532
Post New Thread


Display Options
Showing threads 101 to 120 of 88519
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 06:47 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.