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
Excel Dates by [email protected]
Hey there,, I am trying to make a weekly excel tab on excel. I have 53 tabs, the first tab being a running total and then 52 tabs all for each week of the...
1 852
Help with IF function by Michelle
Am trying to create a formula that will tell me: if the range of cells has the single letter "R" or the single letter "T" in the individuals cells, it will...
(Multi-page thread 1 2)
14 1,565
Dynamic Range Name that's driving me nuts by [email protected]
I've created a Dynamic Range Name that uses the OFFSET() function with some embedded MATCH(), VLOOKUP(), & SUMIF() functions. That Dynamic Range is being used...
September 14th 16 10:28 PM
by GS[_6_] Go to last post
8 1,136
how do I delete data in a cell without deleting formula? by tripy
after adding data to a formulatted cell on a worksheet, i save as, and then use the previous worksheet and delete data to start another worksheet. when doing...
5 3,843
First day of the next bi-weekly Sunday to Saturday payroll period after a given date by ElizabethWells
Hi, In a 401(k) plan, employees enter the plan on the first date of the next payroll period after they've been employed for 120 days. I can calculate 120...
September 4th 16 09:57 PM
by GS[_6_] Go to last post
6 1,110
Need Function that returns active sheet name by arcibald tuttle
something like the ACTIVE.CELL() function but ACTIVE.SHEET() and ACTIVE.WORKSHEET() which i guessed don't seem to work. anybody? thanks,
September 3rd 16 04:57 PM
by Claus Busch Go to last post
1 827
calculate percentage of month passed by Anita
I want to know how many days have lapsed in a month, every month, as a percentage. So far we are doing it week by week, ie after the first week has gone we...
4 6,914
sum last N rows not being a weekend by [email protected]
Hello I have data in two columns: column A having dates and a corresponding amount in column B. Now in column C, I would like to have a formula which would...
3 702
Calculating Date of next birthday by Ken Lumley
Perhaps a strange type of request however I have a list of 500 birthdates and I need to calculate 30 days before the next birthday for each and display that as...
8 2,664
How to calculate hours based on certain criteria by [email protected]
Hi, I'm using a spreadsheet to keep track of my driving times, to make sure I get all the hours needed to get my license. All I have now is a column for START...
6 723
Excel POWER Function | What's the formula for by Punjabi Mathematician
What's the mathematical formula behind the Excel Power Function? POWER(number, power) How do you determine the value of (2)^(0.5) or POWER(2, 0.5) " The...
August 15th 16 02:15 PM
by Punjabi Mathematician Go to last post
3 822
If function with lookup by alphanull
I am working on a spreadsheet that looks at the year entered then applies a specific multiplier (percentage). It would be nice if instead of adding to the IF...
August 12th 16 04:17 PM
by alphanull Go to last post
4 629
Error in Calculating investment return in Excel using IRR or XRR by [email protected]
Hi everyone, I was hesitant to post here until I really exhausted all my brain power. Firstly thank you for reading my post, your time is precious and I really...
August 1st 16 01:32 AM
by ltomama0945 Go to last post
2 1,168
Future Value with Interest the compounds every 3 years by AdmiralAJ
I'm working on a trying to set up a formula for services where the cost increases 6% every 3 years over the next 15 years. The standard FV function doesn't...
July 31st 16 07:32 PM
by LeHuonngh2 Go to last post
2 810
How can i calculate the first sunday of each month by [email protected]
Would it be this if I want it to do it for all rows and the A column has all the dates to be validated? =DATE(YEAR($A:$A),...
1 597
If statement to compare time cell to a time by Z-Man-Cek
Hi Friends, Here's the equation that isn't working: =if(and(E5<$A$2,F5>time(06:00:00),F5<=time(14:00:00)),"1st...
(Multi-page thread 1 2)
July 29th 16 08:17 AM
by Tindien3579pro Go to last post
16 3,705
Formula doesn't work unless hit enter again by Bobby
I have to select Each cells with a function, than put my cursor in the formula bar and press enter. The excel option 'automatic calculation' is on and was...
5 2,938
Extracting only birthday and month from ID number by Hannes Basson
Good day I used the following function on the ID number: 3308170035186 =DATE(LEFT(D15,2),MID(D15,3,2),MID(D15,5,2)) Then I get the following: 17 Aug 1933
July 20th 16 09:02 AM
by ssixsl Go to last post
4 663
How to detect negative value cells from large size of data by [email protected]
Can anyone suggest how to detect Cells containing negative values form large size of data approx. having 100 columns and rows because filtering the data 100...
July 15th 16 09:22 PM
by Claus Busch Go to last post
2 587
Require help with PROPER function in excel by [email protected]
I faced that PROPER function does not convert text properly. FOr example, Your text is: ThIs IS a rAbbIt. It will convert like this: This Is A Rabbit. If...
July 12th 16 01:48 PM
by Claus Busch Go to last post
1 903
Post New Thread

Display Options
Showing threads 61 to 80 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 03:28 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.