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
Any Way To Specify XIRR Values and Dates Without Using Array? by W
Let's say I have a schedule of cash flows and dates that I want to make calculations of the internal rate of return. But I don't have the data organized in a...
June 11th 15 09:11 AM
by joeu2004[_2_] Go to last post
1 906
Can anyone help with this formula? by dawn48313
Ok to make a long story short I downloaded this Gage Tracking excel work book. Of course because I have office 2003 I had all kinds of formula issues when I...
June 10th 15 06:47 PM
by dawn48313 Go to last post
4 996
IF Statement return wrong comparison by Don B[_2_]
I have a If statement in L95 as follows: IF(L95="District Did Not Investigate" and L95 contains this statement It returns a FALSE answer when the answer should...
June 4th 15 01:12 AM
by Howard Silcock Go to last post
1 826
IF statement returns false when statment is True by [email protected]
I have the following formula: =IF(AND(S95<>"",TODAY()<S95),"Investigating PFM",IF(AND(S95<>"",TODAY()>S95,T95=""),TODAY()-S95&" "&""&"Days Past...
June 3rd 15 03:23 PM
by Don B[_2_] Go to last post
4 855
Exclamation
Progress / Completion bars. Help if you like a challenge! by Callum
I’m trying to create a list of 'completion bars’ or ‘progress bars’ using data bars for a savings budget. So for example: A1 changes...
June 3rd 15 07:09 AM
by Claus Busch Go to last post
6 814
Copy non empty cells into one designated. by [email protected]
I have a single (master) row of data I am trying to fill in from information collected from a Google Form. Some of my pieces of information will only be...
0 585
Date function by Nitya Satheesh
Hi, I have 2 columns of dates , one being the start and the other the end. I need to find out if a certain month falls between a start and an end date. This...
June 1st 15 09:35 AM
by Nitya Satheesh Go to last post
9 886
Countif and Sumproduct Multiple Sheets by Nean
I have a worksheet in which a want to take the data from three columns and put the total number of that data into a new sheet. I am using Excel 2010 and there...
May 30th 15 01:07 PM
by Ron Rosenfeld[_2_] Go to last post
1 636
Add data every 14 days? by Kevin Coleman
Hi, I need to update the data in a specific cell whenever 14 days has passed. That is I want to add a nominated $ amount every 14 days. I use the formula...
May 27th 15 07:07 PM
by Michael Graubart Go to last post
2 1,528
IFERROR function with Hyperlink by [email protected]
Hi, I'm trying to use the IFERROR function with hyperlink functions. I want the worksheet function to work like this: IF the hyperlink to the specific...
0 1,072
Find Date Between? by [email protected]
Hello experts. I have an array of dates, like this: 08/07/2013 02/07/2014 08/07/2014 02/07/2015 08/07/2015 02/07/2016 08/07/2016 02/07/2017 08/07/2017
May 21st 15 01:11 AM
by Howard Silcock Go to last post
2 731
Inserting rows to linked Workbooks by Todd Gerdy
I have one workbook (inventory workbook sheet1) that pulls the information off of another workbook (data workbook sheet 1). If I try to insert a new row in the...
May 16th 15 05:59 AM
by GS[_6_] Go to last post
6 1,116
Using Vllookup with OFFSET or ??? by [email protected]
I'm trying to create a "Rollup" sheet with information from 5 other TABs. The TAB data is based on (for the example below) being in a TAB named AG (which is in...
0 593
Find duplicates w/3 criteria by [email protected]
I have tried various formulas to make this work and I'm spinning my wheels and hoping for help! I would like in column D a Y or N to indicate the cells in that...
May 11th 15 05:39 PM
by Claus Busch Go to last post
3 824
Vlookup and Countif by [email protected]
Good Day! I have a worksheet having "Names" in one column and "Status" (Pending or Complete) in the other column. I want to check name by comparing the...
May 11th 15 06:42 AM
by Claus Busch Go to last post
1 738
Convert YY[julian day] to dd-mmm-yy - Julian Date.xls (0/1) by Phrank
Hi, I'm trying to convert a 5 digit serial number to the manufacture date. The serial number is formatted as yy (e.g., 12080, which equates to a manufacture...
May 9th 15 07:18 PM
by Phrank Go to last post
2 949
Compare numbers based by day of the week and month by Emilio Guerra
Hello, I have to compare numbers based on day of week, since there are many fluctuations between weekdays and weekends. I have a spreadhseet for March and...
May 9th 15 11:23 AM
by trantrongtb Go to last post
2 830
Exclamation
Help ASAP with formula! by LouisCG3
Hello! So I am having a really BIG problem coming up with a formula.. Here's the issue: I have a number in E11 that is negative. I'm trying to subtract two...
May 8th 15 01:09 AM
by LouisCG3 Go to last post
4 706
Conditional formating Excel 2010 by [email protected]
Help please: I have some look up formulas on a spreadsheet and I have this row to showup red if a cell is larger than the median wich I have a formula at the...
0 602
Spreading number evenly over 165 days by LightningEclipse
I need an Excel file which can sort a given number (22) evenly across the days of a year (165) without decimals (so they need to be rounded), so that I can see...
April 29th 15 11:15 PM
by Don Guillett[_2_] Go to last post
1 752
Post New Thread


Display Options
Showing threads 201 to 220 of 88516
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:29 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.