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
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,378
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,773
Smile
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 515
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 446
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 775
Copy Pivot column from one Sheet to Another by [email protected]
Hi, I have the following vba command which copies the Pivot Data to another sheet, however I need to be more specific. I need to copy individual columns,...
2 462
Nested IF AND returning #VALUE! by Paul Doucette
I have what I thought was a simple formula I wanted to return a value based on the condition (TRUE or FALSE) of two cells. They are either both true, both...
(Multi-page thread 1 2)
July 9th 16 07:37 PM
by Paul Doucette Go to last post
11 787
I'm trying to use COUNTIFS to count how many times someone attendedtutoring, but in a data range such as 4-9 or 2-3 by [email protected]
I am using Countif to see how many people that attended one time got A's and that worked as =COUNTIFS(C36:C65,"1",B36:B65,"a") And when it came to attendance...
July 7th 16 08:24 PM
by Claus Busch Go to last post
1 486
How can I count items in a filtered list? by Counting filtered data.
I have an excel spread sheet table that I filter. I would like to be able to count the number of cells in the filtered data. Anyone know how to do this? CountA...
(Multi-page thread 1 2 3 ... Last Page)
36 3,999
Calculate Interest that 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...
June 29th 16 06:43 PM
by AdmiralAJ Go to last post
0 471
Edit & Paste link help by Martin [_4_]
Hello, I have 16 spredsheets with people like this who are Communicants G . McCormick Mr & Mrs J. John & Grace Address Town Postcode D. McCarley Mr & Mrs...
June 26th 16 11:29 AM
by Martin [_4_] Go to last post
0 455
combining MIN and MAX formulas... by DUV
I have a situation where i need the result to be constrained between two numbers . I can do the bottom and top constraints individually but cannot figure out...
June 24th 16 11:11 PM
by GS[_6_] Go to last post
5 585
How do I set a maximum value (e.g. cap at 200) by LeeLobb
I have a formula set to multiply a rate by a quantity, I then need to cap the total at 200 example: 42 people x 86 minutes x $0.05 = $180.60 but I need the...
June 24th 16 03:04 PM
by DUV Go to last post
7 35,542
Using the IF and VLOOKUP Function to calculate the tax rates and tax deducted by nerrawsl
I need to calculate the federal tax rate. The federal tax rate is a function of the adjusted income and the employee's marital status. Reference the tax tables...
June 14th 16 03:53 AM
by GS[_6_] Go to last post
3 1,773
Need formula to test if cell is a multiple of 28, but not including 28 by Wazzel
I have successfully used =IF(MOD(G3,28)=0 to identify whether my cell value is a multiple of 28, but I need for it to exclude 28 itself. The very simple...
June 10th 16 09:38 PM
by Wazzel Go to last post
4 893
left, search mid by [email protected]
Hello I have a spreadsheet send to me and the only thing I need to do is extract 2 numbers 1. I need to extract numbers between the first( )to one cell then...
June 7th 16 08:02 PM
by Claus Busch Go to last post
3 857
HOW DO I SEPERATE POSITIVE AND NEGATIVE VALUES FROM A COLUMN by FRANK
I HAVE A COLUMN OF FIGURES I WISH TO MAKE TWO MORE COLUMNS ONE SHOWING POSITIVE VALUES ONE SHOWING NEGATIVE VALUES
June 5th 16 05:56 AM
by Deb_z Go to last post
6 3,875
Countifs between a certain value by [email protected]
HI I need to count the values between a set value, and then only show how many times this count was more than 5. The values counted is variable only the...
June 3rd 16 09:29 PM
by Claus Busch Go to last post
3 693
Need Formula For Extracting Part Numbers by tb
I am using Excel 2010 for Windows. I have a database of part numbers like this one: 10_32M2A050A002 CYLINDER Please note that there are two blank spaces...
May 31st 16 10:57 PM
by tb Go to last post
3 762
Index / Match with condition by b_nuruddin
Part 1 I have a spreadsheet with two tabs. In the first tab (Sites) I want to populate column B with a "Y" or "N" based on whether or not the site exists in...
May 31st 16 06:22 PM
by b_nuruddin Go to last post
2 854
Post New Thread


Display Options
Showing threads 61 to 80 of 88510
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 12:34 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.