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
convert meters to feet/inches by Ann
i'm trying to convert from meters to feet and inches (not just feet or not just inches). so if i have 2 meters, i want the result to read 6 feet, 2 inches for...
(Multi-page thread 1 2 3)
June 28th 15 04:08 AM
by apdmu Go to last post
26 6,761
Convert Julian to Gregorian Date by [email protected]
Hi all, I have a whole bunch of Julian dates which I want to convert to Gregorian Dates. They are all in the period before 1900. Currently, I have the year,...
June 23rd 15 02:30 PM
by Hans Terkelsen Go to last post
1 1,111
filtering data by Nitya Satheesh
Hi ! My spreadsheet looks a little like the following a 2:10:43 4/10/15 a 2:15:34 4/10/15 a 2:45:23 4/10/15 a 4:45:34 5/10/15 a 6:40:15 6/10/15 a ...
June 23rd 15 11:34 AM
by Claus Busch Go to last post
4 1,055
column comparison by Nitya Satheesh
hi!, this is what my data looks like, A B 1 a 1 b 1 b 3 b 3 b 3 c
(Multi-page thread 1 2)
June 23rd 15 09:05 AM
by Nitya Satheesh Go to last post
15 2,048
pivot table by Nitya Satheesh
Hi ! I have a column of names which I need to include in a pivot table but I need the pivot table to show me only the unique count of names. NAme Month a ...
June 23rd 15 08:59 AM
by Nitya Satheesh Go to last post
2 943
1 Attachment(s) Progressing the date one day forward if conditions of time are met: by DrDave35
This is a little complicated for me, so I'm asking for your help. I'm still learning Excel, but I can't seem to figure out the formula for this...
June 19th 15 06:11 AM
by DrDave35 Go to last post
2 1,257
% of OI and % of vol by zoharb
find %-of-change-in-oi compared to OI of that strikeprice to total OI(sum b4: b16 for calls and h4:h16 for puts) ( should be for that strike-price only) ...
June 18th 15 07:13 PM
by zoharb Go to last post
0 975
What Function Will Get Me The Result I Need by [email protected]
Column A B C D Row 1 4 5 =A/B 2 5 10 =A/B 3 10 6 =A/B 4 8 12 =A/B I have...
June 18th 15 01:39 AM
by joeu2004[_2_] Go to last post
3 906
VBA question When I search to replace parentheses in excel it givesme "-" sign by [email protected]
To whom it may concern, I have this issue with one of my VBA files and I just can't figure it out. I have this search and replace macro that does a good job...
4 1,189
INDIRECT Function and adding cells across multiple sheets by Jade Sheldon
I have been searching for an answer to this problem for a couple days now, so hopefully someone can give me a little guidance. I have a workbook with multiple...
June 12th 15 12:23 AM
by MyVeryOwnSelf[_3_] Go to last post
2 975
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 1,012
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 1,136
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 917
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 978
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 902
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 655
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 981
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 721
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,638
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,200
Post New Thread


Display Options
Showing threads 201 to 220 of 88523
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 04:40 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.