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
Using the Time function with an IF statement by Allison Mazurek
HI - I was hoping someone could help me with a time function. =IF(W2=$B$2,IF($Z$2>TIME(11,30,0),'Current Day Balances'!$B$4-'Current Day...
May 31st 16 06:07 PM
by Claus Busch Go to last post
5 1,001
1 Attachment(s) Formula to get the dynnamic date of the month by shiva_reshs
Hello, I have several reports that I need to send to several people on certain days of the month. So to avoid the last minute preparation, I prepare the...
May 31st 16 05:24 PM
by Claus Busch Go to last post
1 933
Dupes in a range by L. Howard
How can I make this formula respond ONLY to two-digit values in a range? (Array Entered) =IF(MAX(COUNTIF(Data1,Data1))>1,"Y","N") Where the values may also...
May 29th 16 10:58 PM
by GS[_6_] Go to last post
7 1,037
Join two functions by b_nuruddin
I have two if(and(or statements that work separately but cant figure out how to join them together into one. Is there a way to join or re-write the following...
May 27th 16 07:07 PM
by b_nuruddin Go to last post
2 1,007
Convert QuickBooks time format to excel to calculate by Misty May
When I export a Quickbooks "Time by Job Summary" report to Excel, the time is converted in a time and date format. If I want to put a dollar amount to that...
3 2,018
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,419
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,484
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,583
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,511
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,466
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,275
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,284
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 3,192
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,919
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,171
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 990
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 989
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,458
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,139
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,258
Post New Thread

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